diff options
| author | Jan Wieck <JanWieck@Yahoo.com> | 2003-11-19 15:55:08 +0000 |
|---|---|---|
| committer | Jan Wieck <JanWieck@Yahoo.com> | 2003-11-19 15:55:08 +0000 |
| commit | cfeca62148582a05466362f1957572f5a9900ab5 (patch) | |
| tree | 6a2c5086a40d410ceb8555d8f94b7f5492979283 /src/backend/utils/misc | |
| parent | 5032f83082e5bdb37f8dbf02fa00c4886fb6d2ce (diff) | |
| download | postgresql-cfeca62148582a05466362f1957572f5a9900ab5.tar.gz postgresql-cfeca62148582a05466362f1957572f5a9900ab5.zip | |
Background writer process
This first part of the background writer does no syncing at all.
It's only purpose is to keep the LRU heads clean so that regular
backends seldom to never have to call write().
Jan
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 |