FritsHoogland
Re:Pg_hint_plan: Force PostgreSQL to execute query plans the way you want
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 way you want
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:
on Tuesday August 22, 2023 @03:42PM (#37227611)
This is a blogpost that looks into how to assess CPU usage and machine load. Introduction of a new tool that uses node_exporter to perform sar, iostat, vmstat, etc. like functionality.