Re: performance issue: logical operators are slow inside SQL function: missing optimalization? - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: performance issue: logical operators are slow inside SQL function: missing optimalization?
Date
Msg-id AANLkTi=n_aiOAVU+z+OUngzwdcb2mCMX25Sg+Zdt0nYQ@mail.gmail.com
Whole thread Raw
In response to Re: performance issue: logical operators are slow inside SQL function: missing optimalization?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: performance issue: logical operators are slow inside SQL function: missing optimalization?
Next
From: "Kevin Grittner"
Date:
Subject: Page level support for GiST indexes in SSI