Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 684E79FB6AA for ; Mon, 14 May 2007 20:10:32 -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 09317-05 for ; Mon, 14 May 2007 20:10:17 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 7DB609FB5C8 for ; Mon, 14 May 2007 20:10:27 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l4ENAM11000858; Mon, 14 May 2007 19:10:22 -0400 (EDT) To: Alvaro Herrera cc: Chris Browne , pgsql-patches@postgresql.org Subject: Re: [DOCS] Autovacuum and XID wraparound In-reply-to: <20070514221619.GC8916@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> Comments: In-reply-to Alvaro Herrera message dated "Mon, 14 May 2007 18:16:19 -0400" Date: Mon, 14 May 2007 19:10:22 -0400 Message-ID: <857.1179184222@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/203 X-Sequence-Number: 2303 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. regards, tom lane