Re: Faster distinct query?

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Faster distinct query?
Дата
Msg-id CAApHDvrecZLXdWNE00cb1bDAWO7jFDjJDoAToDAOZfMUyEuH5A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Faster distinct query?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
On Thu, 23 Sept 2021 at 13:28, David G. Johnston
<david.g.johnston@gmail.com> wrote:
> Agreed, though if the query author needs to do that here we’ve violated the spirit of the declarative SQL language.
Atfirst blush nothing about the original query seems like it should be preventing parallelism.  Each worker builds its
owndistinct array then the final concatenation is made distinct. 

We don't parallelise DISTINCT / ORDER BY aggregates.

David



В списке pgsql-general по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Faster distinct query?
Следующее
От: David Rowley
Дата:
Сообщение: Re: Faster distinct query?