# PostgreSQL 19 Released

- HackerByte page: <https://hackerbyte.net/en/stories/postgresql-19-released-50560357>
- Original source: <https://www.postgresql.org/about/news/postgresql-19-released-3449/>
- Hacker News discussion: <https://news.ycombinator.com/item?id=50560357>
- Submitted to Hacker News: 2026-11-19T14:11:37.000Z

## AI-generated summary

PostgreSQL 19 has been released, introducing significant improvements for mission\-critical workloads and developer experience. Key features include the new REPACK command for efficient table optimization, the pg\_plan\_advice extension for query plan stability, and enhanced logical replication capabilities. The release also brings performance boosts and new functionalities like 'read\-your\-writes' consistency on standbys and 'get or create' behavior for INSERT statements.

## Key points

- Introduced REPACK \(CONCURRENTLY\) command for non\-disruptive table optimization.
- Added pg\_plan\_advice extension for better control over query plan stability.
- Simplified logical replication initialization and added sequence value replication.
- Implemented 'read\-your\-writes' consistency on standbys with WAIT FOR LSN.
- New INSERT ... ON CONFLICT DO SELECT supports 'get or create' pattern for developers.
