PostgreSQL 19 Interactive Tour: SQL/PGQ Graph Queries, Temporal Updates, and More
PostgreSQL 19 is in beta, with GA expected around September or October 2026. This hands-on companion to the official release notes turns selected new features into runnable examples against beta 3. Highlights include SQL/PGQ property graph queries, temporal UPDATE/DELETE with FOR PORTION OF, upsert's new ON CONFLICT DO SELECT, window functions with IGNORE NULLS, the unified REPACK command, autovacuum priorities, and more. Note: merge/split partitions were reverted after beta 3 and won't ship in 19.
One row in, three rows out, and the untouched periods keep the old price.
- weitendorf
Gotta say this site is killing it in the LLM-written technical blog SEO game the last couple years, they're consistently able to dominate (and actual deliver in spite of the LLM-isms) SERP for a set of technologies that very closely align with the ones that a typical backend/infrastructure engineer would work on.
I checked their list of blog articles from the last year and they haven't even written that many, which makes it quite impressive because they really model the set that I've been working with (Go, Postgres, grpc, otel) well by I guess defining some kind of customer archetype and writing really detailed guides about what they'd be interested in learning more about. At this point I've encountered their site "organically" like 5x in the last year and recognize the name/style of content so they're doing something right in the marketing department for sure.
On one hand you could just dismiss it as spam but articles like this actually represent a pretty significant LLM spend/human review element that delivers real value to me as a technical end user looking for info on google or in technical blogs on HN (ie it would take me a long time to generate something like this myself and I wouldn't do it proactively, only when-needed). So it actually does help me quite a bit that they do so before I think to ask about it.
- exceptione
The features look exciting, but the article is exceptionally unclear to me. I am not sure whether that is my fault, the author's, or the LLM's who wrote it.
The headline feature (property graphs) has a better example here in the official docs: https://www.postgresql.org/docs/19/ddl-property-graphs.html
- jgord
I am interested in what features postgresql 19 has .. and would like to see a summary that starts with a bullet list of highlights.
I found this tour unreadable.
Here's the official release notes page : https://www.postgresql.org/docs/19/release-19.html
which unsurprisingly does have a list of important changes near the top.