MIME-Version: 1.0
References: <CACoPQdb02ePEEdxGifTWWypke10tao_tKBmwi+7tu7KVkPdDuA@mail.gmail.com>
 <72c40850-1dc6-41a9-ba90-e19328999ea8@enterprisedb.com>
In-Reply-To: <72c40850-1dc6-41a9-ba90-e19328999ea8@enterprisedb.com>
From: Johnathan Tiamoh <johnathantiamoh@gmail.com>
Date: Wed, 17 Apr 2024 13:32:49 -0400
Message-ID: <CACoPQdZ1AfRQoAf=Zw+H-bffR_g4m3vV4=O+p64b--_cqKS_-g@mail.gmail.com>
Subject: Re: Performance degradation after upgrading from 9.5 to 14
To: Tomas Vondra <tomas.vondra@enterprisedb.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000c1e07106164e3ebb"
Archived-At: <https://www.postgresql.org/message-id/CACoPQdZ1AfRQoAf%3DZw%2BH-bffR_g4m3vV4%3DO%2Bp64b--_cqKS_-g%40mail.gmail.com>
Precedence: bulk

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

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@enterpri=
sedb.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
>

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

<div dir=3D"ltr">1) How did you upgrade? pg_dump or pg_upgrade?<div><br></d=
iv><div>I use pg_ugrade with kink option.<br><br>2) Did you run ANALYZE to =
collect statistics after the upgrade?</div><div><br></div><div><br></div><d=
iv>Yes. I ran vacuumdb-analyze in stages after the upgrade<br><br>3) Did yo=
u transfer the configuration, or did you just create a new<br>cluster with =
the default values?</div><div><br></div><div>I transfer=C2=A0the configurat=
ion<br><br>4) What exactly is slower? Queries? Inserts?</div><div><br></div=
><div>queries</div><div><br>5) Can you quantify the impact? Is it 2x slower=
? 100x slower?<br></div><div><br></div><div>it&#39;s more than 5 times slow=
er than before. Very high load averages=C2=A0</div></div><br><div class=3D"=
gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, Apr 17, 2024 at =
1:25=E2=80=AFPM Tomas Vondra &lt;<a href=3D"mailto:tomas.vondra@enterprised=
b.com">tomas.vondra@enterprisedb.com</a>&gt; wrote:<br></div><blockquote cl=
ass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid=
 rgb(204,204,204);padding-left:1ex">On 4/17/24 19:13, Johnathan Tiamoh wrot=
e:<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>

--000000000000c1e07106164e3ebb--