Date: 2024-10-02
Time: 15:00–15:50
Room: The Hub
Level: Intermediate
Feedback: Leave feedback
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 though understanding and examples on 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
The following slides have been made available for this session: