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 /doc/src/sgml | |
| parent | d0cfc018233b4cdcab28d460ee0e14dbf87ac4ce (diff) | |
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 'doc/src/sgml')
| -rw-r--r-- | doc/src/sgml/config.sgml | 18 | 
1 files changed, 17 insertions, 1 deletions
| diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 71097ee21c8..c8c30c98415 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.246 2010/01/26 16:33:40 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.247 2010/01/29 18:39:05 sriggs Exp $ -->  <chapter Id="runtime-config">    <title>Server Configuration</title> @@ -1840,6 +1840,22 @@ archive_command = 'copy "%p" "C:\\server\\archivedir\\%f"'  # Windows        </listitem>       </varlistentry> +     <varlistentry id="minimize-standby-conflicts" xreflabel="minimize_standby_conflicts"> +      <term><varname>minimize_standby_conflicts</varname> (<type>boolean</type>)</term> +      <indexterm> +       <primary><varname>minimize_standby_conflicts</> configuration parameter</primary> +      </indexterm> +      <listitem> +       <para> +        Generates additional information to the transaction log (WAL) to minimize +        the number of false positive cancelations caused by recovery conflicts on +        a standby server that consumes WAL data from this server. +        There is additional performance cost to enabling this parameter. +        Parameter has no effect during recovery, only in normal running. +       </para> +      </listitem> +     </varlistentry> +       </variablelist>      </sect2>     </sect1> | 
