Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 689219FBB56 for ; Tue, 15 May 2007 21:25:10 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 37469-07 for ; Tue, 15 May 2007 21:25:01 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id DE3DE9FBB95 for ; Tue, 15 May 2007 21:25:06 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 3FF3E56445; Tue, 15 May 2007 19:25:05 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Tue, 15 May 2007 19:25:01 -0500 Date: Tue, 15 May 2007 19:25:00 -0500 From: "Jim C. Nasby" To: Alvaro Herrera Cc: Tom Lane , Chris Browne , pgsql-patches@postgresql.org Subject: Re: [DOCS] Autovacuum and XID wraparound Message-ID: <20070516002500.GG20707@nasby.net> 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> X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:070516:alvherre@commandprompt.com::SOsyQXHEpBiPLVIj:00000000000 00000000000000000000000005DG X-Hashcash: 1:20:070516:tgl@sss.pgh.pa.us::VkM+SFgebL3w3RIO:00000000000000000000 0000000000000000000000001tFU X-Hashcash: 1:20:070516:cbbrowne@acm.org::YcZzV6PYq0pm1Mf8:04d3H X-Hashcash: 1:20:070516:pgsql-patches@postgresql.org::JDC0UJpXCgtX5oIJ:000000000 0000000000000000000000006vox X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/223 X-Sequence-Number: 2323 On Tue, May 15, 2007 at 06:13:47PM -0400, 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. Actually, it already happens for CLUSTER because cluster calls heap_create_with_catalog, which calls AddNewRelationTuple. See backend/catalog/heap.c line 716. -- Jim Nasby decibel@decibel.org EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)