Latest Articles

Shrinking Big PostgreSQL tables: Copy-Swap-Drop

In this post, you’ll learn a recipe that you can use to “shrink” a large table. This is a good fit when only a portion of the data is accessed, the big table has become unwieldy, and you don’t want...

Wait a minute! — PostgreSQL extension pg_wait_sampling

PostgreSQL uses a complex system of locks to balance concurrent operations and data consistency, across many transactions. Those intricacies are beyond the scope of this post. Here we want to specifically look at queries that are waiting, whether on locks...