Tuning autovacuum on busy PostgreSQL tables
September 2026
Default autovacuum thresholds are tuned for small tables. For tables with tens of millions of rows we lower the scale factor and set per-table thresholds.
Questions or corrections are welcome via the contact page.