Re: query not scaling

On 10/26/2017 09:01 AM, Tom Lane wrote:
> Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)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.