Re: 9.5: Better memory accounting, towards memory-bounded HashAgg

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: 9.5: Better memory accounting, towards memory-bounded HashAgg
Дата
Msg-id CAB7nPqQAj3paSjZO00L4wwWx+rB37nBGhXuQQUoP46-tDck0RA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: 9.5: Better memory accounting, towards memory-bounded HashAgg  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список pgsql-hackers
On Thu, Jan 8, 2015 at 4:07 AM, Tomas Vondra
<tomas.vondra@2ndquadrant.com> wrote:
> which is IMHO obviously wrong, because that accounts only for the
> hashtable itself.
> In those cases the patch actually does no memory accounting and as
> hashcontext has no child contexts, there's no accounting overhead.
> [blah]

> So the performance drops 2x. With more groups, the performance impact is
> even worse.
Hmm. It seems that this patch is not there yet, so marking it as
returned with feedback, especially knowing that the patch is incorrect
by using hascontext as mentioned by Tomas.
-- 
Michael



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

Предыдущее
От: Manuel Kniep
Дата:
Сообщение: Re: segmentation fault in execTuples.c#ExecStoreVirtualTuple
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Turning recovery.conf into GUCs