Wiki / Configuration Parameters
jit_optimize_above_cost
Sets the query cost above which JIT compilation applies expensive optimizations. Such optimization adds planning time, but can improve execution speed. It is not meaningful to set this to less than jit_above_cost, and it is unlikely to be beneficial to set it to more than jit_inline_above_cost. Setting this to -1 disables expensive optimizations. The default is 500000.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- boot val
- 500000
- category
- Query Tuning / Planner Cost Constants
- context
- user
- documented
- true
- enumvals
- Unknown
- extra desc
- -1 disables optimization.
- lang
- en
- max val
- 1.79769e+308
- metadata version
- 18
- min val
- -1
- name
- jit_optimize_above_cost
- short desc
- Optimize JIT-compiled functions if query is more expensive.
- source
- pg-settings-source-snapshot
- unit
- Unknown
- vartype
- real
Definition PG 18
Sets the query cost above which JIT compilation applies expensive optimizations. Such optimization adds planning time, but can improve execution speed. It is not meaningful to set this to less than jit_above_cost, and it is unlikely to be beneficial to set it to more than jit_inline_above_cost. Setting this to -1 disables expensive optimizations. The default is 500000.
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · wiki-repair-20261023:0df69aa66371190b9197b303a2214a122eba568e54c1a158bcf026582fddf859
Text language: en · wiki-repair-20261023:0df69aa66371190b9197b303a2214a122eba568e54c1a158bcf026582fddf859