Re: JIT compiler for expressions

On 10/28/16 6:47 AM, Dmitry Melnik wrote:
> We'd like to present our work on adding LLVM JIT compilation of
> expressions in SQL queries for PostgreSQL. The source code (based on
> 9.6.1) along with brief manual is available at our
> github: https://github.com/ispras/postgres
> <https://github.com/ispras/postgres> . Сurrent speedup for TPC-H Q1 is
> 20% (on 40GB workload). Please feel free to test it and tell us what you
> think.

For anyone looking to experiment with some of this stuff, it's possible 
to get LLVM-based JIT via plpython and numba as well.

https://github.com/AustinPUG/PGDay2016/blob/master/Numba%20inside%20PostgreSQL.ipynb
-- 
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)