> 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