Postgres Weekly
Plus Git-style branches for your data, and fixing Postgres's biggest mistakes in pgrust.

#​674 — November 19, 2026

Web Version

Together with  Tiger Data logo

Postgres Weekly

Postgres 19 Released

It might be GTA VI's release day, but we all know the day's true big release… Postgres 19 is here! It's headlined by online table repacking and new ways to keep query plans stable. Some highlights:

  • REPACK reclaims bloat and can reorder a table to match an index, and REPACK (CONCURRENTLY) does it without blocking reads or writes until the final swap. It supersedes VACUUM FULL and CLUSTER (which remain for compatibility).

  • For developers, INSERT ... ON CONFLICT DO SELECT handles 'get or create' in one round trip, COPY can output JSON, and window functions gain IGNORE NULLS.

  • The pg_plan_advice extension lets you experiment with and guide plan choices, and pg_stash_advice applies advice automatically by query ID, so you can fix a slow plan without changing your app.

  • Logical replication can be turned on without a restart, sequences can now be replicated, and WAIT FOR LSN gives read-your-writes consistency on standbys.

And, of course, much, much more, all covered in the release notes.

PostgreSQL Global Development Group

Your Partition Maintenance Shouldn’t Be a Cron Job — Native partitioning means creating and attaching partitions on a schedule. Hypertables create chunks automatically as data arrives, and compression cuts storage by up to 95% on older ones. Same Postgres. Start on Tiger Cloud with a $1000 credit.

Tiger Data (creators of TimescaleDB) sponsor

BEFORE YOU UPGRADE TO POSTGRES 19:

  • Indexes using full text search, pg_trgm or fuzzystrmatch may need a reindex after pg_upgrade. Jeff Davis explains why there's no upgrade check for it.

  • pg_upgrade --check can pass and the upgrade still fail if a role or database stores standard_conforming_strings = off, or you've added your own uuid to bytea cast (now built in).

  • After a pg_restore, run VACUUM ANALYZE. Nikolay saw a query take 32.6s instead of 23ms without it, and the first read after a restore can be costly (on 19, particularly).

  • JIT is now off by default, as its cost estimates proved unreliable. If you run a lot of large analytical queries, you may want to turn it back on. When to JIT? has more detail on this.

⭐ Postgres 18.7, 17.12, 16.16, 15.20, and 14.25 Released — The latest minor releases fix 52 security issues and Postgres 14 goes 'end of life'. Lukas Fittl explains who's exposed (often any logged-in user) and Devrim Gündüz shows why extensions must be updated with the server. See "Updating" for reindexing steps.

PostgreSQL Global Development Group

IN BRIEF:

Fixing Postgres's Biggest Mistakes — Michael follows up his 'four horsemen' of Postgres outages by showing how pgrust, his team's Rust reimplementation, is tackling certain Postgres shortcomings, from storage that needs no VACUUM to a planner that learns from its mistakes.

Michael Malis

How a 22-Year-Old Type Confusion Became RCE — Exploiting an extension on a managed Postgres service led Mehmet into core, where changing a composite type's field and reading the old value back became a reliable way to run code. It's one of many reports behind CVE-2026-6460, fixed in the latest releases (above).

Mehmet Ince

Benchmarking DigitalOcean's New 'Advanced' Managed Postgres — DigitalOcean's launch post teased lower latency and higher throughput, but after 59 hours of benchmarks across 100+ databases, Dimitar found the opposite in his tests.

Dimitar Atanasov

📄 Large Postgres Instances Love Huge Pages – If your shared_buffers runs to tens of GBs, leaving huge pages unconfigured can cost you 10-20% throughput… Kaarel Moppel

📄 Ten Ways a glibc Change Can Break Your Postgres Cluster – B-tree indexes are just the start, with a way to detect each failure. Pablo Svampa (Percona)

📄 How One Pooler Setting Cut a Postgres Server's Memory Use – A quick PgBouncer tip. Dinesh Kumar

📄 How a Broken Release Name Overloaded Sentry's Postgres Database Michael Warkentin (Sentry)

📰 Classifieds

🧾 Invoices arriving as PDFs? Foxit’s API pulls line items, totals, dates and vendors into JSON, ready to load straight into Postgres.

RELEASES AND CODE:

pgrx 0.20: Build Postgres Extensions in Rust — "A big one" for the framework for building extensions with Rust, which now generates bindings for Postgres's C macros and inline functions automatically, and is Postgres 19 ready.

PgCentral Foundation

💡 pgrx is now a pretty popular way to build extensions, with ParadeDB's pg_search, Supabase's pg_graphql, Tiger Data's pgvectorscale and PostgresML all built on it.

Gnomon: Git-Style Branching/Merging for Postgres Data — An extension that brings branches, diffs, merges and undo to data in Postgres, with branches accessible behind different connection strings. New and experimental, and reminds me of the established Postgres-compatible (but not Postgres) Doltgres.

bitsinfra

  • PgDog 0.1.65 – Rust-powered pooler and sharding proxy. Adds cross-shard CTEs and HAVING, and fixes wrong results from some cross-shard GROUP BY queries.

  • Atlas 1.4 – The schema-as-code tool adds atlas security scan to report CVEs affecting your database servers and extensions.

  • Postbird 0.9 – A long-dormant open source Postgres GUI returns, rewritten on Electrobun.

  • pgAudit 19.0 – The audit logging extension is ready for Postgres 19.

Issue 673 #674