projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: ab7d2b6) | 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)
commit53d2951be7687089885865f31949eda87439a80b
treece5cfa88e8702a50de1238eb4c8455ef38c6a7e5tree
parentab7d2b6a7376a7a3542201899aff9e953414ca81commit | 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
This is the main PostgreSQL git repository.