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

From Thomas G. Lockhart
Subject Re: [HACKERS] index fix report
Date
Msg-id 35F00CD6.A3376CF1@alumni.caltech.edu
Whole thread Raw
In response to Re: [HACKERS] index fix report  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
> regression=> explain select oid, relname from pg_class
> regression->  where oid = 19947;
> NOTICE:  QUERY PLAN:
>
> Index Scan using pg_class_oid_index on pg_class
>   (cost=2.03 size=2 width=36)
>
> EXPLAIN
>
> So these indices appear damaged.

Sorry, left out one of the test cases which lead to the conclusion that
multiple indices are damaged on my machine:

regression=> select oid, relname from pg_class
regression->  where oid = 19947;
oid|relname
---+-------
(0 rows)

                  - Tom

pgsql-hackers by date:

Previous
From: "Thomas G. Lockhart"
Date:
Subject: Re: [HACKERS] index fix report
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Minor bugs and a formatting gripe