On 3/9/18 15:42, Peter Eisentraut wrote: > The default of jit_above_cost = 500000 seems pretty good. I constructed > a query that cost about 450000 where the run time with and without JIT > were about even. This is obviously very limited testing, but it's a > good start.
Actually, the default in your latest code is 100000, which per my analysis would be too low. Did you arrive at that setting based on testing? -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services