Postgres Pro
Downloads
Home   >   mailing lists

Sv: JIT in PostgreSQL 12 ? - Mailing list pgsql-performance

From Andreas Joseph Krogh
Subject Sv: JIT in PostgreSQL 12 ?
Date
Msg-id VisenaEmail.21.c9f137cb2e7b98d4.16b02c4aacc@tc7-visena
Whole thread Raw
In response to JIT in PostgreSQL 12 ?  (Tobias Gierke <tobias.gierke@code-sourcery.de>)
Responses Re: Sv: JIT in PostgreSQL 12 ?
Re: Sv: JIT in PostgreSQL 12 ?
List pgsql-performance
Tree view
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.
 
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
 
Attachment

pgsql-performance by date:

Previous
From: Mariel Cherkassky
Date:
Subject: Re: improve wals replay on secondary
Next
From: Tobias Gierke
Date:
Subject: Re: Sv: JIT in PostgreSQL 12 ?