Re: plan difference between set-returning function with ROWS within IN() and a plain join

Поиск
Список
Период
Сортировка
От Frank van Vugt
Тема Re: plan difference between set-returning function with ROWS within IN() and a plain join
Дата
Msg-id 200805061355.52654.ftm.van.vugt@foxi.nl
обсуждение исходный текст
Ответ на Re: plan difference between set-returning function with ROWS within IN() and a plain join  (PFC <lists@peufeu.com>)
Список pgsql-performance
Дерево обсуждения 
> > I'm noticing a difference in planning between a join and an in() clause,
> > before trying to create an independent test-case, I'd like to know if
> > there's
> > an obvious reason why this would be happening:
>
> Is the function STABLE ?

Yep.

For the record, even changing it to immutable doesn't make a difference in
performance here.



--
Best,




Frank.

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

Предыдущее
От: Vlad Arkhipov
Дата:
Сообщение: Seqscan problem
Следующее
От: Jeff
Дата:
Сообщение: Re: RAID 10 Benchmark with different I/O schedulers (was: Performance increase with elevator=deadline)