Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 41ABD9F96E7 for ; Sun, 16 Sep 2007 12:15:02 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 24091-02 for ; Sun, 16 Sep 2007 12:14:58 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id EE6419F96E1 for ; Sun, 16 Sep 2007 12:14:57 -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 l8GFEuhw005355; Sun, 16 Sep 2007 11:14:56 -0400 (EDT) To: Gregory Stark cc: pgsql-hackers@postgresql.org Subject: Re: Hmmm ... isn't count_nondeletable_pages all wet? In-reply-to: <87fy1fkk6p.fsf@oxford.xeocode.com> References: <28916.1189900143@sss.pgh.pa.us> <29644.1189904237@sss.pgh.pa.us> <87fy1fkk6p.fsf@oxford.xeocode.com> Comments: In-reply-to Gregory Stark message dated "Sun, 16 Sep 2007 10:56:30 +0100" Date: Sun, 16 Sep 2007 11:14:55 -0400 Message-ID: <5354.1189955695@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/695 X-Sequence-Number: 107847 Gregory Stark writes: > "Tom Lane" writes: >> Those bug reports have been bothering me for most of a year ... > Are there any other outstanding reports like that? Couldn't say. Those two were on my mind because the reporters had allowed me to troll through their table and index files and verify that there were indeed multiple index pointers to the same table row, and yet the index itself did not show any indication of corruption. I had noticed the "clumping" pattern of the doubly-linked rows in both cases, but hadn't found an explanation. regards, tom lane