Re: select distinct runs slow on pg 10.6 - Mailing list pgsql-performance

From Michael Lewis
Subject Re: select distinct runs slow on pg 10.6
Date
Msg-id CAHOFxGqQjRceFiOuEXJmpRi+XAdrZRf4xYZ7gTtyVACoFe1a6w@mail.gmail.com
Whole thread Raw
In response to Re: select distinct runs slow on pg 10.6  (Flo Rance <trourance@gmail.com>)
Responses Re: select distinct runs slow on pg 10.6
List pgsql-performance
If you can't modify the query, then there is nothing more to be done to optimize the execution afaik. Distinct is much slower than group by in scenarios like this with many columns. You already identified the disk sort and increased work mem to get it faster by 3x. There are not any other tricks of which I am aware.

pgsql-performance by date:

Previous
From: Flo Rance
Date:
Subject: Re: select distinct runs slow on pg 10.6
Next
From: yash mehta
Date:
Subject: Re: select distinct runs slow on pg 10.6