logoalt Hacker News

PostgreSQL 19

364 points • by linzhangrun • today at 3:45 AM • 26 comments • view on HN

Comments

dbgobrrr • today at 11:54 AM

Amazing release, really exciting features:

- REPACK CONCURRENTLY to reclaim disk space, which also affects performance.

- Logical replication of sequences - Fantastic addition. This is a missing piece in the major-version upgrade story which required extra scripting, and enable additional usecases.

- WAIT FOR LSN is a game-changer for read-replicas. For read-after-write, where the write goes to the master and the read hits a random replica. And also read-after-read, where each read may hit different replicas.

Add to that additional performance improvement and the plan advice extension, this makes 19 one of the most exciting releases of PostgreSQL.

Big big big kudos to the contributors, thank you!

rdsubhas • today at 2:24 PM

Huge respect to Postgres folks, and the features are amazing.

But an apologetic opinion: Postgres 18 was released in Sep 2025, and it's just Nov 2026. Half the companies I know haven't even updated to pg17 yet, let alone pg18's async I/O or anything. There are already so many features that are unadopted and unproven at scale.

IMHO the last software that I want to see feature creep or a large amount of major version bumps, is in my Database.

➕ show 3 replies
BitPirate • today at 12:27 PM

> Change JIT to be disabled by default (Jelte Fennema-Nio)

That was long overdue. The performance impact on perfectly fine tuned queries was horrendous.

It's also disabled by most OSM apps that make heavy use of PostGIS for exactly that reason.

Maybe it wouldn't be that bad if a copy-and-patch kind of JIT would be used?

➕ show 1 reply
arnejenssen • today at 9:49 AM

A huge thank you to all contributors for this gift

➕ show 1 reply
murkt • today at 5:09 AM

This is the most bug-free .0 release of Postgres. I am always waiting for at least .1 or .2 before upgrading. But should I wait this time?

➕ show 3 replies
lbriner • today at 9:59 AM

I always wondered why sequence numbers weren't replicated, it added another step to the stress of upgrading via pg_backup but thanks for adding it to PG19!

Dinux • today at 10:48 AM

Congrats to everyone who worked on this release!

ChrisArchitect • today at 5:58 AM

Earlier: https://news.ycombinator.com/item?id=50560357

➕ show 1 reply
patryk_builds • today at 2:00 PM

[flagged]

philippemnoel • today at 3:18 PM

Incredibly exciting release.