A slow query arrives. Someone runs EXPLAIN ANALYZE, pastes the output into a search engine, and a verdict comes back:
Continue readingReading EXPLAIN ANALYZE Like a Planner: A PostgreSQL Field Guide
Every Go service that talks to PostgreSQL ends up managing a pool of database connections, and almost every team gets
Ask a PostgreSQL database administrator what kills databases in production and you’ll hear about wraparound — the event where a
Every Tokio application eventually meets the same mystery: a task that looks harmless in code review brings an entire runtime
Every Mac owner who has run a local LLM knows the feeling: the model downloads fine, the first answer looks
Every high-concurrency server you have ever deployed eventually bottoms out at the same place: a call that says “tell me
Every Go program you have ever shipped is a swarm of goroutines multiplexed onto a handful of operating system threads.
Continue readingInside the Go Scheduler: G, M, P, Work Stealing, and Why Goroutines Block Cheaply
Every team seems to arrive at the same configuration at some point: the database feels slow, someone searches for a
Continue readingConnection Pool Sizing: The Math That Says Fewer, Not More
Ask someone to sketch a transformer on a whiteboard and they’ll draw the 2017 version: softmax attention over every pair
Continue readingMHA, MQA, GQA, MLA: The KV-Cache Trade-offs Behind Every Modern Transformer
# POST 2: Reading EXPLAIN A query that ran in 20 milliseconds yesterday takes 40 seconds today. Nothing in the
Continue readingReading EXPLAIN Like a Planner: Debugging Slow Queries in PostgreSQL