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.