← All stories
● Covered by 1 source · 2 reportsMedium impact2 neutral

PostgreSQL 19 Introduces REPACK, Query Planner Advice, and Performance Improvements

🔄 Updated 1d ago — new reporting from Hacker News Front Page
New to BrevFeed? We gather this story from every outlet covering it into one summary — ranked by real-world impact, not just the latest headline — so you never miss what matters. What is BrevFeed? →

Key points

  • New REPACK command reclaims disk space and reorganizes tables.
  • pg_plan_advice and pg_stash_advice extensions control query planning.
  • Performance improvements include I/O worker scaling and faster foreign-key checks.
  • Logical replication can be enabled without restart and supports sequence values.
  • PostgreSQL 19.0 was released on November 19, 2026.
  • New SQL features include IGNORE NULLS, get-or-create inserts, JSON export, JSONPath transformations, and range subtraction.

New Features for Performance and Management

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.

Performance and Replication Enhancements

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 and Security Updates

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.

Compatibility Changes

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.

Migration Requirements

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.

Updates

🕒 2026-11-20 · new reporting from Hacker News Front Page
  • PostgreSQL 19.0 was released on November 19, 2026.
  • New SQL features include IGNORE NULLS, get-or-create inserts, JSON export, JSONPath transformations, and range subtraction.

✨ 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 →

The daily brief

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.

Today's brief

Spend a few minutes, get the whole day. Every topic's top stories in one hands-free rundown — listen, watch, or read the transcript.

~4 min · 3 stories · Nov 21

▶ Play today's brief Listen on Spotify

New every morning, and the back catalogue is archived by date.

How outlets covered it

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`.