Tune autovacuum per-table on high-churn tables so dead tuples and bloat don't degrade performance.
Default autovacuum thresholds scale with table size, so large high-update tables vacuum too rarely, accumulating bloat and stale planner stats.
BeforeMerge scans your pull requests against this rule and dozens more. Get actionable feedback before code ships.
MVCC leaves dead tuples behind on every UPDATE/DELETE; autovacuum reclaims them and refreshes statistics. The default scale-factor thresholds mean very large or high-churn tables get vacuumed too infrequently, causing bloat, index growth, and stale stats that mislead the planner. Lower the per-table scale factors for these tables.
-- bad: relies on cluster defaults for a hot table
-- good
ALTER TABLE events SET (
autovacuum_vacuum_scale_factor = 0.02,
autovacuum_analyze_scale_factor = 0.01
);