News for hackers. Stuff that matters.
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?
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. :)