Session
pg_hint_plan - hinting without surprises
I use pg_hint_plan to learn about the optimizer, to understand the query planner choices, and sometimes, workaround a problem in production. But hinting is not easy. Fixing the exact plan needs more than one hint. Here are some tips and examples to use pg_hint_plan without surprises.