public inbox for [email protected]  

help / color / mirror / Atom feed

From: Zahir Lalani <[email protected]>
To: Олександр Янін <[email protected]>
To: Johnathan Tiamoh <[email protected]>
Cc: pgsql-generallists.postgresql.org <[email protected]>
Subject: RE: Performance degradation after upgrading from 9.5 to 14
Date: Sat, 27 Apr 2024 09:46:26 +0000
Message-ID: <AS8P251MB01201F6725206A713DB58C77A7152@AS8P251MB0120.EURP251.PROD.OUTLOOK.COM> (raw)
In-Reply-To: <CAGwXR3q7fatVF6x+jyGWua4MVFcgHiUZwOgvWvX4E=sXQRpBrQ@mail.gmail.com>
References: <CACoPQdb02ePEEdxGifTWWypke10tao_tKBmwi+7tu7KVkPdDuA@mail.gmail.com>
	<CAGwXR3q7fatVF6x+jyGWua4MVFcgHiUZwOgvWvX4E=sXQRpBrQ@mail.gmail.com>

Same issue and took us ages to work out that is was JIT! The default is on, and setting off solves the problem. I have seen several blogs reporting the same and so wonder why this default is on?

Z

From: Олександр Янін <[email protected]>
Sent: Monday, April 22, 2024 8:01 PM
To: Johnathan Tiamoh <[email protected]>
Cc: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: Performance degradation after upgrading from 9.5 to 14

You don't often get email from [email protected]<mailto:[email protected]>. Learn why this is important<https://aka.ms/LearnAboutSenderIdentification;

CAUTION: This email originated from outside of the organisation. Do not click links or open attachments unless you recognise the sender and know the content is safe. Visit the information security portal (MetaCompliance - MyCompliance Cloud)<https://launcher.myapps.microsoft.com/api/signin/c773a37f-a0e3-4e64-98a8-3bd3dc6c6392?tenantId=e519c...; to do your training.

Try setting enable_memoize to off.
Our practice has shown that enabling this parameter by default often resulted in less than optimal query plans in the cache.


ср, 17 апр. 2024 г. в 20:13, Johnathan Tiamoh <[email protected]<mailto:[email protected]>>:
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 ?

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], [email protected]
  Subject: RE: Performance degradation after upgrading from 9.5 to 14
  In-Reply-To: <AS8P251MB01201F6725206A713DB58C77A7152@AS8P251MB0120.EURP251.PROD.OUTLOOK.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