Re: query not scaling

Rob Sargent <robjsargent@xxxxxxxxx> · Thu, 26 Oct 2017 09:17:49 -0600



    On 10/26/2017 09:01 AM, Tom Lane wrote:

    
      Laurenz Albe <laurenz.albe@xxxxxxxxxxx> 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.