2

I am trying to turn on JIT for testing purposes on a Postgresql 12 server, it was off before.
My postgresql.conf has the following properties activated (basically all default values):

  • jit = on
  • jit_above_cost = 100000
  • jit_inline_above_cost=500000
  • jit_optimize_above_cost=500000
  • jit_provider = 'llvmjit'

I have also restarted the Postgres server service after editing the config.

Now when I run show jit I get on, however running SELECT pg_jit_available() returns false.
From the test queries I made it does not seem to include any JIT stuff happening in the query plan neither.

The documentation is a bit scarce on how configuration is done properly - is there anything I have missed about my setup?

Thanks!

0 Answers0