Matt Pearson

Recent stories

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 ...

7 min read
Your Complete Guide: Point-In-Time-Restore (PITR) using pg_basebackup

Your Complete Guide: Point-In-Time-Restore (PITR) using pg_basebackup


Point-In-Time-Restore using pg_basebackup on PostgreSQL I had a conversation with another DBA about interview ...

7 min read

More stories