Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 3277437C6FD for ; Mon, 12 Nov 2007 12:32:32 -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 41595-06 for ; Mon, 12 Nov 2007 12:32:28 -0400 (AST) Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id C122937C6E0 for ; Mon, 12 Nov 2007 12:32:28 -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 1IrcD6-00069L-90 for pgsql-performance@postgresql.org; Mon, 12 Nov 2007 11:32:28 -0500 Received: by crankycanuck.ca (Postfix, from userid 1000) id 12A16504FD; Mon, 12 Nov 2007 11:32:23 -0500 (EST) Date: Mon, 12 Nov 2007 11:32:23 -0500 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: Curious about dead rows. Message-ID: <20071112163223.GP32349@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> <20071110105119.35346a29@scratch> <47360D16.7070107@verizon.net> <47366782.7050600@verizon.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <47366782.7050600@verizon.net> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/181 X-Sequence-Number: 27596 On Sat, Nov 10, 2007 at 09:22:58PM -0500, Jean-David Beyer wrote: > > > > So, there are NO failed inserts, and no updates? Cause that's what > > I'd expect to create the dead rows. > > > So would I. Hence the original question. Foreign keys with cascading deletes or updates? A -- Andrew Sullivan Old sigs will return after re-constitution of blue smoke