Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id A756B9FB743; Mon, 14 May 2007 17:23:34 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 68089-01; Mon, 14 May 2007 17:23:19 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from momjian.us (momjian.us [70.90.9.53]) by postgresql.org (Postfix) with ESMTP id AB48D9FBCD7; Mon, 14 May 2007 17:22:26 -0300 (ADT) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id l4EKMNq20973; Mon, 14 May 2007 16:22:23 -0400 (EDT) From: Bruce Momjian Message-Id: <200705142022.l4EKMNq20973@momjian.us> Subject: Re: Autovacuum and XID wraparound In-Reply-To: <20070514021502.GL14860@fetter.org> To: David Fetter Date: Mon, 14 May 2007 16:22:23 -0400 (EDT) CC: Tom Lane , PostgreSQL Docs , PostgreSQL Patches X-Mailer: ELM [version 2.4ME+ PL123] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/35 X-Sequence-Number: 4264 David Fetter wrote: > On Sun, May 13, 2007 at 10:06:40PM -0400, Tom Lane wrote: > > David Fetter writes: > > > Per Neil Conway, here's some doc patches re: the autovacuum > > > daemon's behavior. Should this be back-patched to 8.2x? > > > > This fact is already documented in at least three places; do we > > really need two more? > > Yes. > > > The proposed addition to postgresql.conf seems particularly > > over-the-top, since there is no entry in that file that even > > pretends to offer a complete description of the associated behavior. > > I think that a boolean that doesn't do what you expect booleans to do, > i.e. turn the thing all the way off, is worth a mention. I agree with Tom. I don't think the current behavior is a major issue for users for it to be mentioned more than it already is, though if you want to move one of those, we can do that. -- Bruce Momjian http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +