Need help on index!!!

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

Responses

Browse pgsql-general by date

  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