Postgres 19 RC 2 Lands as Postgres 14 Goes End of Life
PostgreSQL 19 RC 2 shipped alongside the November minors, and 14.25 is the last Postgres 14 release ever. Here are the post-update steps teams skip.
Expert PostgreSQL tutorials, tips, and performance optimization guides. Learn database administration, query optimization, and best practices for PostgreSQL 18 and beyond.
PostgreSQL on this site is the main hub for everything related to designing, running, and improving modern Postgres databases. It brings together practical guidance on performance tuning, real‑world architecture patterns, learning resources, and hands‑on examples so developers and DBAs can get more out of PostgreSQL in production. From book recommendations and beginner tutorials to deep dives into scaling, extensions, and advanced features, this category is where readers go to level up every aspect of their Postgres stack.
PostgreSQL 19 RC 2 shipped alongside the November minors, and 14.25 is the last Postgres 14 release ever. Here are the post-update steps teams skip.
PostgreSQL 18.7’s CVE-2026-6460 fix changes the interface between the server and compiled extensions. How to inventory, patch and reindex without breaking the database.
Replication slots retain WAL unconditionally. Size max_slot_wal_keep_size from peak WAL rate, alert on wal_status, and cap retention before the primary fills.
A step-by-step walkthrough for building an anonymized Postgres test copy: extract a tenant slice, restore it, pseudonymize values deterministically with hmac, and verify foreign keys before anyone connects.
Benchmark PgBouncer against application-side pools at the same client count, size pools from server cores, and know what transaction pooling breaks.
PostgreSQL 14.24 ships on November 12, 2026 as the branch’s final release. What end of life means, which versions to land on, and the pre-flight checks that catch most failed pg_upgrade runs.
EnterpriseDB announced on November 5 that it has acquired Altinity, the main independent provider of enterprise support and managed services for ClickHouse, with integrated enterprise ClickHouse capabilities promised for Q4 2026. You can read the vendor claims yourself in the EDB press release. For a Postgres DBA the M&A is background noise. The useful signal […]
A five-step audit of a handover Postgres cluster: dump every non-default setting from pg_settings, split reload-safe from restart-required, diff two clusters, then converge with ALTER SYSTEM instead of hand-editing the file.
Every few months a team pings me with the same story: insert throughput on one table quietly collapsed. Same hardware, same queries, the only thing that changed is row count. Nine times out of ten the table has a uuid primary key defaulting to gen_random_uuid(), and the index has turned into a pile of half-filled […]
The CNCF moved CloudNativePG to Incubating on 2 November 2026. What the review certified, the governance changes that follow, and what it does not mean.