I am pondering about this... My thinking is that since *_scale_factor need to be set manually for largish tables (>1M), why not set autovacuum_vacuum_scale_factor and autovacuum_analyze_scale_factor, and increase the value of
autovacuum_vacuum_threshold to, say, 10000, and autovacuum_analyze_threshold to 2500 ? What do you think ?
Also, with systems handling 8k-10k tps and dedicated to a single database, would there be any cons to decreasing autovacuum_naptime to say 15s, so that the system perf is less spiky ?
Sébastien