On 16/02/2023 17:07, David G. Johnston wrote:
>
> No, the planner may not cause execution. While I could imagine
> extending EXPLAIN to somehow retrieve and maybe even try alternative
> plans that have been fully constructed today I'm not holding my breath.
>
> There is little reason for the project to give any real weight to
> "assuming the query to be immutable". We do want to fix the planner
> to behave better if it is mis-behaving, otherwise you do have access
> to cost parameters, and potentially other planner toggles if you've
> truly run into an intractable problem.
>
> David J.
>
Fair on both points. I didn't know planner toggles existed, I'll play
with that.