Re: Seeking reason behind performance gain in 12 with HashAggregate

--000000000000ebfb4a059c08e33b
Content-Type: text/plain; charset="UTF-8"

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 <[email protected]> wrote:

> On Mon, Jan 13, 2020 at 08:29:05AM -0800, Shira Bezalel wrote:
> > Here is the EXPLAIN (ANALYZE ON, BUFFERS ON) output from both systems:
> >
> > 9.6 plan <https://explain.depesz.com/s/W8HN>
> > 12.1 plan <https://explain.depesz.com/s/lIRS>
>
> > Is there something that was changed/improved in either 10, 11 or 12 that
> this
> > behavior can be attributed to?
>
> v12 has JIT enabled by default.
> You can test if that's significant with SET jit=off.
>


-- 
Shira Bezalel
Database Administrator & Desktop Support Manager
San Francisco Estuary Institute
www.sfei.org
Ph: 510-746-7304

--000000000000ebfb4a059c08e33b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_default" style=3D"font-family:tahoma,s=
ans-serif">Hi Justin,</div><div class=3D"gmail_default" style=3D"font-famil=
y:tahoma,sans-serif"><br></div><div class=3D"gmail_default" style=3D"font-f=
amily:tahoma,sans-serif">I&#39;m seeing no difference in the query plan wit=
h JIT disabled in 12.1.=C2=A0</div><div class=3D"gmail_default" style=3D"fo=
nt-family:tahoma,sans-serif"><br></div><div class=3D"gmail_default" style=
=3D"font-family:tahoma,sans-serif">Thanks,</div><div class=3D"gmail_default=
" style=3D"font-family:tahoma,sans-serif">Shira<br></div></div><br><div cla=
ss=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Mon, Jan 13, 20=
20 at 8:42 AM Justin Pryzby &lt;<a href=3D"mailto:[email protected]" tar=
get=3D"_blank">[email protected]</a>&gt; wrote:<br></div><blockquote cla=
ss=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid =
rgb(204,204,204);padding-left:1ex">On Mon, Jan 13, 2020 at 08:29:05AM -0800=
, Shira Bezalel wrote:<br>
&gt; Here is the EXPLAIN (ANALYZE ON, BUFFERS ON) output from both systems:=
<br>
&gt; <br>
&gt; 9.6 plan &lt;<a href=3D"https://explain.depesz.com/s/W8HN" rel=3D"nore=
ferrer" target=3D"_blank">https://explain.depesz.com/s/W8HN</a>&gt;<br>
&gt; 12.1 plan &lt;<a href=3D"https://explain.depesz.com/s/lIRS" rel=3D"nor=
eferrer" target=3D"_blank">https://explain.depesz.com/s/lIRS</a>&gt;<br>
<br>
&gt; Is there something that was changed/improved in either 10, 11 or 12 th=
at this<br>
&gt; behavior can be attributed to?<br>
<br>
v12 has JIT enabled by default.<br>
You can test if that&#39;s significant with SET jit=3Doff.<br>
</blockquote></div><br clear=3D"all"><div><br></div>-- <br><div dir=3D"ltr"=
><div dir=3D"ltr"><div><div dir=3D"ltr"><div><div dir=3D"ltr"><div><div><fo=
nt color=3D"#666666" face=3D"tahoma, sans-serif" size=3D"2">Shira Bezalel=
=C2=A0</font></div><div><font color=3D"#666666" face=3D"tahoma, sans-serif"=
 size=3D"2">Database Administrator &amp; Desktop Support=C2=A0</font><span =
style=3D"color:rgb(102,102,102);font-family:tahoma,sans-serif;font-size:sma=
ll">Manager</span></div><div><font color=3D"#666666" face=3D"tahoma, sans-s=
erif" size=3D"2">San Francisco Estuary Institute</font></div><div><font col=
or=3D"#666666" face=3D"tahoma, sans-serif" size=3D"2"><a href=3D"http://www=
.sfei.org" target=3D"_blank">www.sfei.org</a></font></div><div><font color=
=3D"#666666" face=3D"tahoma, sans-serif" size=3D"2">Ph: 510-746-7304</font>=
</div></div><div style=3D"font-weight:bold;font-style:normal;font-variant:n=
ormal;line-height:20px;margin:0px"><br style=3D"color:rgb(0,0,0);font-famil=
y:Tahoma;font-size:13px;font-weight:normal;line-height:normal"></div>
<div style=3D"padding-top:8px">
	=C2=A0</div></div></div></div></div></div></div>

--000000000000ebfb4a059c08e33b--