pg_jit_available showing 'false' and jit not working, but config file seems set up properly
2
votes
0
answers
698
views
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](https://www.postgresql.org/docs/11/jit-configuration.html) is a bit scarce on how configuration is done properly - is there anything I have missed about my setup?
Thanks!
Asked by bakamitai666
(21 rep)
Aug 18, 2021, 03:17 PM