<< Talks

pg_hint_plan – get the right plan without surprises

13:45 - 14:30

YugabyteDB Franck Pachot

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. In this live demo session, we will go through understanding and examples of how to use pg_hint_plan in a predictable way. It is also a good occasion to understand the access paths, join order and methods, and how to read an execution plan

Franck Pachot
Franck Pachot

Developer Advocate for YugabyteDB, the open-source, postgres-compatible distributed SQL database. With 20+ years in databases from dev to ops, Franck loves to share and learn (https://dev.to/franckpachot - twitter: @FranckPachot). Oracle ACE Director and AWS Data Hero