diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2001-02-26 00:50:08 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2001-02-26 00:50:08 +0000 |
| commit | 9c9936587c6a9aeb8b425a499cf73e5e7af38ddd (patch) | |
| tree | f1d7328907a9ffb8a9319b689a9bb40f7e1d0313 /src/backend/utils/misc/postgresql.conf.sample | |
| parent | 60774e821060dd6d6395504d4ccda107d2a71a42 (diff) | |
| download | postgresql-9c9936587c6a9aeb8b425a499cf73e5e7af38ddd.tar.gz postgresql-9c9936587c6a9aeb8b425a499cf73e5e7af38ddd.zip | |
Implement COMMIT_SIBLINGS parameter to allow pre-commit delay to occur
only if at least N other backends currently have open transactions. This
is not a great deal of intelligence about whether a delay might be
profitable ... but it beats no intelligence at all. Note that the default
COMMIT_DELAY is still zero --- this new code does nothing unless that
setting is changed.
Also, mark ENABLEFSYNC as a system-wide setting. It's no longer safe to
allow that to be set per-backend, since we may be relying on some other
backend's fsync to have synced the WAL log.
Diffstat (limited to 'src/backend/utils/misc/postgresql.conf.sample')
| -rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index 7670fdffab4..f599d97cff4 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -109,7 +109,8 @@ #wal_files = 0 # range 0-64 #wal_debug = 0 # range 0-16 #commit_delay = 0 # range 0-100000 -#checkpoint_timeout = 300 # range 30-1800 +#commit_siblings = 5 # range 1-1000 +#checkpoint_timeout = 300 # in seconds, range 30-3600 # |