Horton
Menu

Re: [HACKERS] index fix report

Thomas Lockhart <lockhart@alumni.caltech.edu>

View thread
From: "Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
To: Bruce Momjian <maillist@candle.pha.pa.us>, daveh@insightdist.com, hackers@postgreSQL.org
Date: 1998-09-04T15:52:54Z
Lists: 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