#Postgresql

Zero-Downtime Postgres Migrations with Logical Replication

Replicate a live Postgres 16 database into a schema-changed Postgres 18 instance and cut over in seconds.

Tutorial · 1w ago3

The Outbox Pattern's Hard Parts Start After the Commit

Three production incidents show the atomic write is the easy 10% — the relay policy is the job.

Article · 1w ago2

Postgres's 2-Billion-Transaction Time Bomb Is Still Ticking

Wraparound took down Sentry and Mandrill, yet 64-bit XIDs remain stuck outside core Postgres.

Article · 1w ago2

Your URLs Are Filenames Now

One dirty database field took down a static build, exposing a limit every file-per-route generator inherits.

Article · 1w ago0

Zero-Downtime Postgres Major-Version Upgrades with Logical Replication

Stream a live Postgres 16 database to 18 and cut over in seconds, not hours.

Tutorial · 1w ago0

Run a Stateful App on Kubernetes with StatefulSets and PVCs

Move PostgreSQL onto Kubernetes with StatefulSets, persistent volumes, and a headless service - no data loss on restarts.

Tutorial · 2w ago0

Go Multi-Region on Postgres with AWS Aurora Global Database

Build a two-region Aurora PostgreSQL global database and switch primary regions with zero data loss.

Tutorial · 3w ago0

Your Web App Is Too Professional to Self-Host

Production-grade architecture becomes a support-ticket generator the moment strangers run your code on their own boxes.

Article · 3w ago1

Every MVCC Engine Fails. Postgres Just Fails Out Loud

The garbage bill for concurrent reads and writes is conserved — each database only chooses who pays, when, and how it breaks.

Article · 1mo ago0

PostgreSQL Internals as a City You Can Walk Through

A Postgres expert vibe-coded a 3D engine simulator in a weekend, and it teaches the lessons outages usually do.

Article · 1mo ago4

Scaling PgBouncer Beyond the Single-Threaded Limit

How to run a multi-process PgBouncer fleet using SO_REUSEPORT and peering without breaking query cancellations.

Article · 1mo ago0

Rethinking the Postgres Connection Pooler

Modern proxies are moving beyond simple socket multiplexing to fix the leaky abstractions of transaction-mode pooling.

Article · 1mo ago0

The Postgres Swiss Army Knife Is Not a Free Lunch

Before consolidating your entire stack onto a single database, understand the operational limits of the Postgres is enough philosophy.

Article · 1mo ago2

Stop the Linux OOM Killer From Wrecking Your PostgreSQL Database

Taming the Linux virtual memory manager with strict overcommit is the only way to prevent silent database crashes.

Article · 1mo ago2

Postgres Transactions Are a Distributed Systems Superpower

Co-locating workflow state with application data collapses distributed systems complexity into standard ACID transactions.

Article · 1mo ago6