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.

Franck Pachot

Developer Advocate at Yugabyte

Lausanne, Switzerland

View Speaker Profile