We are at Postgres 7.4.5. I have encountered inaccuracies
after reindexing related to the statistics posted back to the PG_CLASS
1. We have a 'queues' table with 6 indexes. We are at 110,000 rows in
When I reindex, the RELPAGE count decreases as expected but the
Count increases to about 132,000 in all indexes. I check and there
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
The indexes. I reindexed and, again the RELPAGES count went down but
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
I know we are at a back-leveled version so perhaps the long-term answer is
Senior DBA - AutoRevenue
Direct dial phone number: 413-327-3045
Please visit our new website at www.autorevenue.com
"We do all the work.... you make all the money"
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2007-06-22 17:24:47|
|Subject: Re: REINDEX question |
|Previous:||From: Eduardo Ferreira||Date: 2007-06-22 14:13:38|
|Subject: Can't change lc_numeric value|