Re: Optimising "in" queries

Поиск
Список
Период
Сортировка
От Russell Smith
Тема Re: Optimising "in" queries
Дата
Msg-id 46CD3A64.9050302@pws.com.au
обсуждение исходный текст
Ответ на Re: Optimising "in" queries  (Russell Smith <mr-russ@pws.com.au>)
Список pgsql-performance
Russell Smith wrote:
>
> Filter: (sensor_id = ANY ('{1137,1138,1139,1140}'::integer[]))
>
> I've never seen this plan item except for when array's are involved.  I
> could be wrong.  I'd like to know how this is generated when you don't
> have an array.
>

I have just discovered that PG 8.2 will turn an IN clause into an array
search instead of an OR list.  Sorry all.

Regards

Russell Smith

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

Предыдущее
От: Russell Smith
Дата:
Сообщение: Re: Optimising "in" queries
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: asynchronous commit feature