Re: [ADMIN] REINDEX question

2007-06-22 Thread Tom Lane
"Mark Steben" <[EMAIL PROTECTED]> 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,

[ADMIN] REINDEX question

2007-06-22 Thread Mark Steben
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