Re: Optimising "in" queries

Поиск
Список
Период
Сортировка
От Michael Glaesemann
Тема Re: Optimising "in" queries
Дата
Msg-id AAF53AEE-B98C-45BD-B80F-8FA528BFB98B@seespotcode.net
обсуждение исходный текст
Ответ на Re: Optimising "in" queries  (Russell Smith <mr-russ@pws.com.au>)
Ответы Re: Optimising "in" queries  (Russell Smith <mr-russ@pws.com.au>)
Re: Optimising "in" queries  (Stephen Davies <scldad@sdc.com.au>)
Список pgsql-performance
On Aug 22, 2007, at 5:58 , Russell Smith wrote:

> Stephen Davies wrote:
>> select count(rdate),rdate from reading where sensor_id in
>> (1137,1138,1139,1140) group by rdate order by rdate desc limit 1;
>>
>>
> It would have been helpful to see the table definition here.  I can
> say up front that array processing in postgres is SLOW.

Um, what array processing are you seeing here? IN (a, b, b) is not an
array construct.

Michael Glaesemann
grzm seespotcode net



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

Предыдущее
От: Russell Smith
Дата:
Сообщение: Re: Optimising "in" queries
Следующее
От: "Dmitry Potapov"
Дата:
Сообщение: io storm on checkpoints, postgresql 8.2.4, linux