Re: [HACKERS] Linear vs. nonlinear planner cost estimates

2016-12-16 Thread Robert Haas
On Wed, Dec 14, 2016 at 3:46 PM, Tom Lane wrote: > The really *critical* aspect of this, which could cost far more than a > few extra executions of a costing function, comes in if it damages > add_path's ability to prune inferior paths early. So we would not want > to simply drop the startup_cost

Re: [HACKERS] Linear vs. nonlinear planner cost estimates

2016-12-14 Thread Tom Lane
Robert Haas writes: > On Wed, Dec 14, 2016 at 2:12 PM, Tom Lane wrote: >> I don't have a concrete proposal right now about how to fix this. The >> most expansive response would be to decorate every path with an explicitly >> nonlinear cost function, which would need to be able to report the cost

Re: [HACKERS] Linear vs. nonlinear planner cost estimates

2016-12-14 Thread Robert Haas
On Wed, Dec 14, 2016 at 2:12 PM, Tom Lane wrote: > I don't have a concrete proposal right now about how to fix this. The > most expansive response would be to decorate every path with an explicitly > nonlinear cost function, which would need to be able to report the cost > to fetch the first N tu