On Mon, Jan 13, 2020 at 2:15 PM Alvaro Herrera
wrote:
> On 2020-Jan-13, Shira Bezalel wrote:
>
> > Hi All,
> >
> > I'm testing an upgrade from Postgres 9.6.16 to 12.1 and seeing a
> > significant performance gain in one specific query. This is really great,
>
Thanks Tomas. I ran a vacuum full on the 9.6 table -- still no difference
in the query plan. The shared buffers hit went up slightly to 36069.
Shira
On Mon, Jan 13, 2020 at 1:12 PM Tomas Vondra
wrote:
> On Mon, Jan 13, 2020 at 12:44:14PM -0800, Shira Bezalel wrote:
> >Hi Michael,
s 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
S
Hi Justin,
I'm seeing no difference in the query plan with JIT disabled in 12.1.
Thanks,
Shira
On Mon, Jan 13, 2020 at 8:42 AM Justin Pryzby wrote:
> On Mon, Jan 13, 2020 at 08:29:05AM -0800, Shira Bezalel wrote:
> > Here is the EXPLAIN (ANALYZE ON, BUFFERS ON) output fro
Hi All,
I'm testing an upgrade from Postgres 9.6.16 to 12.1 and seeing a
significant performance gain in one specific query. This is really great,
but I'm just looking to understand why. Reading through the release notes
across all the new versions (10, 11, 12) hasn't yielded an obvious cause,
but
