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)
commit640796ff4122c01ab96780cbbee88479c3694907
treef4450a66cbf40a3882cadab72b44a8c64be012dc
parent07b9936a0f10d746e5076239813a5e938f2f16be
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