pg_hint_plan - get the right plan without surprises

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)

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

Happening at the same time:

  1. Full Text Search: Capabilities of PostgreSQL and a Comparison with Elasticsearch Using Wikipedia Dataset
    2. Start Time:
    2023 February 23 10:45

    Room:
    Grand Victoria 1

  2. Partition elimination in PostgreSQL and Greenplum
    3. Start Time:
    2023 February 23 10:45

    Room:
    Robusta + Arabica