Re: BUG #16183: PREPARED STATEMENT slowed down by jit

--000000000000601db2059b7c4dfc
Content-Type: text/plain; charset="UTF-8"

On Sun, Jan 5, 2020 at 7:21 PM Ryan Lambert <[email protected]> wrote:

>
> I tried applying your original patch and the later patch from that thread
> to REL_12_STABLE, unfortunately no luck on either.  The original patch
> errors with:
>
> $ git apply -p1 < array_type_analyze_MCE_V001.patch
> error: src/backend/utils/adt/array_typanalyze.c: already exists in working
> directory
>

I just use the GNU "patch -p1" command.  I don't  know what "git apply" is
up to here, and the error message isn't very informative.

By the way, the patch says "However, there is no histogram to fall back on
when the MCE array is NULL", which is a bit of nonsense.  It is ndistinct,
not histogram, which the scalar case falls back on when MCV is NULL.  But
there isn't an ndistinct for MCE either, so the conclusion is still sound.

Cheers,

Jeff

>

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

<div dir=3D"ltr"><div dir=3D"ltr">On Sun, Jan 5, 2020 at 7:21 PM Ryan Lambe=
rt &lt;<a href=3D"mailto:[email protected]">[email protected]</a>=
&gt; wrote:<br></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"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr" c=
lass=3D"gmail_attr"><br></div><div><div dir=3D"ltr"><div dir=3D"ltr"><div d=
ir=3D"ltr"><div>I tried applying your original patch and the later patch fr=
om that thread to REL_12_STABLE, unfortunately no luck on either.=C2=A0 The=
 original patch errors with:</div><div><br></div><div>$ git apply -p1 &lt; =
array_type_analyze_MCE_V001.patch<br></div><div>error: src/backend/utils/ad=
t/array_typanalyze.c: already exists in working directory<br></div></div></=
div></div></div></div></div></blockquote><div><br></div><div>I just use the=
 GNU &quot;patch -p1&quot; command.=C2=A0 I don&#39;t=C2=A0 know what &quot=
;git apply&quot; is up to here, and the error message isn&#39;t very inform=
ative.</div><div><br></div><div>By the way, the patch says &quot;However, t=
here is no histogram to fall back on when the MCE array is NULL&quot;, whic=
h is a bit of nonsense.=C2=A0 It is ndistinct, not histogram, which the sca=
lar case falls back on when MCV is NULL.=C2=A0 But there isn&#39;t an ndist=
inct for MCE either, so the conclusion is still sound.</div><div><br></div>=
<div>Cheers,</div><div><br></div><div>Jeff</div><blockquote class=3D"gmail_=
quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,=
204);padding-left:1ex"><div dir=3D"ltr"><div class=3D"gmail_quote"><blockqu=
ote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px=
 solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div class=3D"gm=
ail_quote"><div></div><blockquote class=3D"gmail_quote" style=3D"margin:0px=
 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><di=
v>
  </div>

</blockquote></div></div>
</blockquote></div></div>
</blockquote></div></div>

--000000000000601db2059b7c4dfc--