diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2007-04-16 18:30:04 +0000 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2007-04-16 18:30:04 +0000 |
| commit | e2a186b03cc1a87cf26644db18f28a20f10bd739 (patch) | |
| tree | a11e944e89e9757808f6d86dc9aa79ea6a94948a /src/backend/utils/misc/postgresql.conf.sample | |
| parent | 42dc4b66e61cde4beb466561f12fd490b6621ee3 (diff) | |
| download | postgresql-e2a186b03cc1a87cf26644db18f28a20f10bd739.tar.gz postgresql-e2a186b03cc1a87cf26644db18f28a20f10bd739.zip | |
Add a multi-worker capability to autovacuum. This allows multiple worker
processes to be running simultaneously. Also, now autovacuum processes do not
count towards the max_connections limit; they are counted separately from
regular processes, and are limited by the new GUC variable
autovacuum_max_workers.
The launcher now has intelligence to launch workers on each database every
autovacuum_naptime seconds, limited only on the max amount of worker slots
available.
Also, the global worker I/O utilization is limited by the vacuum cost-based
delay feature. Workers are "balanced" so that the total I/O consumption does
not exceed the established limit. This part of the patch was contributed by
ITAGAKI Takahiro.
Per discussion.
Diffstat (limited to 'src/backend/utils/misc/postgresql.conf.sample')
| -rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index 22f9685bbdc..bc5b642d029 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -376,6 +376,7 @@ #autovacuum = on # enable autovacuum subprocess? # 'on' requires stats_start_collector # and stats_row_level to also be on +#autovacuum_max_workers = 3 # max # of autovacuum subprocesses #autovacuum_naptime = 1min # time between autovacuum runs #autovacuum_vacuum_threshold = 500 # min # of tuple updates before # vacuum |