Re: explain HashAggregate to report bucket and memory stats

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: explain HashAggregate to report bucket and memory stats
Дата
Msg-id eed4d5447629fcaa0360f4b5b66921df39b19b96.camel@j-davis.com
обсуждение исходный текст
Ответ на Re: explain HashAggregate to report bucket and memory stats  (Andres Freund <andres@anarazel.de>)
Ответы Re: explain HashAggregate to report bucket and memory stats  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
On Fri, 2020-03-13 at 10:27 -0700, Andres Freund wrote:
> On 2020-03-13 10:15:46 -0700, Jeff Davis wrote:
> > Also, is there a reason you report two different memory values
> > (hashtable and tuples)? I don't object, but it seems like a little
> > too
> > much detail.
> 
> Seems useful to me - the hashtable is pre-allocated based on
> estimates,
> whereas the tuples are allocated "on demand". So seeing the
> difference
> will allow to investigate the more crucial issue...

Then do we also want to report separately on the by-ref transition
values? That could be useful if you are using ARRAY_AGG and the states
grow larger than you might expect.

Regards,
    Jeff Davis





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

Предыдущее
От: James Coleman
Дата:
Сообщение: Re: [PATCH] Incremental sort (was: PoC: Partial sort)
Следующее
От: Andres Freund
Дата:
Сообщение: Re: explain HashAggregate to report bucket and memory stats