Show Your Support: Did you know that the hundreds of articles written on Phoronix each month are mostly authored by one individual? Phoronix.com doesn't have a whole news room with unlimited resources and relies upon people reading our content without blocking ads and alternatively by people subscribing to Phoronix Premium for our ad-free service with other extra features.
Pairing LLVM JIT With PostgreSQL Can Speed Up Database Performance
Dmitry Melnik presented at this month's LLVM Cauldron over speeding up the query execution performance of PostgreSQL by using LLVM. Particularly with complex queries, the CPU becomes the bottleneck for PostgreSQL rather than the disk. LLVM JIT is used for just-in-time compilation of queries.
Interpretation of Postgres queries can take over half of the execution time (56% is noted in one example) while using LLVM code generation lowered that query down to 6% of execution time.
Results published by the developer show it's possible to get 5~7x speedups on different synthetic tests and TPC-H while automatic code generation was faster by about 10%. This isn't the first time we've seen database developers toy with LLVM to try to significantly speed things up.
More details via these PDF slides or via the Cauldron presentation video embedded below.