Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id DAA8E2E181E for ; Tue, 13 Nov 2007 11:21:25 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 76987-06 for ; Tue, 13 Nov 2007 11:21:12 -0400 (AST) Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id 9CE282E0D88 for ; Tue, 13 Nov 2007 11:21:17 -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 1IrxZk-0003wg-Ed; Tue, 13 Nov 2007 10:21:16 -0500 Received: by crankycanuck.ca (Postfix, from userid 1000) id 3059D504FB; Tue, 13 Nov 2007 10:21:11 -0500 (EST) Date: Tue, 13 Nov 2007 10:21:11 -0500 From: Andrew Sullivan To: Jean-David Beyer , pgsql-performance@postgresql.org Subject: Re: Curious about dead rows. Message-ID: <20071113152111.GG11563@crankycanuck.ca> Mail-Followup-To: Andrew Sullivan , Jean-David Beyer , pgsql-performance@postgresql.org References: <47366782.7050600@verizon.net> <20071112163223.GP32349@crankycanuck.ca> <4738825F.6050106@verizon.net> <20071112171805.GQ32349@crankycanuck.ca> <47389504.4020700@verizon.net> <20071112185218.GS32349@crankycanuck.ca> <4738A2EC.9090500@verizon.net> <20071112190833.GY32349@crankycanuck.ca> <4739BD65.9070605@verizon.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4739BD65.9070605@verizon.net> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/195 X-Sequence-Number: 27610 Please don't drop the list, as someone else may see something. On Tue, Nov 13, 2007 at 10:06:13AM -0500, Jean-David Beyer wrote: > OK. I turned logging from "none" to "mod" and got a gawdawful lot of stuff. Yes. > Then I ran it and got all the inserts. Using > grep -i delete file > grep -i update file > grep -i rollback file How about ERROR? > 2007-11-13 08:11:20 EST DEBUG: "vl_ranks": scanned 540 of 540 pages, > containing 67945 live rows and 554 dead rows; 3000 rows in sample, 67945 > estimated total rows If there are dead rows, something is producing them. Either INSERT is firing a trigger that is doing something there (you won't see an UPDATE in that case), or else something else is causing INSERTs to fail. A -- Andrew Sullivan Old sigs will return after re-constitution of blue smoke