| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Mark Steben" <msteben(at)autorevenue(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: REINDEX question |
| Date: | 2007-06-22 17:24:47 |
| Message-ID: | 24033.1182533087@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
"Mark Steben" <msteben(at)autorevenue(dot)com> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Erik Jones | 2007-06-22 17:24:50 | Re: [GENERAL] Can I backup/restore a database in a sql script? |
| Previous Message | Mark Steben | 2007-06-22 15:03:43 | REINDEX question |