autovacuum_analyze_scale_factor
No restart — takes effect on reloadtuned by pgconfiguratorratio (fraction of table)
Fraction of a table that must change before autovacuum re-runs ANALYZE.
What pgconfigurator would set
32 GB · 8 vCPU · NVMe · OLTP
Computing…
Tune for your exact server → /tunecomputed in your browser · nothing uploaded
What it does
Controls when autovacuum refreshes a table's planner statistics: after autovacuum_analyze_threshold + this fraction × table size rows have changed. The default 0.1 means ~10% churn triggers a re-ANALYZE.
How to tune it
Stale statistics cause bad row estimates and bad plans. On large tables with shifting data distributions, lower it so the planner's stats stay current. Pair with default_statistics_target when estimates are still off.
What the analyzer flags
- Bad row estimate — often stale statistics