Re: Seeking reason behind performance gain in 12 with HashAggregate

From: Shira Bezalel <shira(at)sfei(dot)org>
To: Michael Lewis <mlewis(at)entrata(dot)com>
Cc: Justin Pryzby <pryzby(at)telsasoft(dot)com>, postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Seeking reason behind performance gain in 12 with HashAggregate
Date: 2020-01-13 20:44:14
Message-ID: CAE0KEwHrXdXu8g8_1KJ5efnyS438CpOarxOERfKO4EvKpYcaBw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)entrata(dot)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
www.sfei.org
Ph: 510-746-7304

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tomas Vondra 2020-01-13 21:11:56 Re: Seeking reason behind performance gain in 12 with HashAggregate
Previous Message Michael Lewis 2020-01-13 18:07:16 Re: Seeking reason behind performance gain in 12 with HashAggregate