public inbox for [email protected]
help / color / mirror / Atom feedFrom: Johnathan Tiamoh <[email protected]>
To: Tomas Vondra <[email protected]>
Cc: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: Performance degradation after upgrading from 9.5 to 14
Date: Wed, 17 Apr 2024 13:32:49 -0400
Message-ID: <CACoPQdZ1AfRQoAf=Zw+H-bffR_g4m3vV4=O+p64b--_cqKS_-g@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CACoPQdb02ePEEdxGifTWWypke10tao_tKBmwi+7tu7KVkPdDuA@mail.gmail.com>
<[email protected]>
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 PM Tomas Vondra <[email protected]>
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
>
view thread (9+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Performance degradation after upgrading from 9.5 to 14
In-Reply-To: <CACoPQdZ1AfRQoAf=Zw+H-bffR_g4m3vV4=O+p64b--_cqKS_-g@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox