Partial indexes are underrated
A 40 GB table, a query that only ever looks at 4,000 rows of it, and an index that went from 1.9 GB to 38 MB.
2 posts
A 40 GB table, a query that only ever looks at 4,000 rows of it, and an index that went from 1.9 GB to 38 MB.
Three numbers I look at first, and the one I used to look at and now ignore.