Set a default autovacuum vacuum_cost_delay value of 20ms, to avoid excessive
Alvaro Herrera <alvherre@alvh.no-ip.org>
Set a default autovacuum vacuum_cost_delay value of 20ms, to avoid excessive I/O utilization, per discussion. While at it, lower the autovacuum vacuum and analyze threshold values to 50 tuples. It is a bit higher (i.e. more conservative) than what I originally proposed but much better than the old values for small tables.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/config.sgml | modified | +5 −4 |
| src/backend/utils/misc/guc.c | modified | +4 −4 |
| src/backend/utils/misc/postgresql.conf.sample | modified | +3 −3 |