AW: [HACKERS] index fix report

From: Andreas Zeugswetter <andreas(dot)zeugswetter(at)telecom(dot)at>
To: "'hackers(at)postgresql(dot)org'" <hackers(at)postgresql(dot)org>
Subject: AW: [HACKERS] index fix report
Date: 1998-09-09 07:13:52
Message-ID: 01BDDBD3.0A0FEC40@zeugswettera.user.lan.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-hackers by date

  From Date Subject
Next Message Andreas Zeugswetter 1998-09-09 07:27:53 Re: [HACKERS] Indixing problems...
Previous Message Michael Meskes 1998-09-09 06:52:50 inx problem fixe