heap errors - should I be worried? - Mailing list pgsql-general

From Ulrich Wisser
Subject heap errors - should I be worried?
Date
Msg-id 411C6C52.7090804@relevanttraffic.se
Whole thread Raw
Responses Re: heap errors - should I be worried?
List pgsql-general
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


pgsql-general by date:

Previous
From: Ulrich Wisser
Date:
Subject: REINDEX problem
Next
From: val@webtribe.net
Date:
Subject: ODBC Driver Standards