On 10/26/2017 09:01 AM, Tom Lane wrote:
Laurenz Albe <laurenz.albe@cybertec.at> writes:
Also, to have PostgreSQL inline the function, which would be good
for performance, it should be declared IMMUTABLE.
Actually, if you hope to have a SQL function be inlined, it's better
not to decorate it at all --- not with IMMUTABLE, and not with STRICT
either. Both of those restrict the parser's ability to inline unless
it can prove the contained expression is equally immutable/strict.
With the default attributes of volatile/not strict, there's nothing
to prove.
(In any case, it's usually easy enough to tell from EXPLAIN output
whether inlining has happened.)
regards, tom lane
As to the explain analyze,
could not receive data from server: Connection timed out
Time: 7877340.565 ms
for the second time. I had presumed at first that this had occurred during a network burp. I'll try running it directly on the pg host.