Re: STRICT SQL functions never inline - Mailing list pgsql-performance

From Tom Lane
Subject Re: STRICT SQL functions never inline
Date
Msg-id 14182.1320798574@sss.pgh.pa.us
Whole thread Raw
In response to STRICT SQL functions never inline  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
Josh Berkus <josh@agliodbs.com> writes:
> After having some production issues, I did some testing and it seems
> that any SQL function declared STRICT will never inline.

It won't unless the planner can prove that the resulting expression
behaves the same, ie, is also strict for *all* the parameters.  Which
in most cases isn't true, or at least is very difficult to prove.
This is not a bug.

            regards, tom lane

pgsql-performance by date:

Previous
From: Andres Freund
Date:
Subject: Re: STRICT SQL functions never inline
Next
From: Venkat Balaji
Date:
Subject: : bg_writer overloaded ?