Re: Seeking reason behind performance gain in 12 with HashAggregate

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: Seeking reason behind performance gain in 12 with HashAggregate
Дата
Msg-id CAHOFxGo8tXqvsC6=X_SCu-p2_xTb1+xYWWfv3JdcVKnftKjxEQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: 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
Дерево обсуждения
I am not at all familiar with PostGIS so perhaps this is a silly question, is bloat an issue on the older instance? Correlation isn't causation, but half the buffers scanned and half the runtime in the v12 plan has me curious why that might be.

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

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