Re: Seeking reason behind performance gain in 12 with HashAggregate
Michael Lewis <[email protected]> Mon, 13 Jan 2020 11:07:16 -0700
| Newsgroups | gmane.comp.db.postgresql.performance |
|---|---|
| Message-ID | <CAHOFxGo8tXqvsC6=X_SCu-p2_xTb1+xYWWfv3JdcVKnftKjxEQ@mail.gmail.com> |
--00000000000005f58a059c095a11 Content-Type: text/plain; charset="UTF-8" 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. > --00000000000005f58a059c095a11 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr"><div>I am not at all familiar with PostGIS so perhaps this= is a silly=C2=A0question, is bloat an issue on the older instance? Correla= tion isn't causation, but half the buffers scanned and half the runtime= in the v12 plan has me curious why that might be.</div><div class=3D"gmail= _quote"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex= ;border-left:1px solid rgb(204,204,204);padding-left:1ex"> </blockquote></div></div> --00000000000005f58a059c095a11--