Summarizing this thread, I see support for the following:
- autovacuum set to on by default in 8.2.
- stats_row_level also defaults to on.
(Perhaps stats_block_level should also default to on so it's not inconsistent,
seeing that everything else in on, too.)
- Delayed vacuum and delayed autovacuum will stay disabled.
- Scale factor set to 0.08 (vacuum) and 0.04 (analyze) (?) (formerly 0.4 and
0.2)
- Leave base thresholds alone (pending further analysis that might remove them
altogether?)
--
Peter Eisentraut
http://developer.postgresql.org/~petere/