3 posts
systemsnew
Reading Postgres EXPLAIN (ANALYZE, BUFFERS)
Seq scans aren't always evil — learn what the planner is actually telling you.
postgresperformance
Jul 20262 min
systems
What SKIP LOCKED actually does
A Postgres-native job queue in 30 lines, and why it doesn't block.
postgressystems
Jun 20262 min
systems
Postgres connection pooling pitfalls
Prepared statements, transaction pooling, and the errors that only show under load.
postgressystems
Apr 20262 min