FritsHoogland

3 ms·

1. 1.▲
   by FritsHoogland 3y ago

   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.
2. 2.▲
   by FritsHoogland 3y ago

   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.
3. 3.▲
   by FritsHoogland 3y ago

   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.