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 <<a href=3D"mailto:[email protected]= m">[email protected]</a>> 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--