pg_hint_plan – get the right plan without surprises
Presented by:
Amit Chauhan
Amit Chauhan is a Pre Sales Engineer at Yugabyte with a deep passion for Data Analytics and Cloud-Native technologies. In his current role, he collaborates with Fortune 500 enterprises to architect their business applications with scalable microservices and geo-distributed, fault-tolerant data backend using YugabyteDB. Prior to joining Yugabyte, he spent 11 years at Verizon as Distinguished Member of technical staff and led the development of several software products for monitoring the wireless network KPIs in real time.
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.
- Date:
- 2024 April 17 12:10 PDT
- Duration:
- 50 min
- Room:
- Winchester
- Conference:
- Postgres Conference 2024
- Language:
- English
- Track:
- Dev
- Difficulty:
- Intermediate