Precision performance surgery for CostgreSQL

Dennis Butterstein, Torsten Grust
2016 Proceedings of the VLDB Endowment  
We demonstrate how the compilation of SQL expressions into machine code leads to significant query runtime improvements in PostgreSQL 9. Our primary goal is to connect recent research in query code generation with one of the most widely deployed database engines. The approach calls on LLVM to translate arithmetic and filter expressions into native x86 instructions just before SQL query execution begins. We deliberately follow a non-invasive design that does not turn PostgreSQL on its head:
more » ... preted and compiled expression evaluation coexist and both are used to execute the same query. We will bring an enhanced version of PostgreSQL that exhibits notable runtime savings and provides visual insight into exactly where and how execution plans can benefit from SQL expression compilation.
doi:10.14778/3007263.3007298 fatcat:pkcczcrsj5bw5hn3qoezdccfwq