projects / users / simon / postgres.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 952cc1e) | patch
Set a default autovacuum vacuum_cost_delay value of 20ms, to avoid excessive
authorAlvaro Herrera <alvherre@alvh.no-ip.org>
Tue, 24 Jul 2007 01:53:56 +0000 (01:53 +0000)
committerAlvaro Herrera <alvherre@alvh.no-ip.org>
Tue, 24 Jul 2007 01:53:56 +0000 (01:53 +0000)
commitbb45a7fe4d854b2502a6885a18fdfdb77a51e155
treeb07f1031d0cecb1d1a3884baeb9e727f8dcf4ffctree
parent952cc1ec61b55582941ede33d9d6443bbe0bf9ebcommit | diff
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.
doc/src/sgml/config.sgml diff | blob | blame | history
src/backend/utils/misc/guc.c diff | blob | blame | history
src/backend/utils/misc/postgresql.conf.sample diff | blob | blame | history
Simon's dev repository