Presented by:

2b60c925f64f0d73bf3f1c99ed8b4b84

Franck Pachot

from MongoDB

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.

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:
2025 March 5 - 14:00
Duration:
3 h 30 min
Room:
Grand Ballroom 1
Conference:
PGConf India, 2025
Language:
Track:
Training
Difficulty:

Happening at the same time:

  1. PostgreSQL PL/pgSQL Development Deep Dive
  2. Start Time:
    2025 March 5 14:00

    Room:
    Neptune

  3. Pgvector - from Prototype to Production
  4. Start Time:
    2025 March 5 14:00

    Room:
    Grand Ballroom 2

  5. Introduction to PostgreSQL in Kubernetes with CloudNativePG
  6. Start Time:
    2025 March 5 14:00

    Room:
    Jupiter