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

From Tom Lane
Subject Re: performance issue: logical operators are slow inside SQL function: missing optimalization?
Date
Msg-id 20512.1283105334@sss.pgh.pa.us
Whole thread Raw
In response to Re: performance issue: logical operators are slow inside SQL function: missing optimalization?  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: performance issue: logical operators are slow inside SQL function: missing optimalization?  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: performance issue: logical operators are slow inside SQL function: missing optimalization?
Next
From: Pavel Stehule
Date:
Subject: Re: performance issue: logical operators are slow inside SQL function: missing optimalization?