More on Weird index problem - Mailing list pgsql-general

Hi,
I'm still having this same problem.
Below is a simple test to show the problem.
Same table as before, but I removed all indices except the itemid
field(serial).

Thanks,
Ole Gjerde

parts=> create index av_parts_nsn_index on av_parts(nsn);
CREATE
parts=> explain select * from av_parts where nsn = '123456';
NOTICE:  QUERY PLAN:

Seq Scan on av_parts  (cost=194841.86 rows=3206927 width=124)

EXPLAIN
parts=> vacuum verbose av_parts;
NOTICE:  --Relation av_parts--
NOTICE:  Pages 63834: Changed 0, Reapped 0, Empty 0, New 0; Tup 3969935:
Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 92, MaxLen 200; Re-using:
Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. Elapsed 29/11 sec.
NOTICE:  Index av_parts_nsn_index: Pages 8705; Tuples 3969935. Elapsed
3/75 sec.
NOTICE:  Index av_parts_itemid_key: Pages 7818; Tuples 3969935.
Elapsed 3/74 sec.
VACUUM
parts=> explain select * from av_parts where nsn = '123456';
NOTICE:  QUERY PLAN:

Seq Scan on av_parts  (cost=194841.86 rows=3206927 width=124)

EXPLAIN