diff options
Diffstat (limited to 'src/backend/utils/misc')
| -rw-r--r-- | src/backend/utils/misc/guc.c | 30 | ||||
| -rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 5 |
2 files changed, 34 insertions, 1 deletions
diff --git a/src/backend/utils/misc/guc.c b/src/backend/utils/misc/guc.c index bd8db1bb85b..25aef118e35 100644 --- a/src/backend/utils/misc/guc.c +++ b/src/backend/utils/misc/guc.c @@ -10,7 +10,7 @@ * Written by Peter Eisentraut <peter_e@gmx.net>. * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/utils/misc/guc.c,v 1.170 2003/11/16 16:41:01 wieck Exp $ + * $Header: /cvsroot/pgsql/src/backend/utils/misc/guc.c,v 1.171 2003/11/19 15:55:08 wieck Exp $ * *-------------------------------------------------------------------- */ @@ -44,6 +44,7 @@ #include "optimizer/prep.h" #include "parser/parse_expr.h" #include "parser/parse_relation.h" +#include "storage/bufmgr.h" #include "storage/fd.h" #include "storage/freespace.h" #include "storage/lock.h" @@ -1200,6 +1201,33 @@ static struct config_int ConfigureNamesInt[] = 0, 0, 600, NULL, NULL }, + { + {"bgwriter_delay", PGC_SIGHUP, RESOURCES, + gettext_noop("Background writer sleep time between rounds in milliseconds"), + NULL + }, + &BgWriterDelay, + 200, 10, 5000, NULL, NULL + }, + + { + {"bgwriter_percent", PGC_SIGHUP, RESOURCES, + gettext_noop("Background writer percentage of dirty buffers to flush per round"), + NULL + }, + &BgWriterPercent, + 1, 0, 100, NULL, NULL + }, + + { + {"bgwriter_maxpages", PGC_SIGHUP, RESOURCES, + gettext_noop("Background writer maximum number of pages to flush per round"), + NULL + }, + &BgWriterMaxpages, + 100, 1, 1000, NULL, NULL + }, + /* End-of-list marker */ { {NULL, 0, 0, NULL, NULL}, NULL, 0, 0, 0, NULL, NULL diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index 64e94edab96..e4305d98596 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -60,6 +60,11 @@ #vacuum_mem = 8192 # min 1024, size in KB #debug_shared_buffers = 0 # 0-600 seconds +# - Background writer - +#bgwriter_delay = 200 # 10-5000 milliseconds +#bgwriter_percent = 1 # 0-100% of dirty buffers +#bgwriter_maxpages = 100 # 1-1000 buffers max at once + # - Free Space Map - #max_fsm_pages = 20000 # min max_fsm_relations*16, 6 bytes each |