diff options
| author | Simon Riggs <simon@2ndQuadrant.com> | 2010-01-29 18:39:05 +0000 |
|---|---|---|
| committer | Simon Riggs <simon@2ndQuadrant.com> | 2010-01-29 18:39:05 +0000 |
| commit | 6d2bc0a6cf5c8d9a3241a0d7afaf5ca8bf1f11ec (patch) | |
| tree | a99f7e3490d28b3546b909796ad76c8b6322cf72 /src/backend/utils/misc/postgresql.conf.sample | |
| parent | d0cfc018233b4cdcab28d460ee0e14dbf87ac4ce (diff) | |
| download | postgresql-6d2bc0a6cf5c8d9a3241a0d7afaf5ca8bf1f11ec.tar.gz postgresql-6d2bc0a6cf5c8d9a3241a0d7afaf5ca8bf1f11ec.zip | |
Augment WAL records for btree delete with GetOldestXmin() to reduce
false positives during Hot Standby conflict processing. Simple
patch to enhance conflict processing, following previous discussions.
Controlled by parameter minimize_standby_conflicts = on | off, with
default off allows measurement of performance impact to see whether
it should be set on all the time.
Diffstat (limited to 'src/backend/utils/misc/postgresql.conf.sample')
| -rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index 95cab4d64fd..928ccc76edf 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -181,7 +181,10 @@ #archive_timeout = 0 # force a logfile segment switch after this # number of seconds; 0 disables +# - Hot Standby - + #recovery_connections = on # allows connections during recovery +#minimize_standby_conflicts = on # additional WAL info to avoid conflicts #max_standby_delay = 30 # max acceptable standby lag (s) to help queries # complete without conflict; -1 disables |