Re: [HACKERS] Possible regression with gather merge.

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: [HACKERS] Possible regression with gather merge.
Дата
Msg-id CA+TgmoYjcW1MYP99OEu5MPZPqEY2BecZJ+dDhSumi6m+xDGk3g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Possible regression with gather merge.  (Rushabh Lathia <rushabh.lathia@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
On Wed, Mar 22, 2017 at 3:39 AM, Rushabh Lathia
<rushabh.lathia@gmail.com> wrote:
> Looking at the explain analyze output of both the plan, its clear that GM
> taking longer as its using external merge dist for the sort, where as
> another plan perform top-N heapsort. For normal sort path, it can consider
> the limit as bound, but for GM its not possible.

Right, good catch.  Committed.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

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

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: [HACKERS] PATCH: Make pg_stop_backup() archive wait optional
Следующее
От: Pavan Deolasee
Дата:
Сообщение: Re: [HACKERS] Patch: Write Amplification Reduction Method (WARM)