Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 188EA2E2D44 for ; Wed, 14 Nov 2007 11:23:02 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 65003-01 for ; Wed, 14 Nov 2007 11:22:56 -0400 (AST) Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id CD1832E2D45 for ; Wed, 14 Nov 2007 11:22:56 -0400 (AST) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=crankycanuck.ca) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1IsK4t-0001Pv-0n for pgsql-performance@postgresql.org; Wed, 14 Nov 2007 10:22:55 -0500 Received: by crankycanuck.ca (Postfix, from userid 1000) id B1AD6504FD; Wed, 14 Nov 2007 10:22:49 -0500 (EST) Date: Wed, 14 Nov 2007 10:22:49 -0500 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: Curious about dead rows. Message-ID: <20071114152249.GA16041@crankycanuck.ca> Mail-Followup-To: Andrew Sullivan , pgsql-performance@postgresql.org References: <4735DBDB.5050208@verizon.net> <16627.1194714491@sss.pgh.pa.us> <4735FA9F.1080805@verizon.net> <473A5CC0.3060003@verizon.net> <473AE63D.7090305@verizon.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <473AE63D.7090305@verizon.net> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/213 X-Sequence-Number: 27628 On Wed, Nov 14, 2007 at 07:12:45AM -0500, Jean-David Beyer wrote: > > I know there have been rollbacks but I do a REINDEX, CLUSTER, and VACUUM > ANALYZE before starting the inserts in question. Do I need to do a VACUUM > FULL ANALYZE instead? I had another idea. As Alvaro says, CLUSTER will do everything you need. But are you sure there are _no other_ transactions open when you do that? This could cause problems, and CLUSTER's behaviour with other open transactions is not, um, friendly prior to the current beta. A -- Andrew Sullivan Old sigs will return after re-constitution of blue smoke