Re: performance degredation after upgrade from 9.6 to 12

Pavel Stehule <[email protected]> Mon, 16 Dec 2019 18:29:12 +0100
Newsgroups gmane.comp.db.postgresql.performance
Message-ID <CAFj8pRCr_Uvm9f5DUsnu=gxtB1Pf7n4xt1jgdRgUoGzPVsJMqw@mail.gmail.com>
--000000000000f6982b0599d58e78
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

po 16. 12. 2019 v 14:02 odes=C3=ADlatel Mariel Cherkassky <
[email protected]> napsal:

> I see, thank u !
> Maybe I didnt see big difference because most of my tables arent so big.
> My db`s size is 17GB and the largest table contains about 20M+ records.
>

Postgres 12 has enabled JIT by default.

Pavel


> Thanks again !
>

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

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote">=
<div dir=3D"ltr" class=3D"gmail_attr">po 16. 12. 2019 v=C2=A014:02 odes=C3=
=ADlatel Mariel Cherkassky &lt;<a href=3D"mailto:[email protected]=
m">[email protected]</a>&gt; napsal:<br></div><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex"><div dir=3D"rtl"><div dir=3D"rtl"><div dir=
=3D"ltr">I see, thank u !</div><div dir=3D"ltr">Maybe I didnt see big diffe=
rence because most of my tables arent so big. My db`s size is 17GB and the =
largest table contains about 20M+ records.</div></div></div></blockquote><d=
iv><br></div><div>Postgres 12 has enabled JIT by default.</div><div><br></d=
iv><div>Pavel</div><div><br></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"rtl"><div dir=3D"rtl"><div dir=3D"ltr"><br></div><di=
v dir=3D"ltr">Thanks again !</div></div></div>
</blockquote></div></div>

--000000000000f6982b0599d58e78--