heap errors - should I be worried?

Поиск
Список
Период
Сортировка
От Ulrich Wisser
Тема heap errors - should I be worried?
Дата
Msg-id 411C6C52.7090804@relevanttraffic.se
обсуждение исходный текст
Ответы Re: heap errors - should I be worried?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Ulrich Wisser
Дата:
Сообщение: REINDEX problem
Следующее
От: val@webtribe.net
Дата:
Сообщение: ODBC Driver Standards