Re: significant slowdown of HashAggregate between 9.6 and 10

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: significant slowdown of HashAggregate between 9.6 and 10
Дата
Msg-id 20200603202643.heyk452fqbgksqzy@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: significant slowdown of HashAggregate between 9.6 and 10  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Ответы Re: significant slowdown of HashAggregate between 9.6 and 10  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Hi,

On 2020-06-03 21:31:01 +0200, Tomas Vondra wrote:
> So there seems to be +40% between 9.6 and 10, and further +25% between
> 10 and master. However, plain hashagg, measured e.g. like this:

Ugh.

Since I am a likely culprit, I'm taking a look.


> Not sure what to think about this. Seems slot_deform_tuple got way more
> expensive between 9.6 and 10, for some reason.

Might indicate too many calls instead. Or it could just be the fact that
we have expressions deform all columns once, instead of deforming
columns one-by-one now.

Greetings,

Andres Freund



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: libpq copy error handling busted
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: what can go in root.crt ?