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.
Notes on databases, query planners and the occasional dovetail joint.
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.
Two weekends, twelve 2×4s and one mistake with the vise I'd make again.
Three numbers I look at first, and the one I used to look at and now ignore.
One diamond plate, one strop and a cheap honing guide. That's the whole kit.
Postgres, one primary, UUIDv7 keys and migrations that only ever add things.