REINDEX question

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