Re: Making JIT more granular

2022-05-15 Thread Andy Fan
> > > 2. You calculate the cost to compare with jit_above_cost as: > > plan->total_cost * plan->est_loops. > > An alternative way might be to consider the rescan cost like > cost_rescan. This should be closer for a final execution cost. > However since it is hard to set a reasonable jit_above_cost,

Re: Making JIT more granular

2022-05-13 Thread Andy Fan
Hi David: > Does anyone have any thoughts about this JIT costing? Is this an > improvement? Is there a better way? > > I think this is an improvement. However I'm not sure how much improvement & effort we want pay for it. I just shared my thoughts to start this discussion. 1. Ideally there i

Re: Making JIT more granular

2022-04-25 Thread David Rowley
(This is an old thread. See [1] if you're missing the original email.) On Tue, 4 Aug 2020 at 14:01, David Rowley wrote: > At the moment JIT compilation, if enabled, is applied to all > expressions in the entire plan. This can sometimes be a problem as > some expressions may be evaluated lots and

Making JIT more granular

2020-08-03 Thread David Rowley
Hi, At the moment JIT compilation, if enabled, is applied to all expressions in the entire plan. This can sometimes be a problem as some expressions may be evaluated lots and warrant being JITted, but others may only be evaluated just a few times, or even not at all. This problem tends to become