How to reason about Indexing your Postgres database - Webinar Cover Image

Webinar: How To Reason About Indexing Your Postgres Database

See how Postgres chooses which index to use, and learn a methodology for analyzing queries & optimizing indexes.

Lukas Fittl
Lukas Fittl
Founder & CEO, pganalyze

Learn about

  • How Postgres chooses which index to use
  • Background about indexing
    • How Index Scans are made
    • The cost model and how the planner uses it
    • Index cardinality and selectivity
    • Nested Loops and how they affect index usage
  • What is a “good enough” index?
  • A structured approach for finding the right indexes
    • Break queries into scans
    • Turn scans into potential index parameters
    • Estimate the index write overhead and index size
    • Analyze impact across multiple queries
    • Thinking of indexing as a set covering problem
    • Choose the best indexes to cover queries
  • A look behind the scenes: The pganalyze Indexing Engine

Watch the Webinar Recording

Hundreds Of Companies Monitor Their Production PostgreSQL Databases With pganalyze