The migration that works on staging and melts down production usually dies in the lock queue. Someone runs an ALTER
Continue readingZero-Downtime Schema Migrations: Expand-Contract on PostgreSQL, Step by Step
Every database you use is a B-tree or an LSM tree underneath. PostgreSQL and MySQL’s InnoDB are B-trees. RocksDB, Cassandra,
Continue readingB-Trees vs LSM Trees: The Storage Engine Trade-Off Behind Every Database
Almost every API starts its pagination life with LIMIT 20 OFFSET 40. It’s the pattern every ORM hands you, it
Continue readingPagination That Doesn’t Fall Apart at Page 50,000: Keyset Cursors Done Right
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
Here is one of the oldest bugs in distributed systems, still shipping to production every week: a service commits a
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 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
Offset pagination is the first thing everyone learns and the first thing that falls over in production. The product manager
Continue readingBeyond OFFSET: Keyset Pagination in PostgreSQL That Actually Scales
Every schema migration is easy the first time, when the table is empty and the only user is your test
Continue readingZero-Downtime PostgreSQL Migrations: Locks, Rewrites, and Expand-and-Contract