Skip to content
ViqusViqus
Navigate
Company
Blog
About Us
Contact
System Status
Enter Viqus Hub

PostgreSQL 19 Ships Online Table Repacking and Query Plan Controls

PostgreSQL 19 REPACK Query Planning Autovacuum Logical Replication SCRAM Authentication pg_plan_advice
November 22, 2026
Source: InfoQ AI

This summary and analysis were generated by AI from the original article at InfoQ AI and may contain errors (how Viqus works). Read the source for full details.

Viqus Verdict Logo Viqus Verdict Logo 4
Solid Upgrade, Not Seismic
Media Hype 3/10
Real Impact 4/10

Article Summary

The PostgreSQL Global Development Group has released PostgreSQL 19, a major update to the open-source relational database. The headline maintenance feature is REPACK, which reclaims unused table space and can reorder rows to match an index. Its CONCURRENTLY option runs without blocking reads or writes, positioning it as a possible replacement for common VACUUM FULL and CLUSTER uses. New extensions, pg_plan_advice and pg_stash_advice, let administrators influence query plan selection and apply stored advice by identifier without application code changes. Other changes include parallel index vacuuming, autovacuum prioritization tweaks, better EXPLAIN ANALYZE reporting of asynchronous I/O and WAL, faster bulk inserts with foreign keys (nearly twice as fast in PostgreSQL's testing), and planner improvements for anti-joins and eager aggregation. Replication gains sequence support and WAIT FOR LSN for read-your-writes consistency. Security changes add server-side SNI and a warning after MD5 password authentication. JIT compilation is now off by default, and LZ4 becomes the default TOAST compression where supported. Community discussion urges caution for critical production systems until the 19.1 minor release.

Key Points

  • REPACK CONCURRENTLY enables online table reorganization without blocking reads or writes, a potential replacement for many VACUUM FULL and CLUSTER uses.
  • New pg_plan_advice and pg_stash_advice extensions let administrators steer query plans without changing application code.
  • Replication, security, and default-setting changes such as WAIT FOR LSN, server-side SNI, and JIT being disabled by default affect operations teams during upgrades.

Why It Matters

This is a solid, routine major release of a widely used database. Its operational improvements, especially online repacking and plan control, reduce downtime and tuning pain for production teams, but they refine existing capabilities rather than changing how databases or AI systems are built. The relevance to AI is indirect, mainly through backends for retrieval and application data. Teams should review default changes such as JIT and LZ4 before upgrading, and the community advice to wait for 19.1 is sensible.


You might also be interested in