The current state of JIT in PostgreSQL
October 20–23
Level: Intermediate
Just-in-Time compilation has been available in PostgreSQL since v11, and it has been compiling query expressions ever since. JIT has the capability to make long-running queries go a lot faster, but it can also make short queries take longer than they should due to the cost of compilation and optimizing.
JIT is a fantastic technology with great potential, but our JIT support hasn't aged all that well and PostgreSQL 19 turns JIT of by default.
In this talk we will look at what JIT is, what PostgreSQL currently support as well as what is left to do in order to turn it on by default again. We will also look at current projects which are under way to hopefully improve JIT in releases to come.
