Re: Seeking reason behind performance gain in 12 with HashAggregate
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: Re: Seeking reason behind performance gain in 12 with HashAggregate
From
: Michael Lewis <mlewis@xxxxxxxxxxx>
Date
: Mon, 13 Jan 2020 11:07:16 -0700
Cc
: Justin Pryzby <pryzby@xxxxxxxxxxxxx>, postgres performance list <pgsql-performance@xxxxxxxxxxxxxx>
In-reply-to
: <CAE0KEwF-TZvn-Uar68Vem_jrKxoS=bzxmaBmxmFKFQ555-rg5Q@mail.gmail.com>
References
: <CAE0KEwGnDspRJjX=cdvGC69=F=76jbhiViDp=T5pPYR0xF2NAQ@mail.gmail.com> <
20200113164220.GH26045@telsasoft.com
> <CAE0KEwF-TZvn-Uar68Vem_jrKxoS=bzxmaBmxmFKFQ555-rg5Q@mail.gmail.com>
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.
Follow-Ups
:
Re: Seeking reason behind performance gain in 12 with HashAggregate
From:
Shira Bezalel
References
:
Seeking reason behind performance gain in 12 with HashAggregate
From:
Shira Bezalel
Re: Seeking reason behind performance gain in 12 with HashAggregate
From:
Justin Pryzby
Re: Seeking reason behind performance gain in 12 with HashAggregate
From:
Shira Bezalel
Prev by Date:
Re: Seeking reason behind performance gain in 12 with HashAggregate
Next by Date:
Re: Seeking reason behind performance gain in 12 with HashAggregate
Previous by thread:
Re: Seeking reason behind performance gain in 12 with HashAggregate
Next by thread:
Re: Seeking reason behind performance gain in 12 with HashAggregate
Index(es):
Date
Thread
[Postgresql General]
[Postgresql PHP]
[PHP Users]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Yosemite]
