Re: Sv: JIT in PostgreSQL 12 ?

Tobias Gierke <[email protected]>
Newsgroups gmane.comp.db.postgresql.performance
Message-ID <[email protected]>
Hi,
> På onsdag 29. mai 2019 kl. 10:02:50, skrev Tobias Gierke 
> <[email protected] <mailto:[email protected]>>:
>
>     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.

Thanks,
Tobias
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.