Sample Header Ad - 728x90

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