Connection Pool Sizing: The Math That Says Fewer, Not More
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
Tag: Databases
Beyond OFFSET: Keyset Pagination in PostgreSQL That Actually Scales
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
Zero-Downtime PostgreSQL Migrations: Locks, Rewrites, and Expand-and-Contract
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
PgBouncer 1.26.0: Pre-Auth CVEs, the search_path Fix, and What Changes for Pool Sizing
PgBouncer has quietly become mandatory infrastructure for PostgreSQL at scale. If you run more than a few hundred client connections
HyperLogLog: Counting a Billion Uniques in 1.5 KB of Memory
Every analytics dashboard has one question that looks trivial and isn’t: how many unique users did this? You can run
Continue readingHyperLogLog: Counting a Billion Uniques in 1.5 KB of Memory
API Pagination Strategies: Offset, Cursor, and Relay Connections Done Right
Sooner or later, every API designer hits the pagination wall. The endpoint works fine in staging, then production traffic arrives
Continue readingAPI Pagination Strategies: Offset, Cursor, and Relay Connections Done Right
Zero-Downtime Schema Migrations in PostgreSQL: Expand-Contract, Lock Timeouts, and Safe ALTER TABLE
PostgreSQL takes an ACCESS EXCLUSIVE lock for most ALTER TABLE operations. That lock conflicts with everything — reads, writes, even
PostgreSQL Connection Pooling: Session vs Transaction Mode, PgBouncer, and How to Size It
Every PostgreSQL backend process is a full Unix process with its own megabytes of memory. That design choice buys you
MVCC and VACUUM in PostgreSQL: Dead Tuples, Autovacuum Tuning, and What PG18 Changed
Every UPDATE in PostgreSQL is secretly an INSERT-plus-a-tombstone. The old row version stays on disk, fully readable to any transaction
Continue readingMVCC and VACUUM in PostgreSQL: Dead Tuples, Autovacuum Tuning, and What PG18 Changed
Cursor-Based Pagination Done Right: Keyset Queries, Opaque Cursors, and the Pitfalls That Bite
Every API that returns a list eventually has to answer the same question: how do you hand out a million