Re: Turn jit off for slow subquery in Postgres 12

2021-02-16 Thread Michael Lewis
Either turn it off, or increase jit_above_cost, jit_inline_above_cost, and/or jit_optimize_above_cost.

Re: Turn jit off for slow subquery in Postgres 12

2021-02-15 Thread Thomas Kellerer
Andrus schrieb am 16.02.2021 um 07:48: > Last year I posted testcase [1] which shows that using jit makes execution > magnitude slower ( 2.5s vs 0.4 sec) in typical shopping cart application > product search in Postgres 12. > > There are also other reports on this [2,3]. > > I tried to turn jit of