From 6d2bc0a6cf5c8d9a3241a0d7afaf5ca8bf1f11ec Mon Sep 17 00:00:00 2001 From: Simon Riggs Date: Fri, 29 Jan 2010 18:39:05 +0000 Subject: 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. --- src/backend/utils/misc/guc.c | 13 ++++++++++++- 1 file changed, 12 insertions(+), 1 deletion(-) (limited to 'src/backend/utils/misc/guc.c') diff --git a/src/backend/utils/misc/guc.c b/src/backend/utils/misc/guc.c index 00ea55d5979..adf9f72b359 100644 --- a/src/backend/utils/misc/guc.c +++ b/src/backend/utils/misc/guc.c @@ -10,7 +10,7 @@ * Written by Peter Eisentraut . * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/utils/misc/guc.c,v 1.536 2010/01/26 16:33:40 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/utils/misc/guc.c,v 1.537 2010/01/29 18:39:05 sriggs Exp $ * *-------------------------------------------------------------------- */ @@ -1222,6 +1222,17 @@ static struct config_bool ConfigureNamesBool[] = true, NULL, NULL }, + { + {"minimize_standby_conflicts", PGC_POSTMASTER, WAL_SETTINGS, + gettext_noop("Additional information is added to WAL records to" + " minimize the number of false positive cancelations" + " caused by recovery conflicts on WAL standby nodes."), + NULL + }, + &MinimizeStandbyConflicts, + false, NULL, NULL + }, + { {"allow_system_table_mods", PGC_POSTMASTER, DEVELOPER_OPTIONS, gettext_noop("Allows modifications of the structure of system tables."), -- cgit v1.2.3