Re: simple select-statement takes more than 25 sec

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: simple select-statement takes more than 25 sec
Date: 2004-11-10 10:17:47
Message-ID: 20041110101747.GB22780@uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

/* Steinar */
--
Homepage: http://www.sesse.net/

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message gnari 2004-11-10 10:31:40 Re: simple select-statement takes more than 25 sec
Previous Message Cao Duy 2004-11-10 09:35:50 simple select-statement takes more than 25 sec