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