Postgres FM
Multi-column indexes
41:21
Nik and Michael discuss multi-column indexes in Postgres — what they are, how to think about them, and some guidance around using them effectively. Here are some links to things they mentioned:
Multicolumn Indexes (docs) https://www.postgresql.org/docs/current/indexes-multicolumn.html
Our episode on Index-only scans https://postgres.fm/episodes/index-only-scans
Combining Multiple Indexes…