Simon Eskildsen personal blog
Index Merges vs. Composite Indexes in Postgres and MySQL
Composite indexes aka multi-column indexes are about 10x faster than index merges. In Postgres, the gap is larger than in MySQL because Postgres doesn’t support index-only scans for queries that involve index merges.
- Points
- 175
- HN comments
- 38
- Submissions
- 1
- Cited by
- 0 commenters
Databases & DataSoftware Engineering2022
On Hacker News
| Submitted | Title on HN | Points | Comments |
|---|---|---|---|
| Nov 27, 2022 | Index Merges vs. Composite Indexes in Postgres and MySQL by Sirupsen | 175 | 38 |
