#autovacuum

Postgres Autovacuum Stalled by a Long-Running Transaction

Table bloat grows, queries get slower, and pg_stat_progress_vacuum shows nothing running. A single forgotten transaction is holding back the entire vacuum horizon.