Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id CDF639FB39B for ; Wed, 16 May 2007 14:29:04 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 13975-02 for ; Wed, 16 May 2007 14:28:59 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id 08A1F9FB29D for ; Wed, 16 May 2007 14:28:58 -0300 (ADT) Received: from perhan.alvh.no-ip.org (201-221-217-243.bk12-dsl.surnet.cl [201.221.217.243]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l4GHSrnI021902; Wed, 16 May 2007 10:28:54 -0700 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 7AFDC32A13; Wed, 16 May 2007 13:28:50 -0400 (CLT) Date: Wed, 16 May 2007 13:28:50 -0400 From: Alvaro Herrera To: Tom Lane Cc: Chris Browne , pgsql-patches@postgresql.org Subject: Re: [DOCS] Autovacuum and XID wraparound Message-ID: <20070516172850.GF4582@alvh.no-ip.org> References: <20070514011740.GH14860@fetter.org> <23394.1179108400@sss.pgh.pa.us> <1179117269.6047.3.camel@goldbach> <60sl9z6tln.fsf@dba2.int.libertyrms.com> <20070514221619.GC8916@alvh.no-ip.org> <857.1179184222@sss.pgh.pa.us> <20070515221347.GT12731@alvh.no-ip.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20070515221347.GT12731@alvh.no-ip.org> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: ClamAV version 0.88.5, clamav-milter version 0.88.5 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Wed, 16 May 2007 10:28:54 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/246 X-Sequence-Number: 2346 Alvaro Herrera wrote: > Tom Lane wrote: > > Alvaro Herrera writes: > > > I suppose it would be pretty trivial to set the relfrozenxid to > > > RecentXmin or something during TRUNCATE. > > > > I had the idea we were doing that already --- at least I'm pretty sure I > > remember it being discussed. But I see it's not being done in HEAD. > > Patch to do it attached. I am thinking we can do something similar in > CLUSTER as well. Applied. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.