PostgreSQLFilesystemSRE
PostgreSQL disk full: an inactive replication slot kept all the WAL
pg_wal filled the disk and PostgreSQL PANICked. Free space safely, find the slot that pins the WAL, drop it, and cap it with max_slot_wal_keep_size.
Connections, locks, VACUUM, WAL and replication: PostgreSQL incidents from the server side.
3 postsRSS feed
pg_wal filled the disk and PostgreSQL PANICked. Free space safely, find the slot that pins the WAL, drop it, and cap it with max_slot_wal_keep_size.
A metadata-only ALTER TABLE waits for its lock behind one long transaction, and every query queues behind it. See the queue, cancel it, use lock_timeout.
max_connections is a budget that every pod's pool spends. How to get in when it is gone, find who took it, stop the bleeding without a restart, and pool.