October 26, 2026
Use PostgreSQL 19 RC 1 to rehearse compatibility
I explain how to use PostgreSQL 19 RC 1 to test application integrations and upgrade procedures without treating an RC as a production commitment.
Read article
Posts tagged “postgresql”.
One tag at a time. The full list is on the articles page.
October 19, 2026
Time-zone updates change application behavior
I explain why PostgreSQL time-zone data belongs in application change management and how to test future appointments across database and application updates.
Read article
October 19, 2026
PostgreSQL 19 WAIT makes read-your-writes a contract
I explain when waiting for a PostgreSQL replica beats routing reads to the primary, and how to test the latency, timeout, and fallback behavior.
Read article
October 19, 2026
PostgreSQL 19 parallel autovacuum is a resource-budget decision
I explain how to assess PostgreSQL 19 parallel autovacuum against foreground CPU and I/O demand, and how to test limits and monitoring before enabling it.
Read article
October 19, 2026
Keep roadmap commitments independent of PostgreSQL 19’s release date
I explain how to evaluate PostgreSQL 19 features without making a delivery plan depend on an unsettled release or feature set.
Read article
October 13, 2026
A replication-slot status metric is not proof of replication health
I explain what Azure’s logical replication slot sync status can tell you, what it cannot prove, and which signals I would pair with it.
Read article
October 13, 2026
PostgreSQL’s concurrent REPACK moves the maintenance risk
PostgreSQL 19’s concurrent REPACK can reduce reliance on maintenance windows, but it shifts the risks to write load, storage, replicas and recovery.
Read article
October 13, 2026
PostgreSQL 14’s end of life is a compatibility-planning problem
PostgreSQL 14 reaches end of life on November 12, 2026; I explain how to map compatibility checks and sequence migration work around each workload.
Read article
October 8, 2026
A connection-count metric is not a pool health check
A database connection count shows how many clients are present, not whether an application pool is saturated, queuing work or holding connections idle.
Read article
October 4, 2026
Compute-storage separation does not remove lock-in
Azure HorizonDB shows why PostgreSQL portability depends on operational boundaries and exit paths, not just SQL compatibility.
Read article
October 2, 2026
Test your workload before redesigning for PostgreSQL 19
A disciplined way to test PostgreSQL 19 Beta 4 against real read and write patterns before deciding whether its behavior warrants a data-model change.
Read article