Received: from localhost (maia-5.hub.org [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id C79189FB689;
	Tue, 15 May 2007 12:54:19 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024)
	with ESMTP id 32617-03; Tue, 15 May 2007 12:54:11 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from mailbox.samurai.com (mailbox.samurai.com [205.207.28.82])
	by postgresql.org (Postfix) with ESMTP id 28A499FB4D9;
	Tue, 15 May 2007 12:54:12 -0300 (ADT)
Received: from localhost (mailbox.samurai.com [205.207.28.82])
	by mailbox.samurai.com (Postfix) with ESMTP id 9889E61D31;
	Tue, 15 May 2007 11:54:11 -0400 (EDT)
X-Virus-Scanned: by amavisd-new at mailbox.samurai.com
Received: from mailbox.samurai.com ([205.207.28.82])
	by localhost (mailbox.samurai.com [205.207.28.82]) (amavisd-new,
	port 10024)
	with LMTP id YrVE9Bs7on+v; Tue, 15 May 2007 11:54:09 -0400 (EDT)
Received: from [192.168.0.101]
	(CPE3285f62f0d42-CM0011aec5ebbc.cpe.net.cable.rogers.com
	[74.103.69.144]) (using TLSv1 with cipher RC4-MD5 (128/128 bits))
	(No client certificate requested)
	by mailbox.samurai.com (Postfix) with ESMTP id CC85561C8B;
	Tue, 15 May 2007 11:54:09 -0400 (EDT)
Subject: Re: [PATCHES] Autovacuum and XID wraparound
From: Neil Conway <neilc@samurai.com>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Bruce Momjian <bruce@momjian.us>, David Fetter <david@fetter.org>,
	Tom Lane <tgl@sss.pgh.pa.us>, PostgreSQL Docs <pgsql-docs@postgresql.org>,
	PostgreSQL Patches <pgsql-patches@postgresql.org>
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>
Content-Type: multipart/mixed; boundary="=-vVZdsNd0TyWo74V06fQZ"
Date: Tue, 15 May 2007 11:54:09 -0400
Message-Id: <1179244449.6057.0.camel@goldbach>
Mime-Version: 1.0
X-Mailer: Evolution 2.10.1 
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200705/41
X-Sequence-Number: 4270


--=-vVZdsNd0TyWo74V06fQZ
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

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


--=-vVZdsNd0TyWo74V06fQZ
Content-Disposition: attachment; filename=autovacuum_xid_wraparound-2.diff
Content-Type: text/x-patch; name=autovacuum_xid_wraparound-2.diff;
	charset=utf-8
Content-Transfer-Encoding: 7bit

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>
  

--=-vVZdsNd0TyWo74V06fQZ--