Horton

RE: Performance degradation after upgrading from 9.5 to 14

Andreas Joseph Krogh <andreas@visena.com>

View thread View on postgr.es
From: Andreas Joseph Krogh <andreas@visena.com>
To: Zahir Lalani <ZahirLalani@oliver.agency>
Cc: Олександр Янін <aleksandr.janin@privatbank.ua>, Johnathan Tiamoh <johnathantiamoh@gmail.com>, "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2024-04-27T11:25:24Z
Lists: pgsql-general 

På lørdag 27. april 2024 kl. 11:46:26, skrev Zahir Lalani <
ZahirLalani@oliver.agency <mailto:ZahirLalani@oliver.agency>>:

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?



I can confirm this, even in v16 we've turned JIT off.






--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andreas@visena.com <mailto:andreas@visena.com>
www.visena.com <https://www.visena.com>
 <https://www.visena.com>