News for hackers. Stuff that matters.
Re:PostgreSQL Parallel Query v2 by jordanthoms on Tuesday March 14, 2017 @09:43PM (#13873145)
Is it significant when you are talking about​ analytical queries which are running for minutes or hours? Seems like it wouldn't be a huge amount of code to JIT compared to the payoff?
Re:PostgreSQL Parallel Query v2 by electrum on Wednesday March 15, 2017 @09:37PM (#13881634)
Presto, which is designed for analytics, does JIT to bytecode on every query and still works fine on sub-second queries. One potential difference with LLVM is that the JVM will profile and only generate machine code for hot code, so short queries might use JVM interpreted bytecode.

But you are absolutely correct that for long running analytic queries, the up front cost of generating optimized code pays off.