AW: [HACKERS] index fix report

Поиск
Список
Период
Сортировка
От Andreas Zeugswetter
Тема AW: [HACKERS] index fix report
Дата
Msg-id 01BDDBD3.0A0FEC40@zeugswettera.user.lan.at
обсуждение исходный текст
Список pgsql-hackers
>
>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



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: Re: [HACKERS] Indixing problems...
Следующее
От: Andreas Zeugswetter
Дата:
Сообщение: Re: [HACKERS] Indixing problems...