how about this: jit = off ?
Marcin On Wed, 17 Apr 2024 at 19:33, Johnathan Tiamoh <johnathantia...@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 PM Tomas Vondra < > tomas.von...@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 >> >
