Re: Seeking reason behind performance gain in 12 with HashAggregate

Поиск
Список
Период
Сортировка
От Justin Pryzby
Тема Re: Seeking reason behind performance gain in 12 with HashAggregate
Дата
Msg-id 20200113164220.GH26045@telsasoft.com
обсуждение исходный текст
Ответ на Seeking reason behind performance gain in 12 with HashAggregate  (Shira Bezalel <shira@sfei.org>)
Ответы Re: Seeking reason behind performance gain in 12 with HashAggregate  (Shira Bezalel <shira@sfei.org>)
Список pgsql-performance
Дерево обсуждения 
On Mon, Jan 13, 2020 at 08:29:05AM -0800, Shira Bezalel wrote:
> Here is the EXPLAIN (ANALYZE ON, BUFFERS ON) output from both systems:
> 
> 9.6 plan <https://explain.depesz.com/s/W8HN>
> 12.1 plan <https://explain.depesz.com/s/lIRS>

> Is there something that was changed/improved in either 10, 11 or 12 that this
> behavior can be attributed to?

v12 has JIT enabled by default.
You can test if that's significant with SET jit=off.

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

Предыдущее
От: Shira Bezalel
Дата:
Сообщение: Seeking reason behind performance gain in 12 with HashAggregate
Следующее
От: Shira Bezalel
Дата:
Сообщение: Re: Seeking reason behind performance gain in 12 with HashAggregate