Technology
PostgreSQL 19 preview details upcoming features ahead of anticipated release
PostgreSQL 19 is targeting general availability around autumn 2026, according to Hacker News.
The short version
- PostgreSQL 19 is currently in beta testing, with full release projected around September or October 2026.[Hacker News]
- The upcoming database version implements SQL/PGQ property graphs alongside new query features such as ON CONFLICT DO SELECT.[Hacker News]
- A planned REPACK command was recently reverted due to design issues and will not be included in version 19.[Hacker News]
Key facts
- PostgreSQL 19 is in beta, with general availability expected around September or October 2026.[Hacker News]
- The release implements the SQL/PGQ property-graph feature from SQL:2023.[Hacker News]
- An ON CONFLICT DO SELECT clause has been added to INSERT statements.[Hacker News]
- Multiple window functions now accept the SQL-standard IGNORE NULLS clause.[Hacker News]
- The REPACK feature was reverted on August 27, 2026, due to design issues.[Hacker News]
What remains uncertain
- The initial property graph implementation does not support variable-length paths.[Hacker News]
- The exact general availability date remains approximate around September or October 2026.[Hacker News]
Sources
Outlet counts describe coverage, not independent confirmation. Reports may share a wire service or original source.
- PostgreSQL 19 Interactive TourHacker News