AW: [HACKERS] index fix report - Mailing list pgsql-hackers

From Andreas Zeugswetter
Subject AW: [HACKERS] index fix report
Date
Msg-id 01BDDBD3.0A0FEC40@zeugswettera.user.lan.at
Whole thread Raw
List 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 by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: [HACKERS] Indixing problems...
Next
From: Andreas Zeugswetter
Date:
Subject: Re: [HACKERS] Indixing problems...