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) -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
