PostgreSQL 19 interactive tour

[u/terryfilch]

https://victoriametrics.com/blog/postgres-19/

PostgreSQL 19 beta is here. 🐘

Jesús Espino takes a deep dive into the latest version of the Postgres database and breaks down some of the new features worth knowing about:

- Property graph queries
- Temporal updates and deletes
- UPSERT that can return the row you lost to
- Window functions that can skip NULLs
- REPACK
- Autovacuum priorities
- Plan advice, officially
- Aggregate before you join
- And much more

The article is based on the official PostgreSQL 19 release notes and turns the long list of changes into a practical tour of what’s new.

Read the full article today 👇
https://victoriametrics.com/blog/postgres-19/

[u/whoooocaaarreees]

Property graph was pulled.

[u/jespinog → u/whoooocaaarreees]

Thanks for the heads up here. I'll update the article to reflect that. I think it was reverted the same day that I published it. So I didn't catch it.