Re: function calls optimization - Mailing list pgsql-hackers

From Tom Lane
Subject Re: function calls optimization
Date
Msg-id 29143.1572536726@sss.pgh.pa.us
Whole thread Raw
In response to Re: function calls optimization  (Andres Freund <andres@anarazel.de>)
Responses Re: function calls optimization  (Andres Freund <andres@anarazel.de>)
Re: function calls optimization  (Andrzej Barszcz <abusinf@gmail.com>)
Re: function calls optimization  (Jim Finnerty <jfinnert@amazon.com>)
List pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> Potentially related note: for nodes like seqscan, combining the qual and projection processing into one expression
seemsto be a noticable win (at least when taking care do emit two different sets of deform expression steps). 

There's just one problem: that violates SQL semantics, and not in
a small way.

    select 1/x from tab where x <> 0

            regards, tom lane



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: ssl passphrase callback
Next
From: Andres Freund
Date:
Subject: Re: function calls optimization