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 11:45:25
Message-ID: 20041110114525.GB23500@uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Nov 10, 2004 at 12:22:17PM +0100, Cao Duy wrote:
> there is an index on customer_id
>
> create table customer(
> ...
> CONSTRAINT customer_pkey PRIMARY KEY (customer_id),
> ...
> )

Oh, sorry, I missed it among all the foreign keys. :-) Anyhow, as others have
pointed out, try doing a select against 5::bigint instead of just 5 (which is
an integer).

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff 2004-11-10 13:04:03 Re: Need advice on postgresql.conf settings
Previous Message Cao Duy 2004-11-10 11:22:17 Re: simple select-statement takes more than 25 sec