Finding index bloat in Postgres without extensions
A query that hit 40 seconds dropped back to 300 ms after a reindex, which made me finally sit down and learn how to measure bloat instead of guessing.
Three Makefile patterns I use in every project
Self-documenting targets, order-only prerequisites for build directories, and why .DELETE_ON_ERROR should be the first line of any Makefile you write.
journalctl recipes I always forget
Counting events per hour, following one unit across a restart, and getting output that pipes into awk cleanly.