PostgreSQL

Autovacuum falling behind on tables causes bloat accumulation

warning
Resource ContentionUpdated Feb 15, 2026
Technologies:
How to detect:

Autovacuum processes cannot keep up with table update rates, allowing dead tuples to accumulate. pgwatch monitors autovacuum activity to detect this condition.

Recommended action:

Check pgwatch autovacuum activity dashboards or query pg_stat_user_tables for last_autovacuum timestamps and n_dead_tup counts. Increase autovacuum_max_workers, adjust autovacuum thresholds (autovacuum_vacuum_threshold, autovacuum_vacuum_scale_factor), or schedule manual VACUUM during maintenance windows.