Presented by:

2b60c925f64f0d73bf3f1c99ed8b4b84

Franck Pachot

from Yugabyte

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)

666eb8c8bb4b28ac9d8ca5ce53f10b61

Gaurav Kukreja

from Yugabyte

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: