RE: Performance degradation after upgrading from 9.5 to 14

Поиск
Список
Период
Сортировка
От Zahir Lalani
Тема RE: Performance degradation after upgrading from 9.5 to 14
Дата
Msg-id AS8P251MB01201F6725206A713DB58C77A7152@AS8P251MB0120.EURP251.PROD.OUTLOOK.COM
обсуждение исходный текст
Ответ на Re: Performance degradation after upgrading from 9.5 to 14  (Олександр Янін <aleksandr.janin@privatbank.ua>)
Ответы RE: Performance degradation after upgrading from 9.5 to 14  (Andreas Joseph Krogh <andreas@visena.com>)
Список pgsql-general
Дерево обсуждения

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: Олександр Янін <aleksandr.janin@privatbank.ua>
Sent: Monday, April 22, 2024 8:01 PM
To: Johnathan Tiamoh <johnathantiamoh@gmail.com>
Cc: pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: Performance degradation after upgrading from 9.5 to 14

 

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) 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 <johnathantiamoh@gmail.com>:

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 ?

 

В списке pgsql-general по дате отправления:

Предыдущее
От: Riku Iki
Дата:
Сообщение: Re: Preallocation changes in Postgresql 16
Следующее
От: Andreas Joseph Krogh
Дата:
Сообщение: RE: Performance degradation after upgrading from 9.5 to 14