Presented by:

43e7696a35a5a4451a9a2ad8fe270fe6

Robert Haas

from EnterpriseDB

Robert Haas is a PostgreSQL major contributor and committer. PostgreSQL features which he has authored or coauthored include unlogged tables, fast-path locking, index-only scans, and parallel query. PostgreSQL features written by others which he has reviewed and committed include partitioning, logical decoding, event triggers, and foreign tables. He works at EnterpriseDB as VP, Chief Database Architect.

No video of the event yet, sorry!

Download slides

Sequential scan vs. index scan vs. bitmap index scan vs. index-only scan. Join strategies. Join reordering. Using EXPLAIN. Row count and cost estimation. Things the query planner doesn't understand. Things that are nearly always slow. What's new in query planning in recent PostgreSQL releases? Upcoming features and future work.

Date:
2019 February 14 - 14:00
Duration:
45 min
Room:
Ballroom 3
Conference:
PGConf India, 2019
Language:
Track:
Database Engine Developer
Difficulty:
Intermediate

Happening at the same time:

  1. Database Operations at Groupon using Ansible
  2. Start Time:
    2019 February 14 14:00

    Room:
    Ballroom 4

  3. Massively Parallel Postgres Database on Kubernetes
  4. Start Time:
    2019 February 14 14:00

    Room:
    Ballroom 1