Re:Pg_hint_plan: Force PostgreSQL to execute query plans the...
by th3iedkid on Saturday March 16, 2024 @06:20AM
(#39724664)
Isn’t hinting more like asking nicely than forcing the engine to choose the other way?
[ Parent
| on HN ]
Re:Pg_hint_plan: Force PostgreSQL to execute query plans the...
by pm90 on Saturday March 16, 2024 @08:04AM
(#39725156)
you can’t really do the latter.
Re:Pg_hint_plan: Force PostgreSQL to execute query plans the...
by FritsHoogland on Saturday March 16, 2024 @10:45AM
(#39726405)
It'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.
Re:Pg_hint_plan: Force PostgreSQL to execute query plans the...
by FritsHoogland on Saturday March 16, 2024 @10:47AM
(#39726418)
But 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.
Re:Pg_hint_plan: Force PostgreSQL to execute query plans the...
by justinclift on Saturday March 16, 2024 @06:07PM
(#39729906)
Yeah, 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.
Re:Pg_hint_plan: Force PostgreSQL to execute query plans the...
by ioltas on Saturday March 16, 2024 @08:33PM
(#39730744)
I’ll try to do something about that tomorrow, saw your ticket.
Re:Pg_hint_plan: Force PostgreSQL to execute query plans the...
by justinclift on Saturday March 16, 2024 @11:24PM
(#39731663)
No worries at all. :)