# Ada Brennan

> Notes on databases, query planners and the occasional dovetail joint.

- [Partial indexes are underrated](https://personal-example.notra.site/blog/partial-indexes.md): 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. (2026-10-08)
- [A workbench from construction lumber](https://personal-example.notra.site/blog/workbench-from-construction-lumber.md): Two weekends, twelve 2×4s and one mistake with the vise I'd make again. (2026-09-21)
- [How I read EXPLAIN ANALYZE](https://personal-example.notra.site/blog/reading-explain-analyze.md): Three numbers I look at first, and the one I used to look at and now ignore. (2026-09-09)
- [Sharpening without buying a system](https://personal-example.notra.site/blog/sharpening-without-a-system.md): One diamond plate, one strop and a cheap honing guide. That's the whole kit. (2026-08-24)
- [The boring database choices I keep making](https://personal-example.notra.site/blog/boring-database-choices.md): Postgres, one primary, UUIDv7 keys and migrations that only ever add things. (2026-08-06)
