Re: Sv: JIT in PostgreSQL 12 ?

Поиск
Список
Период
Сортировка
От Andreas Joseph Krogh
Тема Re: Sv: JIT in PostgreSQL 12 ?
Дата
Msg-id VisenaEmail.26.b2cf86e2c6fa0fb1.16b02df9deb@tc7-visena
обсуждение исходный текст
Ответ на Re: Sv: JIT in PostgreSQL 12 ?  (Tobias Gierke <tobias.gierke@code-sourcery.de>)
Список pgsql-performance
På onsdag 29. mai 2019 kl. 11:13:10, skrev Tobias Gierke <tobias.gierke@code-sourcery.de>:
Hi,
På onsdag 29. mai 2019 kl. 10:02:50, skrev Tobias Gierke <tobias.gierke@code-sourcery.de>:
Hi,

Browsing the PostgreSQL 12 release notes I noticed that JIT is now
enabled by default. Having not followed PostgreSQL development closely -
does this mean that compilation results are now getting cached and
compilation is no longer executed separately for each worker thread in a
parallel query ?
 
I don't know, but just want to chime in with my experience with PG-12 and JIT: Execution-time is still way worse then JIT=off for your queries so we'll turn JIT=off until we can mesure performance-gain.

Hm, that's a bummer. So I guess we'll also have to make sure JIT is turned off when upgrading.

That's what we'll do, unfortunately:-(
 
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
 
Вложения

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

Предыдущее
От: Tobias Gierke
Дата:
Сообщение: Re: Sv: JIT in PostgreSQL 12 ?
Следующее
От: Andreas Karlsson
Дата:
Сообщение: Re: JIT in PostgreSQL 12 ?