PostgreSQL
Postgres logical replication beyond one writer
In 2014, if you wanted Postgres servers on several continents, each of them accepting writes and all of them sharing their rows, there was one serious open source answer: …
Getting more out of PostgreSQL
Notes on SQL technique, data modeling, and PostgreSQL internals — from the author of The Art of PostgreSQL. New articles are built on the free Lab so you can run every query yourself.
PostgreSQL
Zero-downtime Postgres upgrades with logical replication
This is part 3 of a series about Postgres logical replication use-cases, and about how the feature set has evolved over the past ten years and ten releases (Postgres 10 …
PostgreSQL
Consolidating databases with Postgres logical replication
This is part 2 of a series about Postgres logical replication use-cases, and about how the feature set has evolved over the past ten years and ten releases, one …
PostgreSQL
Ten years of Postgres logical replication
A long time ago I ran a write-heavy system on a hub and a handful of workers. Each worker took a share of the application traffic and wrote events locally. The hub owned …
PostgreSQL
Plan Advice in PostgreSQL 19
There is a conversation that happens in every PostgreSQL shop eventually. A query that has been fine for a year gets slow overnight. Nothing was deployed. The data grew a …
PostgreSQL
Getting Ready for PostgreSQL 19
PostgreSQL 19 Beta 3 shipped on August 13, 2026, and the release notes have been filled in as of 2026-07-18 — still marked subject to change, and the GA date isn’t …
PostgreSQL
Introducing YeSQL: Practical PostgreSQL, One Concept at a Time
I’m happy to share something new: YeSQL is live, a free set of 24 short PostgreSQL lessons — one concept, one runnable query, real data, no signup. It’s free …
PostgreSQL
Introducing sqlfmt: an SQL gofmt-style formatter
Formatting SQL tends to bring some of the same questions again and again: should we uppercase clause keywords? should we put the separating comma at the start of a line …
PostgreSQL
SQL Improvements in PostgreSQL 11–18: A Personal Selection
Seven major versions of PostgreSQL shipped between 2018 and 2025, one per year without exception, and each with a changelog of 150 to 200 user-visible changes. Each …
PostgreSQL
pgcopydb v0.18
Hot off the press: pgcopydb v0.18 is out! It’s the biggest release the project has had — 88 commits since v0.17, which shipped in August 2024. I took a break from …
PostgreSQL
Postgres HA: roles are dynamic
High-Availability comes with some impact on your architecture choices, in particular when applied to RDBMS such as Postgres. One such impact is the idea of a failover. …
PostgreSQL
An introduction to the pg_auto_failover project
We just released pg_auto_failover version 1.6.3 on GitHub, and the binary packages should be already available at the usual PGDG and CitusData places, both for debian …