From: | Ole Gjerde <gjerde(at)icebox(dot)org> |
---|---|
To: | pgsql-general(at)postgreSQL(dot)org |
Subject: | More on Weird index problem |
Date: | 1999-07-14 22:15:06 |
Message-ID: | Pine.LNX.4.05.9907141712280.940-100000@snowman.icebox.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Carlos Fonseca | 1999-07-14 22:32:02 | (Debian Bug#41223) problem with cascaded updates with refint |
Previous Message | Peter Eisentraut | 1999-07-14 21:25:05 | Re: [GENERAL] Select from multiple db's |