Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 065239FC501 for ; Fri, 22 Jun 2007 14:24:54 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 95870-09 for ; Fri, 22 Jun 2007 14:24:50 -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 BE3B39FC3C6 for ; Fri, 22 Jun 2007 14:24:50 -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 l5MHOljl024034; Fri, 22 Jun 2007 13:24:48 -0400 (EDT) To: "Mark Steben" cc: pgsql-admin@postgresql.org Subject: Re: REINDEX question In-reply-to: <015901c7b4de$86bb9c10$b501a8c0@D1RPQZB1> References: <015901c7b4de$86bb9c10$b501a8c0@D1RPQZB1> Comments: In-reply-to "Mark Steben" message dated "Fri, 22 Jun 2007 11:03:43 -0400" Date: Fri, 22 Jun 2007 13:24:47 -0400 Message-ID: <24033.1182533087@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/248 X-Sequence-Number: 25916 "Mark Steben" writes: > We are at Postgres 7.4.5. I have encountered inaccuracies > after reindexing related to the statistics posted back to the PG_CLASS > table reindex enters the exact number of tuples indexed into pg_class.reltuples. If there are more than you expect, that says there are some dead-but-not-removable tuples in the relation. Check for old open transactions that might still be able to see old versions of rows. VACUUM VERBOSE should report the same number of unremovable rows BTW. regards, tom lane