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/include/miscadmin.h | |
| 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/include/miscadmin.h')
| -rw-r--r-- | src/include/miscadmin.h | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/include/miscadmin.h b/src/include/miscadmin.h index ca5cc799c51..c5090581c59 100644 --- a/src/include/miscadmin.h +++ b/src/include/miscadmin.h @@ -13,7 +13,7 @@ * Portions Copyright (c) 1996-2007, PostgreSQL Global Development Group * Portions Copyright (c) 1994, Regents of the University of California * - * $PostgreSQL: pgsql/src/include/miscadmin.h,v 1.193 2007/03/01 14:52:04 petere Exp $ + * $PostgreSQL: pgsql/src/include/miscadmin.h,v 1.194 2007/04/16 18:29:56 alvherre Exp $ * * NOTES * some of the information in this file should be moved to other files. @@ -129,6 +129,7 @@ extern DLLIMPORT char *DataDir; extern DLLIMPORT int NBuffers; extern int MaxBackends; +extern int MaxConnections; extern DLLIMPORT int MyProcPid; extern DLLIMPORT struct Port *MyProcPort; |