PostgreSQL 11 Won't Ship With Its Faster JIT Support Enabled By Default

[phoronix]

Phoronix: PostgreSQL 11 Won't Ship With Its Faster JIT Support Enabled By Default

One of the coolest innovations landing this year in PostgreSQL was LLVM-based JIT support to speed up database queries. But it's not going to be enabled by default in the upcoming PostgreSQL 11 release...

http://www.phoronix.com/scan.php?page=news_item&px=PostgreSQL-JIT-No-11-Default

[Almindor]

Based on what they said in the mailing list I think this is a very good decision. The JIT can be enabled per-query as needed and used on queries where it's proven to be useful while not risking major slowdowns or bugs on production environments "just because".

I'm sure it'll be mature enough by v12

[Delgarde]

Based on what they said in the mailing list I think this is a very good decision. The JIT can be enabled per-query as needed and used on queries where it's proven to be useful while not risking major slowdowns or bugs on production environments "just because".

Yep... best not to follow Oracle's example, where the new adaptive-plan features in 12c were enabled by default before they were ready, crippling performance for a significant proportion of their customers.