Reduce the maximum value of vacuum_cost_delay and autovacuum_vacuum_cost_delay
Tom Lane <tgl@sss.pgh.pa.us>
Reduce the maximum value of vacuum_cost_delay and autovacuum_vacuum_cost_delay to 100ms (from 1000). This still seems to be comfortably larger than the useful range of the parameter, and it should help discourage people from picking uselessly large values. Tweak the documentation to recommend small values, too. Per discussion of a couple weeks ago.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/config.sgml | modified | +10 −2 |
| src/backend/access/common/reloptions.c | modified | +2 −2 |
| src/backend/utils/misc/guc.c | modified | +3 −3 |
| src/backend/utils/misc/postgresql.conf.sample | modified | +1 −1 |
| src/test/regress/expected/guc.out | modified | +33 −33 |
| src/test/regress/sql/guc.sql | modified | +12 −12 |