Date: 2026-01-30
Time: 11:50–12:40
Room: Ballroom B
Level: Intermediate
JIT has been part of PostgreSQL for the past 6 years. Yet, why are we (you maybe, me surely) using "jit = off" in our postgresql.conf file? In this talk, we will answer this question, and many many more you may have asked yourself about JIT compilation: - what is JIT compilation exactly? How does it differ between PostgreSQL and other well-known JIT users (JVM, CLR, spidermonkey, V8...) - what is compiled in PostgreSQL currently? - what are the benefits and drawbacks of LLVM as a JIT provider? - any alternative JIT provider around, aka how fast could PostgreSQL get?