pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mark Steben <msteben@autorevenue.com>
To: pgsql-admin@postgresql.org
Subject: REINDEX question
Date: Fri, 22 Jun 2007 11:03:43 -0400
Message-ID: <015901c7b4de$86bb9c10$b501a8c0@D1RPQZB1> (raw)

Good morning,

 

We are at Postgres 7.4.5.  I  have encountered inaccuracies 

 after reindexing related to the statistics posted back to the PG_CLASS
table

For instance:

 1.  We have a 'queues' table with 6 indexes.  We are at 110,000 rows in
this table.

      When I reindex, the RELPAGE count decreases as expected but the
RELTUPLE

      Count increases to about 132,000 in all indexes.  I check and there
are still

      Only 110,000 rows on the table.

 2.  We have a table that is quite volatile in its numbers, ranging from 100
to 6 million rows.

     Last week we were at 50,000 rows but PG_CLASS.RELTUPLES showed 6
million for

     The indexes.  I reindexed and, again the RELPAGES count went down but
the RELTUPLES

     Number went down to just 3 million. 

     Again a count after reindex gave the actual row count at 52,000.

 

Does anybody have any insight why this is happening and what I can do in the
short term?

I know we are at a back-leveled version so perhaps the long-term answer is
to upgrade.

 

Thank you,

Mark Steben 

Senior DBA - AutoRevenue

 

Direct dial phone number: 413-327-3045

Please visit our new website at www.autorevenue.com
<http://www.autorevenue.com/; 

"We do all the work....  you make all the money"

 

view thread (2+ messages)  latest in thread

Message-ID: <015901c7b4de$86bb9c10$b501a8c0@D1RPQZB1>
Permalink:  ../015901c7b4de$86bb9c10$b501a8c0@D1RPQZB1/
Also on:    postgresql.org/message-id/015901c7b4de$86bb9c10$b501a8c0@D1RPQZB1

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: msteben@autorevenue.com
  Subject: Re: REINDEX question
  In-Reply-To: <015901c7b4de$86bb9c10$b501a8c0@D1RPQZB1>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox