---
title: "Postgres 19 is here (GTA VI can wait)"
publication: "Postgres Weekly"
issue: 674
published_at: "2026-11-19"
canonical_url: "https://postgresweekly.com/issues/674"
---

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

#​674 — November 19, 2026 

[Web Version](https://postgresweekly.com/issues/674)  

Together with [![Tiger Data logo\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,w_1280,h_282/e_make_transparent/co_white,e_outline:30/px1u7kjyvz7xnbm6ytir.png)](https://www.tigerdata.com/go/trial?utm_source=content-syndication&utm_medium=referral&utm_campaign=postgres-weekly-newsletter&utm_content=exclusive-partitions-1118)   

Postgres Weekly 

[![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/wvk9yfa9brpepedo3stv.jpg)](https://www.postgresql.org/about/news/postgresql-19-released-3449/)  

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](https://www.postgresql.org/about/news/postgresql-19-released-3449/)! It's headlined by online table repacking and new ways to keep query plans stable. Some highlights: 

- [`REPACK`](https://www.postgresql.org/docs/19/sql-repack.html) 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`](https://www.postgresql.org/docs/19/sql-insert.html#SQL-ON-CONFLICT) handles 'get or create' in one round trip, `COPY` can output JSON, and window functions gain `IGNORE NULLS`.
- The [`pg_plan_advice`](https://www.postgresql.org/docs/19/pgplanadvice.html) extension lets you experiment with and guide plan choices, and [`pg_stash_advice`](https://www.postgresql.org/docs/19/pgstashadvice.html) 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](https://www.postgresql.org/docs/19/logical-replication-sequences.html), and [`WAIT FOR LSN`](https://www.postgresql.org/docs/19/sql-wait.html) gives read-your-writes consistency on standbys. 

And, of course, [much, much more](https://www.postgresql.org/docs/19/release-19.html), all covered in the release notes. 

PostgreSQL Global Development Group    [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/48f775ba.png)](https://www.tigerdata.com/go/trial?utm_source=content-syndication&utm_medium=referral&utm_campaign=postgres-weekly-newsletter&utm_content=exclusive-partitions-1118) 

[Your Partition Maintenance Shouldn’t Be a Cron Job](https://www.tigerdata.com/go/trial?utm_source=content-syndication&utm_medium=referral&utm_campaign=postgres-weekly-newsletter&utm_content=exclusive-partitions-1118) — 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](https://www.tigerdata.com/go/trial?utm_source=content-syndication&utm_medium=referral&utm_campaign=postgres-weekly-newsletter&utm_content=exclusive-partitions-1118). 

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`](https://www.postgresql.org/message-id/flat/CAGRkXqRWpqmoCBffoLViAVAK2-_hYE_z1SW%3DFfejPidT6wPgdA%40mail.gmail.com). Jeff Davis explains why there's no upgrade check for it.
- `pg_upgrade --check` [can pass and the upgrade still fail](https://www.postgresql.org/message-id/flat/CAD21AoCwNAtMZuK_x78V57S+Cc8j2nCWStipYQVmBXrFtXCsCw@mail.gmail.com) 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`](https://postgres.ai/blog/20261028-dump-restore-now-what). 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](https://www.postgresql.org/docs/19/jit.html), 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?](https://www.postgresql.org/docs/19/jit-decision.html) has more detail on this.   

⭐ [Postgres 18.7, 17.12, 16.16, 15.20, and 14.25 Released](https://www.postgresql.org/about/news/postgresql-187-1712-1616-1520-1425-and-19-rc-2-released-3442/) — The latest minor releases fix 52 security issues and Postgres 14 goes 'end of life'. [Lukas Fittl explains who's exposed](https://pganalyze.com/blog/5mins-postgres-18-7-security-release-cve-2026-6460) (often any logged-in user) and Devrim Gündüz [shows why extensions must be updated with the server](https://people.planetpostgresql.org/devrim/index.php?/archives/138-PostgreSQL-November-2026-minor-releases-update-the-server-and-extensions-together.html). See _"Updating"_ for reindexing steps. 

PostgreSQL Global Development Group   

**IN BRIEF:** 

- The AI-generated bug reports are still flooding in. Christophe Pettus asks people to [stop sending unchecked ones](https://thebuild.com/blog/stop-using-ai-to-report-postgresql-bugs/), and depesz [charts the effect on the lists](https://www.depesz.com/2026/11/09/what-llms-do-to-postgresql-and-dbas/).
- 🎂 Happy 20th birthday to [osm2pgsql](https://osm2pgsql.org/news/2026/11/17/happy-birthday.html), the tool that loads OpenStreetMap data into Postgres and powers many major OSM maps.
- 🇺🇸 [PG DATA 2027](https://2027.pg-data.org/) takes place June 11–12 in Chicago. The [CFP is open](https://sessionize.com/pg-data-2027/).
- Microsoft's [Azure HorizonDB is now generally available](https://techcommunity.microsoft.com/blog/adforpostgresql/horizondb-postgresql-for-enterprises-developers-and-agents-on-azure-and-fabric/4573498).   

[Fixing Postgres's Biggest Mistakes](https://malisper.me/fixing-postgress-biggest-mistakes/) — Michael follows up his ['four horsemen' of Postgres outages](https://malisper.me/the-four-horsemen-behind-thousands-of-postgres-outages/) by showing how [pgrust](https://pgrust.com/), 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](https://mehmetince.net/part-3-6-how-i-ended-up-turning-a-22-year-old-postgresql-type-confusion-primitive-into-rce-cve-2026-6460/) — 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](https://smokentar.com/blog/digitalocean-postgres-benchmark/) — DigitalOcean's [launch post](https://www.digitalocean.com/blog/introducing-mysql-postgresql-advanced) 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](https://kmoppel.github.io/2026-11-18-reminder-large-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](https://www.percona.com/blog/ten-ways-a-glibc-change-can-break-your-postgresql-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](https://cortexridge.com/blog/reduce-postgresql-memory-usage-cloud-bill/) – A quick PgBouncer tip. Dinesh Kumar 

📄 [How a Broken Release Name Overloaded Sentry's Postgres Database](https://blog.sentry.io/broken-release-database-load/) Michael Warkentin (Sentry)       

📰 Classifieds   

🧾 Invoices arriving as PDFs? [Foxit’s API](https://developer-api.foxit.com/developer-blogs/api-guides-tutorials/invoice-parsing-pdf-to-structured-json/?utm_source=draftdev&utm_medium=newsletter&utm_campaign=postgresweekly_20261118) 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](https://github.com/pgcentralfoundation/pgrx/releases/tag/v0.20.0) — _"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](https://github.com/paradedb/paradedb), Supabase's [pg_graphql](https://github.com/supabase/pg_graphql), Tiger Data's [pgvectorscale](https://github.com/timescale/pgvectorscale) and [PostgresML](https://github.com/postgresml/postgresml) all built on it.  

[Gnomon: Git-Style Branching/Merging for Postgres Data](https://gnomon.bitsinfra.com/) — 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](https://www.doltgres.com/). 

bitsinfra   

- [PgDog 0.1.65](https://github.com/pgdogdev/pgdog/releases/tag/v0.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](https://atlasgo.io/blog/2026/11/17/atlas-v1-4) – The schema-as-code tool adds `atlas security scan` to report CVEs affecting your database servers and extensions.
- [Postbird 0.9](https://github.com/Paxa/postbird/releases/tag/v0.9.0) – A long-dormant open source Postgres GUI returns, rewritten on[Electrobun](https://electrobun.dev/).
- [pgAudit 19.0](https://github.com/pgaudit/pgaudit/releases/tag/19.0) – The audit logging extension is ready for Postgres 19.    

**Got a new email?** You can [change your address here](https://postgresweekly.com/edit_subscription/*|UID|*). 

--- 

**Bored of us?** [Click here to stop getting Postgres Weekly](https://postgresweekly.com/leave/*|UID|*). 

--- 

**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.
Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom 

Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada. 

[Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*).
