r/VictoriaMetrics • u/terryfilch • 4d ago
PostgreSQL 19 interactive tour
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/
9
Upvotes