I'm not sure, does it helps you but read this:
https://www.cybertec-postgresql.com/en/b-tree-index-improvements-in-postgresql-v12/
https://www.cybertec-postgresql.com/en/b-tree-index-improvements-in-postgresql-v12/
"Since upgrading with pg_upgrade does not change the data files, indexes will still be in version 3 after an upgrade"
I reindexed all my database, when did upgrade pg<12 -> pg>=12 if pg_upgrade was a tool. exp-imp for upgrade does not need reindex.
br
Kaido
I reindexed all my database, when did upgrade pg<12 -> pg>=12 if pg_upgrade was a tool. exp-imp for upgrade does not need reindex.
br
Kaido
On Wed, 17 Apr 2024 at 20:39, Marcin Giedz <marcin.giedz@xxxxxxxx> wrote:
how about this:jit = off ?MarcinOn Wed, 17 Apr 2024 at 19:33, Johnathan Tiamoh <johnathantiamoh@xxxxxxxxx> 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 averagesOn Wed, Apr 17, 2024 at 1:25 PM Tomas Vondra <tomas.vondra@xxxxxxxxxxxxxxxx> 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
