7 ms·
Isn’t hinting more like asking nicely than forcing the engine to choose the other way?
by th3iedkid 3y ago
Isn’t hinting more like asking nicely than forcing the engine to choose the other way?
- justinclift 3y agoYeah, I probably could have used better wording for the title submission. The GitHub repo's wording is broken english currently though which is (probably?) worse.
- ioltas 3y agoI’ll try to do something about that tomorrow, saw your ticket.
- justinclift 3y agoNo worries at all. :)
- pm90 3y agoyou can’t really do the latter.
- FritsHoogland 3y agoIt's a bit of both. What pg_hint_plan does is change the cost to favour the hinted suggestion. If hinted suggestion is impossible, the planner will still perform something else.
- FritsHoogland 3y agoBut if 'force' means changing what it would do otherwise, where 'otherwise' is: a different plan having the lowest cost, the: yes that is exactly what it does.