Re: simple select-statement takes more than 25 sec

Поиск
Список
Период
Сортировка
От Steinar H. Gunderson
Тема Re: simple select-statement takes more than 25 sec
Дата
Msg-id 20041110114525.GB23500@uio.no
обсуждение исходный текст
Ответ на Re: simple select-statement takes more than 25 sec  (Cao Duy <cao.duy@1und1.com>)
Список 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/

В списке pgsql-performance по дате отправления:

Предыдущее
От: Cao Duy
Дата:
Сообщение: Re: simple select-statement takes more than 25 sec
Следующее
От: Jeff
Дата:
Сообщение: Re: Need advice on postgresql.conf settings