public inbox for [email protected]  

help / color / mirror / Atom feed

From: David Fetter <[email protected]>
To: PostgreSQL Docs <[email protected]>
To: PostgreSQL Patches <[email protected]>
Subject: Autovacuum and XID wraparound
Date: Sun, 13 May 2007 18:17:40 -0700
Message-ID: <[email protected]> (raw)

Folks,

Per Neil Conway, here's some doc patches re: the autovacuum daemon's
behavior.  Should this be back-patched to 8.2x?

Cheers,
D
-- 
David Fetter <[email protected]> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666
                              Skype: davidfetter

Remember to vote!
Consider donating to PostgreSQL: http://www.postgresql.org/about/donate

Index: doc/src/sgml/config.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/config.sgml,v
retrieving revision 1.122
diff -c -r1.122 config.sgml
*** doc/src/sgml/config.sgml	20 Apr 2007 02:37:37 -0000	1.122
--- doc/src/sgml/config.sgml	14 May 2007 01:16:02 -0000
***************
*** 3172,3177 ****
--- 3172,3185 ----
          This parameter can only be set in the <filename>postgresql.conf</>
          file or on the server command line.
         </para>
+        <note>
+         <para>
+           Even when this variable is set to off, the autovacuum daemon
+           will run periodically in order to prevent transaction_id
+           wraparound.  See <xref linkend="vacuum-for-wraparound"> for
+           more information.
+         </para>
+        </note>
        </listitem>
       </varlistentry>
  
Index: src/backend/utils/misc/postgresql.conf.sample
===================================================================
RCS file: /projects/cvsroot/pgsql/src/backend/utils/misc/postgresql.conf.sample,v
retrieving revision 1.215
diff -c -r1.215 postgresql.conf.sample
*** src/backend/utils/misc/postgresql.conf.sample	18 Apr 2007 16:44:18 -0000	1.215
--- src/backend/utils/misc/postgresql.conf.sample	14 May 2007 01:16:02 -0000
***************
*** 372,377 ****
--- 372,379 ----
  #---------------------------------------------------------------------------
  # AUTOVACUUM PARAMETERS
  #---------------------------------------------------------------------------
+ # Note: even when autovacuum is turned off, the autovacuum daemon will
+ # run in order to prevent transaction id wraparound.
  
  #autovacuum = on			# enable autovacuum subprocess?
  					# 'on' requires stats_start_collector


Attachments:

  [text/plain] autovacuum_xid_wraparound.diff (1.7K, 2-autovacuum_xid_wraparound.diff)
  download | inline diff:
Index: doc/src/sgml/config.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/config.sgml,v
retrieving revision 1.122
diff -c -r1.122 config.sgml
*** doc/src/sgml/config.sgml	20 Apr 2007 02:37:37 -0000	1.122
--- doc/src/sgml/config.sgml	14 May 2007 01:16:02 -0000
***************
*** 3172,3177 ****
--- 3172,3185 ----
          This parameter can only be set in the <filename>postgresql.conf</>
          file or on the server command line.
         </para>
+        <note>
+         <para>
+           Even when this variable is set to off, the autovacuum daemon
+           will run periodically in order to prevent transaction_id
+           wraparound.  See <xref linkend="vacuum-for-wraparound"> for
+           more information.
+         </para>
+        </note>
        </listitem>
       </varlistentry>
  
Index: src/backend/utils/misc/postgresql.conf.sample
===================================================================
RCS file: /projects/cvsroot/pgsql/src/backend/utils/misc/postgresql.conf.sample,v
retrieving revision 1.215
diff -c -r1.215 postgresql.conf.sample
*** src/backend/utils/misc/postgresql.conf.sample	18 Apr 2007 16:44:18 -0000	1.215
--- src/backend/utils/misc/postgresql.conf.sample	14 May 2007 01:16:02 -0000
***************
*** 372,377 ****
--- 372,379 ----
  #---------------------------------------------------------------------------
  # AUTOVACUUM PARAMETERS
  #---------------------------------------------------------------------------
+ # Note: even when autovacuum is turned off, the autovacuum daemon will
+ # run in order to prevent transaction id wraparound.
  
  #autovacuum = on			# enable autovacuum subprocess?
  					# 'on' requires stats_start_collector

view thread (34+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Autovacuum and XID wraparound
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox