Short form
Notes
Quick takes, tips, and things I want to remember.
Postgres 19 is coming this fall. It's time to clear your cache so you can get ready to download and test it out.
PostgreSQL 19 beta 1 is out. Read the release announcement and start planning your upgrade tests.
Read article\watch is underrated
Type any query in psql, then `\watch 2` and you have a live dashboard. No tooling, no dependencies, just a terminal and a query you already wrote.
Always pass BUFFERS to EXPLAIN ANALYZE
`EXPLAIN (ANALYZE, BUFFERS) ...` tells you whether your query is CPU bound or hammering the cache. Without BUFFERS you are flying half-blind.
The PostgreSQL Field Guide is out
After a year of evenings and weekends, my first book is out. It is the reference I wished I had when I started — short, opinionated, and unapologetically practical.