| From: | Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com> |
|---|---|
| To: | Dmitry Melnik <dm(at)ispras(dot)ru>, <pgsql-hackers(at)postgresql(dot)org> |
| Cc: | Ruben Buchatskiy <ruben(at)ispras(dot)ru>, Roman Zhuykov <zhroma(at)ispras(dot)ru>, Eugene Sharygin <eush(at)ispras(dot)ru> |
| Subject: | Re: JIT compiler for expressions |
| Date: | 2016-11-18 18:22:58 |
| Message-ID: | 0bcefb1e-9c5f-0ccd-552f-194012c1836e@BlueTreble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2016-11-18 20:00:46 | Re: pg_sequence catalog |
| Previous Message | Andres Freund | 2016-11-18 18:16:22 | Re: WAL recycle retading based on active sync rep. |