Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id F17D89FBFD7 for ; Thu, 17 May 2007 12:53:33 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 87238-01 for ; Thu, 17 May 2007 12:53:30 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id 51E1F9FBD5D for ; Thu, 17 May 2007 12:53:29 -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 l4HFrMDX023600; Thu, 17 May 2007 08:53:23 -0700 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id B542432A14; Thu, 17 May 2007 11:53:19 -0400 (CLT) Date: Thu, 17 May 2007 11:53:19 -0400 From: Alvaro Herrera To: Tom Lane Cc: Heikki Linnakangas , Chris Browne , pgsql-patches@postgresql.org Subject: Re: [DOCS] Autovacuum and XID wraparound Message-ID: <20070517155319.GF28701@alvh.no-ip.org> References: <464B0E5A.1070807@enterprisedb.com> <6549.1179344646@sss.pgh.pa.us> <464B60A7.3070106@enterprisedb.com> <7145.1179347418@sss.pgh.pa.us> <464B6B08.6030609@enterprisedb.com> <7460.1179349272@sss.pgh.pa.us> <20070516210531.GL4582@alvh.no-ip.org> <7667.1179350456@sss.pgh.pa.us> <20070516224627.GP4582@alvh.no-ip.org> <9823.1179360041@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <9823.1179360041@sss.pgh.pa.us> 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]); Thu, 17 May 2007 08:53:23 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/274 X-Sequence-Number: 2374 Tom Lane wrote: > Alvaro Herrera writes: > > Here is my proposed patch. > > Actually, the original patch in this series was fairly horrid, and > things haven't been made better by the subsequent changes. It lacked > any comment explaining what it was doing; failed to comment on the way > it was abusing heap_freeze_tuple (the latter thinks it's getting a tuple > that's in a disk buffer); and IMHO puts the heap_freeze_tuple call in > the wrong place anyway. raw_heap_insert has no business editorializing > on the tuple it's given. It'd be better to have the call in > rewrite_heap_tuple, which is already busy messing with the tuple's > visibility info. Perhaps like this, in addition to your changes: Applied, thanks. Let me know if there is still something you don't like about the current state of cluster or truncate. The part about actually advancing relfrozenxid is still not done though ... -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support