Postgres Autovacuum Stalled by a Long-Running Transaction
Dead tuples climb, the table bloats, and VACUUM logs say dead but not yet removable. One forgotten transaction is pinning the xmin horizon so vacuum reclaims nothing. Find and kill it.
#postgres
Articles tagged with #postgres
Postgres Connection Pool Exhausted Under Load
Postgres throws 'remaining connection slots reserved' under traffic. Fix it by sizing the pool, putting PgBouncer in transaction mode in front, and killing idle-in-transaction connections.