Re: Query Performance Issue

Alexey Bashtanov <bashtanov@xxxxxxx> · Fri, 28 Dec 2018 14:53:58 +0000



            https://explain.depesz.com/s/Pra8a

            
    Could you share the query itself please?

    And the tables definitions including indexes.

    
            work_mem : 8MB
          
        
    That's not a lot. The 16-batches hash join may have worked faster if
    you had resources to increase work_mem.