Re: hashagg slowdown due to spill changes

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: hashagg slowdown due to spill changes
Дата
Msg-id 9d786d5d77c404834c033c0710f4f6d0c7702bb1.camel@j-davis.com
обсуждение исходный текст
Ответ на Re: hashagg slowdown due to spill changes  (Peter Geoghegan <pg@bowt.ie>)
Ответы Re: hashagg slowdown due to spill changes  (Peter Geoghegan <pg@bowt.ie>)
Список pgsql-hackers
On Sat, 2020-07-25 at 15:08 -0700, Peter Geoghegan wrote:
> I find that Andres original "SELECT cat, count(*) FROM
> fewgroups_many_rows GROUP BY 1;" test case is noticeably improved by
> the patch. Without the patch, v13 takes ~11.46 seconds. With the
> patch, it takes only ~10.64 seconds.

I saw less of an improvement than you or Andres (perhaps just more
noise). But given that both you and Andres are reporting a measurable
improvement, then I went ahead and committed it. Thank you.

Regards,
    Jeff Davis





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

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: HashAgg's batching counter starts at 0, but Hash's starts at 1.
Следующее
От: Dilip Kumar
Дата:
Сообщение: Re: Parallel bitmap index scan