Обсуждение: AW: [HACKERS] index fix report

Поиск
Список
Период
Сортировка

AW: [HACKERS] index fix report

От
Andreas Zeugswetter
Дата:
>
>Theory: Could it be that the index is ok, but that pg_class is corrupted.   This
>is based on the earlier observation that shows the most recent inserts and
>updated no being appended to the end of the table.

No, I don't think so, when a table gets "lost" there are more entries in the 2 indices
than in the pg_class table itself. If I do a vacuum analyze it sais 167 entries in pg_class
200 entries in pg_class_relname_index and pg_class_oid_index.

Andreas