Was Just About Time for JIT in PostgreSQL in v11
Hamid has more than 19 years of professional software development experience and has been involved with PostgreSQL for more than 8 years now. He was part of EnterpriseDB and managed PostgreSQL official installers for Windows, Linux and MacOS. Hamid has recently joined HighGo Software Inc. as Senior DevOps and Database Architect.
No video of the event yet, sorry!
Just in Time with LLVM is a performance feature introduced in v11 on *nix based operating systems. Additional packages were added to distributions which make use of LLVM and thereby provide JIT feature. As is the case with most performance features, JIT has some specific use cases where it can give a performance where it may negatively impact it. It's not for every workload type. We'll attempt to understand when and how to get a performance improvement using JIT. Some blogs suggest that more than half the queries for TPC-H show a degraded performance with JIT enabled, is that a myth or fact? From configuring JIT to analysing what works best and doesn't, we'll attempt to answer all these questions.
- 20 min
- Postgres Conference 2020