heap errors - should I be worried?
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
Ulrich Wisser <ulrich.wisser@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
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