Postgres Pro
Downloads
Home   >   mailing lists

Re: Seeking reason behind performance gain in 12 with HashAggregate - Mailing list pgsql-performance

From Michael Lewis
Subject Re: Seeking reason behind performance gain in 12 with HashAggregate
Date
Msg-id CAHOFxGo8tXqvsC6=X_SCu-p2_xTb1+xYWWfv3JdcVKnftKjxEQ@mail.gmail.com
Whole thread Raw
In response to Re: Seeking reason behind performance gain in 12 with HashAggregate  (Shira Bezalel <shira@sfei.org>)
Responses Re: Seeking reason behind performance gain in 12 with HashAggregate  (Shira Bezalel <shira@sfei.org>)
List pgsql-performance
Tree view
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 by date:

Previous
From: Shira Bezalel
Date:
Subject: Re: Seeking reason behind performance gain in 12 with HashAggregate
Next
From: Shira Bezalel
Date:
Subject: Re: Seeking reason behind performance gain in 12 with HashAggregate