#autovacuum

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.