Reduce the maximum value of vacuum_cost_delay and autovacuum_vacuum_cost_delay
authorTom Lane <tgl@sss.pgh.pa.us>
Sat, 28 Feb 2009 00:10:52 +0000 (00:10 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Sat, 28 Feb 2009 00:10:52 +0000 (00:10 +0000)
commite8ea978fbb14ebb1f6cfd064cc44ee28f1952b03
tree41464f6e31d33726b74e420472ab26761b796c8e
parent42366690a0f3798eebdcefeb2ed67c1e66c48f1e
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.
doc/src/sgml/config.sgml
src/backend/access/common/reloptions.c
src/backend/utils/misc/guc.c
src/backend/utils/misc/postgresql.conf.sample
src/test/regress/expected/guc.out
src/test/regress/sql/guc.sql