On 5/29/19 10:02 AM, Tobias Gierke wrote:
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 ?
No, the compilation still happens once for each worker. PostgreSQL 12 includes some smaller performance improvements for the JIT but nothing big like that.
Andreas
