#674 — November 19, 2026 |
|
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:
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:
|
|
⭐ 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 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 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 📄 Ten Ways a 📄 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) |
|
|
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 |
|
|
Got a new email? You can change your address here. Bored of us? Click here to stop getting Postgres Weekly. Got a link for us? Reply and tell us. We can't include everything but we'll look at anything you send. Thanks! Published by Cooper Press Ltd. Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada. |

