From: | Johnson Ma <maxiaoyu(at)qcominc(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Need help on index!!! |
Date: | 2002-06-22 00:28:30 |
Message-ID: | 3D13C4AE.B93E1EAB@qcominc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi guru
I have a table with 300,000 records. I also created a index on it. But
the postgresql use sequence scan every time, when i search one record.
It is so slow. why?
here is create table script
create table pmmeasure (dataid bigint not null,
measurenum bigint DEFAULT nextval('measurenum')
UNIQUE NOT NULL,
name varchar(100) not null,
value varchar(100) not null,
constraint pk_pmmeasure primary key (measurenum),
constraint fk_pmmeasure_1 foreign key (dataid)
references pmdata (dataid)
);
create index index_pm on pmmeasure (dataid);
When I do like
explain analyze select * from pmmeasure where dataid = 10000;
it shows that postgresql always sequence scan for that record.
Thanks a lot.
Johnson
From | Date | Subject | |
---|---|---|---|
Next Message | David Ford | 2002-06-22 01:02:13 | Optimizing suggestions |
Previous Message | David Ford | 2002-06-21 22:29:19 | Re: Download version on website |