Re: Sv: JIT in PostgreSQL 12 ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,
På onsdag 29. mai 2019 kl. 10:02:50, skrev Tobias Gierke <tobias.gierke@xxxxxxxxxxxxxxxx>:
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



[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux