| Type: | real |
| Default: | 500000 |
| Min: | -1 |
| Max: | 1.79769e+308 |
| Context: | user |
| Restart: | false |
| Since: | 11 |
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.
On StackOverflow
- Geoserver WFS + PostgreSQL with large table impossibly slow
- Java Hibernate insert hypertable in timescaledb is very slow
- Why does "explain analyzing" this query fnish fast (showing a parallel plan), while running the actual query without "explain analyze" doesn't?
- PostgreSQL 13 sometimes works but sometimes huge execution time
- Postgresql sequential scan slow performance on 500 million rows