Hi Tom,
WARNING: Index pg_statistic_relid_att_index: NUMBER OF INDEX' TUPLES (163) IS NOT THE SAME AS HEAP' (345).
Recreate the index.
Should these errors worry me?
Yeah, they should. A REINDEX will probably get you out of the immediate problem, but the more interesting question is how you got to be missing index entries in the first place. Have you had any crashes or hardware problems lately? What PG version is this?
PG version 7.3.4
No hardware problems or crashes I know of. I do a "vacuum full analyze" once every night and never did see these problems. Only yesterday after I used reindex on three tables did I see these problems.
I will try to reindex the database tonight.
Thanks
Ulrich
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
