Re: Seeking reason behind performance gain in 12 with HashAggregate

Поиск
Список
Период
Сортировка
От Shira Bezalel
Тема Re: Seeking reason behind performance gain in 12 with HashAggregate
Дата
Msg-id CAE0KEwHrXdXu8g8_1KJ5efnyS438CpOarxOERfKO4EvKpYcaBw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Seeking reason behind performance gain in 12 with HashAggregate  (Michael Lewis <mlewis@entrata.com>)
Ответы Re: Seeking reason behind performance gain in 12 with HashAggregate  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список pgsql-performance
Дерево обсуждения
Hi Michael,

I appreciate your question. I ran a vacuum analyze on the 9.6 table and it yielded no difference. Same number of buffers were read, same query plan.

Thanks,
Shira

On Mon, Jan 13, 2020 at 10:07 AM Michael Lewis <mlewis@entrata.com> wrote:
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.


--
Shira Bezalel 
Database Administrator & Desktop Support Manager
San Francisco Estuary Institute
Ph: 510-746-7304

 

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

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