MIME-Version: 1.0
References: <CACoPQdb02ePEEdxGifTWWypke10tao_tKBmwi+7tu7KVkPdDuA@mail.gmail.com>
 <72c40850-1dc6-41a9-ba90-e19328999ea8@enterprisedb.com> <CACoPQdZ1AfRQoAf=Zw+H-bffR_g4m3vV4=O+p64b--_cqKS_-g@mail.gmail.com>
In-Reply-To: <CACoPQdZ1AfRQoAf=Zw+H-bffR_g4m3vV4=O+p64b--_cqKS_-g@mail.gmail.com>
From: Marcin Giedz <marcin.giedz@arise.pl>
Date: Wed, 17 Apr 2024 19:38:57 +0200
Message-ID: <CAEJ6yN3CghLmJ5fhGCLRM3zw6qRjmffk+M-CJxOboTyvT4X0qw@mail.gmail.com>
Subject: Re: Performance degradation after upgrading from 9.5 to 14
To: Johnathan Tiamoh <johnathantiamoh@gmail.com>
Cc: Tomas Vondra <tomas.vondra@enterprisedb.com>, 
	"pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000dab49606164e551c"
Archived-At: <https://www.postgresql.org/message-id/CAEJ6yN3CghLmJ5fhGCLRM3zw6qRjmffk%2BM-CJxOboTyvT4X0qw%40mail.gmail.com>
Precedence: bulk

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

how about this:

jit =3D off ?

Marcin


On Wed, 17 Apr 2024 at 19:33, Johnathan Tiamoh <johnathantiamoh@gmail.com>
wrote:

> 1) How did you upgrade? pg_dump or pg_upgrade?
>
> I use pg_ugrade with kink option.
>
> 2) Did you run ANALYZE to collect statistics after the upgrade?
>
>
> Yes. I ran vacuumdb-analyze in stages after the upgrade
>
> 3) Did you transfer the configuration, or did you just create a new
> cluster with the default values?
>
> I transfer the configuration
>
> 4) What exactly is slower? Queries? Inserts?
>
> queries
>
> 5) Can you quantify the impact? Is it 2x slower? 100x slower?
>
> it's more than 5 times slower than before. Very high load averages
>
> On Wed, Apr 17, 2024 at 1:25=E2=80=AFPM Tomas Vondra <
> tomas.vondra@enterprisedb.com> wrote:
>
>> On 4/17/24 19:13, Johnathan Tiamoh wrote:
>> > Hello,
>> >
>> >
>> > I performed an  upgrade from postgresql-9.5 to postgresql-14 and the
>> > performance has degraded drastically.
>> >
>> > Please, is they any advice on getting performance back ?
>> >
>>
>> There's very little practical advice we can provide based on this
>> report, because it's missing any useful details. There's a number of
>> things that might have caused this, but we'd have to speculate.
>>
>> For example:
>>
>> 1) How did you upgrade? pg_dump or pg_upgrade?
>>
>> 2) Did you run ANALYZE to collect statistics after the upgrade?
>>
>> 3) Did you transfer the configuration, or did you just create a new
>> cluster with the default values?
>>
>> 4) What exactly is slower? Queries? Inserts?
>>
>> 5) Can you quantify the impact? Is it 2x slower? 100x slower?
>>
>>
>> regards
>>
>>
>> --
>> Tomas Vondra
>> EnterpriseDB: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>

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

<div dir=3D"ltr">how about this:<div><br></div><div>jit =3D off ?</div><div=
><br></div><div>Marcin<br></div><div><br></div></div><br><div class=3D"gmai=
l_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, 17 Apr 2024 at 19:33=
, Johnathan Tiamoh &lt;<a href=3D"mailto:johnathantiamoh@gmail.com">johnath=
antiamoh@gmail.com</a>&gt; wrote:<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"ltr">1) How did you upgrade? pg_dump or pg_up=
grade?<div><br></div><div>I use pg_ugrade with kink option.<br><br>2) Did y=
ou run ANALYZE to collect statistics after the upgrade?</div><div><br></div=
><div><br></div><div>Yes. I ran vacuumdb-analyze in stages after the upgrad=
e<br><br>3) Did you transfer the configuration, or did you just create a ne=
w<br>cluster with the default values?</div><div><br></div><div>I transfer=
=C2=A0the configuration<br><br>4) What exactly is slower? Queries? Inserts?=
</div><div><br></div><div>queries</div><div><br>5) Can you quantify the imp=
act? Is it 2x slower? 100x slower?<br></div><div><br></div><div>it&#39;s mo=
re than 5 times slower than before. Very high load averages=C2=A0</div></di=
v><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On W=
ed, Apr 17, 2024 at 1:25=E2=80=AFPM Tomas Vondra &lt;<a href=3D"mailto:toma=
s.vondra@enterprisedb.com" target=3D"_blank">tomas.vondra@enterprisedb.com<=
/a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0=
px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">O=
n 4/17/24 19:13, Johnathan Tiamoh wrote:<br>
&gt; Hello,<br>
&gt; <br>
&gt; <br>
&gt; I performed an=C2=A0 upgrade from postgresql-9.5 to postgresql-14 and =
the<br>
&gt; performance has degraded drastically.<br>
&gt; <br>
&gt; Please, is they any advice on getting performance back ?<br>
&gt; <br>
<br>
There&#39;s very little practical advice we can provide based on this<br>
report, because it&#39;s missing any useful details. There&#39;s a number o=
f<br>
things that might have caused this, but we&#39;d have to speculate.<br>
<br>
For example:<br>
<br>
1) How did you upgrade? pg_dump or pg_upgrade?<br>
<br>
2) Did you run ANALYZE to collect statistics after the upgrade?<br>
<br>
3) Did you transfer the configuration, or did you just create a new<br>
cluster with the default values?<br>
<br>
4) What exactly is slower? Queries? Inserts?<br>
<br>
5) Can you quantify the impact? Is it 2x slower? 100x slower?<br>
<br>
<br>
regards<br>
<br>
<br>
-- <br>
Tomas Vondra<br>
EnterpriseDB: <a href=3D"http://www.enterprisedb.com" rel=3D"noreferrer" ta=
rget=3D"_blank">http://www.enterprisedb.com</a><br>
The Enterprise PostgreSQL Company<br>
</blockquote></div>
</blockquote></div>

--000000000000dab49606164e551c--