Blog
Notes on running PostgreSQL in production: lock chains, transaction ID wraparound, replication slots, monitoring without superuser.
-
Why one ALTER TABLE can stop every query in Postgres
A migration waiting for ACCESS EXCLUSIVE puts every later query on the table in line behind it. How the lock queue works, how to spot it, how to avoid it.
-
An inactive replication slot is filling your disk
A replication slot keeps WAL until its consumer confirms it. When the consumer is gone, pg_wal grows until the disk fills. How to find the slot and fix it.