Re: Seeking reason behind performance gain in 12 with HashAggregate

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: Shira Bezalel <shira(at)sfei(dot)org>
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 18:07:16
Message-ID: CAHOFxGo8tXqvsC6=X_SCu-p2_xTb1+xYWWfv3JdcVKnftKjxEQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Shira Bezalel 2020-01-13 20:44:14 Re: Seeking reason behind performance gain in 12 with HashAggregate
Previous Message Shira Bezalel 2020-01-13 17:34:04 Re: Seeking reason behind performance gain in 12 with HashAggregate