pg_hint_plan - get the right plan without surprises
Presented by:
Franck Pachot
Franck is a Developer Advocate at MongoDB. He has extensive experience in database consulting for development and operations teams and is passionate about improving the developer experience, data modeling, and performance troubleshooting. Franck holds several certifications, including Oracle Certified Master and MongoDB Certified Associate Data Modeler, and is a recognized expert in PostgreSQL and YugabyteDB. Amazon acknowledges him as an AWS Data Hero.
Checkout the slides
I use pg_hint_plan to learn about the optimizer, to understand the query planner choices, and, sometimes work around 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
- Date:
- 2023 February 23 - 10:45
- Duration:
- 45 min
- Room:
- Grand Victoria 2
- Conference:
- PGConf India, 2023
- Language:
- Track:
- Application Developer
- Difficulty:
- Medium
- Full Text Search: Capabilities of PostgreSQL and a Comparison with Elasticsearch Using Wikipedia Dataset
- Start Time:
- 2023 February 23 10:45
- Room:
- Grand Victoria 1
- Partition elimination in PostgreSQL and Greenplum
- Start Time:
- 2023 February 23 10:45
- Room:
- Robusta + Arabica