Re: simple select-statement takes more than 25 sec - Mailing list pgsql-performance

Am Mi, den 10.11.2004 schrieb Steinar H. Gunderson um 11:17:
> On Wed, Nov 10, 2004 at 10:35:50AM +0100, Cao Duy wrote:
> > here is my simple select-statement:
> > SELECT * FROM CUSTOMER WHERE CUSTOMER_ID=5
>
> It seems like you're missing an index on customer_id. Set it to PRIMARY KEY
> or do an explicit CREATE INDEX (followed by an ANALYZE) and it should be a
> lot faster.
there is an index on customer_id

create table customer(
...
CONSTRAINT customer_pkey PRIMARY KEY (customer_id),
...
)

> /* Steinar */