By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,391 Members | 1,387 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,391 IT Pros & Developers. It's quick & easy.

heap errors - should I be worried?

P: n/a
Hello,

yesterday I took our database down and started in single user mode.
After reindexing of three tables I thought a vacuum would be a good idea.

backend> VACUUM FULL VERBOSE ANALYZE
WARNING: Index pg_statistic_relid_att_index: NUMBER OF INDEX' TUPLES
(163) IS NOT THE SAME AS HEAP' (345).
Recreate the index.
WARNING: Index pg_statistic_relid_att_index: NUMBER OF INDEX' TUPLES
(5) IS NOT THE SAME AS HEAP' (345).
Recreate the index.
WARNING: Index pg_toast_16408_index: NUMBER OF INDEX' TUPLES (2) IS NOT
THE SAME AS HEAP' (7).
Recreate the index.

Should these errors worry me? What do they mean? IS there anything I
need to do / should have done?

TIA

/Ulrich
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 23 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Ulrich Wisser <ul***********@relevanttraffic.se> writes:
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?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #2

P: n/a
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 ma*******@postgresql.org)

Nov 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.