Query Optimization Workshop: Practical Examples, Methods and Tools
Presented by:
Franck Pachot
Franck is a Developer Advocate at MongoDB, formerly at YugabyteDB (distributed PostgreSQL). With a long experience in database consulting for development and operations teams and a passion for enhancing developer experience, data modeling, and performance troubleshooting, Franck holds several certifications, including Oracle Certified Master and MongoDB Certified Associate Data Modeler, and he is recognized as an AWS Data Hero.
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:
- 2025 March 5 - 14:00
- Duration:
- 3 h 30 min
- Room:
- Grand Ballroom 1
- Conference:
- PGConf India, 2025
- Language:
- Track:
- Training
- Difficulty:
- PostgreSQL PL/pgSQL Development Deep Dive
- Start Time:
- 2025 March 5 14:00
- Room:
- Neptune
- Pgvector - from Prototype to Production
- Start Time:
- 2025 March 5 14:00
- Room:
- Grand Ballroom 2
- Introduction to PostgreSQL in Kubernetes with CloudNativePG
- Start Time:
- 2025 March 5 14:00
- Room:
- Jupiter