pg_hint_plan - get the right plan without surprises
Talk by Franck Pachot
https://www.socallinuxexpo.org/scale/...
I frequently use pg_hint_plan to gain insights into the query planner choices made by the optimizer, and sometimes to work around issues that arise in production. However, hinting is often a complex task, requiring multiple hints to fix an exact plan. We will explore practical examples of how to use pg_hint_plan in a predictable manner, while also gaining a better understanding of access paths, join methods, and execution plan interpretation.