Re: performance degredation after upgrade from 9.6 to 12

--0000000000006cb5e20599d0ca7b
Content-Type: text/plain; charset="UTF-8"

Hey Jeff,Andrew,
I continued testing the 12version vs the 96 version and it seems that there
is almost non diff and in some cases pg96 is faster than 12. I compared the
content of pg_stat_statements after each test that I have done and it seems
that the db time is almost the same and sometimes 96 is faster by 5%.

Any idea why there isnt any improvement even when I enabled the parallel
params in 12 ?
I can add a few examples if needed..

>

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

<div dir=3D"rtl"><div dir=3D"ltr" style=3D"">Hey Jeff,Andrew,</div><div dir=
=3D"ltr" style=3D"">I continued testing the 12version vs the 96 version and=
 it seems that there is almost non diff and in some cases pg96 is faster th=
an 12. I compared the content of pg_stat_statements after each test that I =
have done and it seems that the db time is almost the same and sometimes 96=
 is faster by 5%.</div><div dir=3D"ltr" style=3D""><br></div><div dir=3D"lt=
r" style=3D"">Any idea why there isnt any improvement even when I enabled t=
he parallel params in 12 ?</div><div dir=3D"ltr" style=3D"">I can add a few=
 examples if needed..</div><div class=3D"gmail_quote"><blockquote class=3D"=
gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(20=
4,204,204);padding-left:1ex">
</blockquote></div></div>

--0000000000006cb5e20599d0ca7b--