News for hackers. Stuff that matters.

A comment on Pg_hint_plan: Force PostgreSQL to execute query plans the way you want. Parent comment

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.
[ Parent | on HN ]
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.
[ Parent | on HN ]