Re: Re: custom hash-based COUNT(DISTINCT) aggregate - unexpectedly high memory consumption

Поиск
Список
Период
Сортировка
От Tomas Vondra
Тема Re: Re: custom hash-based COUNT(DISTINCT) aggregate - unexpectedly high memory consumption
Дата
Msg-id 5134df4261525cabdf51b505be5bbaf2.squirrel@sq.gransy.com
обсуждение исходный текст
Ответ на Re: Re: custom hash-based COUNT(DISTINCT) aggregate - unexpectedly high memory consumption  (Atri Sharma <atri.jiit@gmail.com>)
Ответы Re: Re: custom hash-based COUNT(DISTINCT) aggregate - unexpectedly high memory consumption  (Atri Sharma <atri.jiit@gmail.com>)
Список pgsql-hackers
On 8 Říjen 2013, 11:42, Atri Sharma wrote:
>>
>> I've made some significant improvements in the chaining version (in the
>> master branch), now getting about the memory consumption I've estimated.
>>
> I agree, we can hope to reduce the memory consumption by making changes in
> the current chaining implementation. I would like to look into changing
> the data structure used for chaining from singly linked list to maybe skip
> list or something else.

Just to be sure - I haven't been messing with the HashAggregate
implementation directly, but with a custom aggregate. But feel free to
tweak the built-in hash table ;-)

Tomas




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

Предыдущее
От: Pavan Deolasee
Дата:
Сообщение: Re: Patch for fail-back without fresh backup
Следующее
От: shailesh singh
Дата:
Сообщение: Urgent Help Required