Expression JIT
– Open source:
github.com/ispras/postgres– Speedup up to 20% on TPC-H
• PostgreSQL Extension JIT (still developing)
– Speedup up to 5.5 times on TPC-H
• Caching JITted code for PREPARED statements
– Eliminate overhead on JIT compilation, useful for OLTP
• Index creation JIT
– Up to 19% speedup
• Experimental:
– Run time code specialization: up to 28% speedup
– Switching original PostgreSQL executor from pull to push model