From: Neil Conway <neilc@samurai.com>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Bruce Momjian <bruce@momjian.us>
Cc: David Fetter <david@fetter.org>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL Docs <pgsql-docs@postgresql.org>
Cc: PostgreSQL Patches <pgsql-patches@postgresql.org>
Subject: Re: [PATCHES] Autovacuum and XID wraparound
Date: Tue, 15 May 2007 11:54:09 -0400
Message-ID: <1179244449.6057.0.camel@goldbach> (raw)
In-Reply-To: <20070515130718.GA5339@alvh.no-ip.org>
References: <200705142022.l4EKMNq20973@momjian.us>
<1179197343.6047.47.camel@goldbach>
<20070515130718.GA5339@alvh.no-ip.org>
On Tue, 2007-15-05 at 09:07 -0400, Alvaro Herrera wrote:
> I agree, the note should be added there (but it should be a short one
> and refer the reader someplace else for more complete details).
I've applied the attached patch to HEAD and REL8_2_STABLE.
-Neil
Attachments:autovacuum_xid_wraparound-2.diff (text/x-patch, 917B) download
Index: doc/src/sgml/config.sgml
===================================================================
RCS file: /home/neilc/postgres/cvs_root/pgsql/doc/src/sgml/config.sgml,v
retrieving revision 1.122
diff -c -p -r1.122 config.sgml
*** doc/src/sgml/config.sgml 20 Apr 2007 02:37:37 -0000 1.122
--- doc/src/sgml/config.sgml 15 May 2007 15:04:35 -0000
*************** SELECT * FROM parent WHERE key = 2400;
*** 3172,3177 ****
--- 3172,3183 ----
This parameter can only be set in the <filename>postgresql.conf</>
file or on the server command line.
</para>
+ <para>+ Note that even when this parameter is disabled, the system+ will periodically launch autovacuum processes in order to+ prevent transaction ID wraparound. See <xref+ linkend="vacuum-for-wraparound"> for more information.+ </para>
</listitem>
</varlistentry>
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: pgsql-docs@postgresql.org
Cc: neilc@samurai.com, alvherre@commandprompt.com, bruce@momjian.us, david@fetter.org, tgl@sss.pgh.pa.us, pgsql-patches@postgresql.org
Subject: Re: [PATCHES] Autovacuum and XID wraparound
In-Reply-To: <1179244449.6057.0.camel@goldbach>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox