Re: Query Performance Issue

From: Alexey Bashtanov <bashtanov(at)imap(dot)cc>
To: neslişah demirci <neslisah(dot)demirci(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Query Performance Issue
Date: 2018-12-28 14:53:58
Message-ID: beb87224-0d09-0ccd-22ef-84741ee2f748@imap.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> *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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Justin Pryzby 2018-12-28 15:32:05 Re: Query Performance Issue
Previous Message Sebastiaan Mannem 2018-12-28 09:04:16 Re: psql cli tool and connection pooling