Query Optimization Workshop: Practical Examples, Methods and Tools
Presented by:
Franck Pachot
Developer Advocate for YugabyteDB, distributed SQL database using PostgreSQL for the query layer. Franck has a passion for learning and sharing in blog posts (blog.pachot.net), articles, conferences and tech communities (AWS Data Hero and Oracle ACE Director)
Gaurav Kukreja
Software Engineer at YugabyteDB working on the Query Optimizer. I have a passion for tackling performance critical challenges.
No video of the event yet, sorry!
In this workshop, we will explore SQL query optimization specifically for PostgreSQL. Participants will learn to interpret execution plans and understand how different SQL writing styles can affect query planner optimizations. In addition to core PostgreSQL features, the session will cover external tools for plan visualization and the pg_hint_plan extension for exploring alternative execution paths. We will also discuss some PostgreSQL-compatible databases, such as AWS Aurora, with its plan management features and distributed solutions like sharding and YugabyteDB. The insights on the work done in YugabyteDB for PostgreSQL performance parity aim to provide a deeper understanding of query planning and the challenges of cost-based optimization in general.
- Date:
- Duration:
- 3 h 30 min
- Room:
- Conference:
- PGConf India, 2025
- Language:
- Track:
- Training
- Difficulty: