Re: how to improve perf of 131MM row table?

AJ Weber <aweber@xxxxxxxxxxx> · Thu, 26 Jun 2014 10:07:45 -0400



    I will try this, but can you clarify the syntax?  I only know the
    VALUES clause from insert statements, and it would be one set of
    parens like VALUES('175769', '175771', ... )

    
    You seem to indicate a VALUES clause that has strange parenthesis
    corresponding to it.

    
    Thank you for the feedback and offer to help!

    
    -AJ

    
    On 6/26/2014 9:56 AM, Matheus de
      Oliveira wrote:

    
          On Thu, Jun 26, 2014 at 10:26 AM, AJ
            Weber <aweber@xxxxxxxxxxx>
            wrote:

            
              OK, the
                sample query is attached (hopefully attachments are
                allowed) as "query.sql".

                The "master table" definition is attached as
                "table1.sql".

                The "detail table" definition is attached as
                "table2.sql".

                The EXPLAIN (ANALYZE, BUFFERS) output is here: http://explain.depesz.com/s/vd5
            
          
        Could you try chaning your query and
          sending the EXPLAIN of the following?

          
        Instead of `node_id in ('175769',
          '175771', ...)` try `node_in IN (VALUES('175769'), ('175771'),
          ... )`.

        
        -- 

          Matheus de Oliveira

          Analista de Banco de Dados

          Dextra Sistemas - MPS.Br nível F!

          www.dextra.com.br/postgres