News for hackers. Stuff that matters.

A comment on JITing PostgreSQL using LLVM [pdf].

Re:JITing PostgreSQL using LLVM [pdf] by barrkel on Saturday February 03, 2018 @06:38PM (#16300343)
Cloudera Impala also uses LLVM to JIT chunks of the query plan into machine code.
[ Parent | on HN ]
Re:JITing PostgreSQL using LLVM [pdf] by Xorlev on Saturday February 03, 2018 @11:22PM (#16301318)
It makes a ton of sense for Impala/Presto, OLAP tends to be about throughput (long queries over lots of data) which benefits from this kind of JIT compilation since the overhead is amortized.

Really excited to see it makes its way into Postgres.

[ Parent | on HN ]
Re:JITing PostgreSQL using LLVM [pdf] by electrum on Saturday February 03, 2018 @08:17PM (#16300687)
Presto generates Java bytecode which is then turned into machine code by the JVM JIT.
[ Parent | on HN ]
Re:JITing PostgreSQL using LLVM [pdf] by CandidlyFake on Saturday February 03, 2018 @08:35PM (#16300749)
Don't all DB servers "JIT" and then cache query plan?
[ Parent | on HN ]
Re:JITing PostgreSQL using LLVM [pdf] by riku_iki on Saturday February 03, 2018 @09:56PM (#16301037)
Executing machine code still can be more performant than interpreting cached execution plan.
[ Parent | on HN ]