Re: [HACKERS] Gather Merge

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: [HACKERS] Gather Merge
Дата
Msg-id CAM3SWZQ4hUYU7fE56RR4ScXbiC1S-qTatNEp0i0qaymK9Od_GQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Gather Merge  (Rushabh Lathia <rushabh.lathia@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
On Tue, Jan 17, 2017 at 4:26 AM, Rushabh Lathia
<rushabh.lathia@gmail.com> wrote:
> Another observation is, HashAggregate (case 1) is performs better compare to
> GroupAggregate (case 2), but still it doesn't justify the cost difference of
> those two.

It may not be the only issue, or even the main issue, but I'm fairly
suspicious of the fact that cost_sort() doesn't distinguish between
the comparison cost of text and int4, for example.

-- 
Peter Geoghegan

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: [HACKERS] [COMMITTERS] pgsql: Generate fmgr prototypes automatically
Следующее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] Too many autovacuum workers spawned during forced auto-vacuum