PostgreSQL 19 introduces a new `REPACK` command, including a `CONCURRENTLY` option, which reclaims disk space and reorganizes table contents without blocking reads and writes. This can lead to improved query performance. Additionally, two new extensions, `pg_plan_advice` and `pg_stash_advice`, are included to provide more control over query planner decisions, with the latter applying advice automatically.
The new version brings performance improvements across several areas, such as automatic scaling of I/O worker processes, quicker foreign-key checks, and further optimizations in query planning and execution. Logical replication sees updates allowing it to be enabled without a server restart when `wal_level` is set to `replica`, and it now supports the replication of sequence values. A new `WAIT` command provides 'read-your-writes' consistency on standbys.
Autovacuum functionality is enhanced with parallel processing for table indexes and a new scoring system for prioritization. Security-related changes include a new `password_expiration_warning_threshold` server variable for password expiration warnings and a warning for successful MD5 password authentication, as MD5 passwords were deprecated in PostgreSQL 18. RADIUS support has been removed due to unfixable insecurity.
PostgreSQL 19 introduces several compatibility changes. The `standard_conforming_strings` setting is now forced to always be on in the database server. This means dumps created with older `pg_dump` versions or with `standard_conforming_strings = off` will not load correctly into PostgreSQL 19. Users must use PostgreSQL 19 or later versions of `pg_dump` or ensure `standard_conforming_strings = on` during dump creation. The `escape_string_warning` server variable has also been removed.
Migrating data from previous PostgreSQL releases to version 19 requires a dump/restore using `pg_dumpall`, `pg_upgrade`, or logical replication. Users should consult the migration documentation for detailed instructions.
✨ This summary was generated by AI from the outlets' reporting listed below. It is not independently verified and may contain errors — check the original sources. How BrevFeed works →
One email each morning: the day's tech stories, clustered across outlets and summarized. No account needed.
One email a day. Unsubscribe in one click, any time.
Spend a few minutes, get the whole day. Every topic's top stories in one hands-free rundown — listen, watch, or read the transcript.
▶ Play today's briefNew every morning, and the back catalogue is archived by date.
PostgreSQL 19.0 was released on November 19, 2026, introducing new SQL features such as IGNORE NULLS, get-or-create inserts, JSON export, JSONPath transformations, and range subtraction. The update also includes maintenance and replication improvements, providing users with enhanced database capabilities.
PostgreSQL 19, scheduled for release in November 2026, will include a new REPACK command for disk space reclamation and performance, extensions for query planner control, and various performance enhancements. This update also brings logical replication improvements and changes to compatibility, such as the removal of RADIUS support and forced `standard_conforming_strings`.