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!