Matt Pearson

Recent stories

One of the hidden mechanics of PostgreSQL may not seem important at first

One of the hidden mechanics of PostgreSQL may not seem important at first


When you INSERT a row into some databases like Oracle, the row is only written to the datafile, once the row has been ...

6 min read
What is the Best Way to Shrink Your Tables in PostgreSQL?

What is the Best Way to Shrink Your Tables in PostgreSQL?


In PostgreSQL (PG), there are two issues when it comes to table bloat. One is a consequence of the MVCC (Multi-Version ...

11 min read
New Features for DBA's in PostgreSQL 16

New Features for DBA's in PostgreSQL 16


16 has just been launched, and this year, we have a raft of new features to look through and evaluate. Many of these ...

11 min read

More stories