Skip to content

Did you know?

PostgreSQL 19 turns JIT compilation off by default.

Benchmark big analytical queries after upgrading; set jit = on if they got slower.

  • Programming
  • Applies to PostgreSQL 19
  • Last checked

Explained

Until PostgreSQL 18, JIT compilation was on and kicked in when a query’s estimated cost was high. Those estimates proved unreliable, so PostgreSQL 19 ships with jit = off:

postgres=# SHOW jit;
 jit
-----
 off

Most OLTP workloads won’t notice, and some get faster. If you run large analytical queries, compare their timings after upgrading and turn JIT back on in postgresql.conf, or per session:

SET jit = on;

Learn more

← All tech tips · Suggest a fix

Back to top