Re: Performance problems with multiple layers of functions

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Performance problems with multiple layers of functions
Дата
Msg-id 8427.1143228229@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Performance problems with multiple layers of functions  (Svenne Krap <svenne@krap.dk>)
Ответы Query plan from hell  (PFC <lists@peufeu.com>)
Список pgsql-performance
Svenne Krap <svenne@krap.dk> writes:
> Tom Lane wrote:
>> where (flow_direction, dataset_id) in (select * from new_func(122))

> Is this form of multi-column IN mentioned anywhere in the docs? I can't
> find it.

Sure, look under "Subquery Expressions".  8.0 and later refer to it as a
row_constructor, but it's documented at least as far back as 7.3.

            regards, tom lane

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

Предыдущее
От: Michael Stone
Дата:
Сообщение: Re: Scaling up PostgreSQL in Multiple CPU / Dual Core
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Scaling up PostgreSQL in Multiple CPU / Dual Core