Skip to main content

PostgreSQL

Browse all articles, tutorials, and guides about PostgreSQL

11posts

Guides

Posts

FinOps
|10 min read

RDS MySQL 8.0 Has Been Billing Extended Support Since August: Find It and Price It

RDS MySQL 8.0 passed standard support on July 31, 2026. Inventory every enrolled database, find the charge in billing data, and decide whether an 8.4 upgrade costs less than another year of support.

DevOps
|15 min read

Postgres 19 Slipped to November: Every Pulled Feature and Why

PostgreSQL 19 now ships on 19 November, and 15 items left its release notes after beta 1. Here is each pulled feature with the reason from its revert, what to use instead, a script that finds beta-era code that depends on them, and why "AI found too many bugs" is only part of the story.

DevOps
|15 min read

In-App, Email and Push From One Event

An order ships. The user wants a badge in the app, a digest email later, no push at all, and their own webhook endpoint pinged. The design that handles that without duplicates: an outbox keyed by event, user and channel, preferences evaluated at send time, digest windows, and provider feedback wired back in. With a runnable model and a build-or-buy verdict.

DevOps
|17 min read

How Stripe Avoids Double-Charging Anyone

A payment request times out. Did the charge happen? Stripe answers that question with idempotency keys, and the design behind them is more than a cache of responses: locked key rows, recovery points, and a rule about which calls can be retried. Here is the design, a working Postgres implementation, the run where our own version double-created rides, and the constraint that caught it.

Docker
|9 min read

Stop Compiling Postgres Extensions in Your Dockerfile: How pglayers Works

Adding pgvector or PostGIS to a Postgres image usually means apt-get, build tools, and a fat, slow image. pglayers ships each extension as a scratch Docker layer you COPY in. Here is how it works and when to use it.

DevOps
|9 min read

PostgreSQL 18.2 Broke Standbys: The 18.x Upgrade Footguns

PostgreSQL 18.2 shipped regressions bad enough to force an out-of-cycle 18.3: halted standbys, substring crashes, and a pg_trgm segfault. Here is what went wrong and the quieter Postgres 18 upgrade traps to check before you patch.

DevOps
|10 min read

Stop Paginating With OFFSET: Keyset Pagination and the Deep-Page Cliff

LIMIT/OFFSET is the reflexive way to paginate, and it is fine on page one. But OFFSET makes the database generate and throw away every row before the page you want, so cost grows with page depth until deep pages fall off a cliff. Keyset pagination makes every page the same speed regardless of depth. Here is why OFFSET is slow, the fix, and the one tradeoff.

DevOps
|10 min read

Stop Using Random UUIDs as Primary Keys: uuidv7() Lands in PostgreSQL 18

Random UUIDv4 primary keys quietly wreck insert speed and bloat indexes on large tables. PostgreSQL 18 ships a native time-ordered uuidv7() that keeps the upsides of UUIDs without the B-tree penalty. Here are the numbers and how to adopt it.

DevOps
|13 min read

Zero-Downtime Database Migrations for PostgreSQL in Production

A single ALTER TABLE can take down a busy PostgreSQL database for minutes. This post shows why that happens and how to ship schema changes safely with lock timeouts, the expand-and-contract pattern, and copy-paste SQL recipes for indexes, columns, constraints, and type changes.

Docker
|14 min read

How to Keep Docker Data When a Container Exits: Volumes and Bind Mounts

Data in a container goes away with the container. Learn when that happens, how named volumes and bind mounts keep data, how to add a volume to an existing container, where database images keep their files, and how to back up and remove volumes safely.