Re: performance issue: logical operators are slow inside SQL function: missing optimalization?

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: performance issue: logical operators are slow inside SQL function: missing optimalization?
Дата
Msg-id AANLkTi=n_aiOAVU+z+OUngzwdcb2mCMX25Sg+Zdt0nYQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: performance issue: logical operators are slow inside SQL function: missing optimalization?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
2010/8/29 Tom Lane <tgl@sss.pgh.pa.us>:
> Martijn van Oosterhout <kleptog@svana.org> writes:
>> On Sun, Aug 29, 2010 at 11:23:29AM -0400, Tom Lane wrote:
>>> It has nothing to do with boolean operators, just double evaluation.
>
>> I was wondering, wouldn't it be possible to avoid the double evaluation
>> by simply creating an extra slot for the intermediate value.
>
> Possibly, but the trick would be to figure out when to evaluate the
> values so that it would still behave the same as without inlining.
> I don't think the existing Param mechanism could do this without
> some additional help.
>

maybe subject for ToDo?

Regards

Pavel Stehule

>                        regards, tom lane
>


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: performance issue: logical operators are slow inside SQL function: missing optimalization?
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Page level support for GiST indexes in SSI