| From: | "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu> |
|---|---|
| To: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>, daveh(at)insightdist(dot)com, hackers(at)postgreSQL(dot)org |
| Subject: | Re: [HACKERS] index fix report |
| Date: | 1998-09-04 15:52:54 |
| Message-ID: | 35F00CD6.A3376CF1@alumni.caltech.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 1998-09-04 15:53:07 | Re: [HACKERS] Minor bugs and a formatting gripe |
| Previous Message | David Hartwig | 1998-09-04 15:49:26 | Re: [HACKERS] Release 6.4 |