In this episode of Scaling Postgres, we cover a deep dive into indexes from a presentation that includes a decision tree of sorts, how to convert to partitioned tables once you have hundreds of millions of rows and detail about the new pg_stat_io view.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/285-indexing-deep-dive/
