Trusence Every claim has a source
Last updated 22 November 2026 Search Türkçe
Infrastructure

PostgreSQL 19 adds non-blocking table repacking and query plan controls

Teams running on MD5 passwords or relying on JIT compilation will see changes at upgrade time.

The PostgreSQL Global Development Group has shipped PostgreSQL 19, which adds tools for table maintenance, query planning, replication and application development. Its REPACK command can reclaim unused table space and reorder rows to match an index, and with the CONCURRENTLY option it runs without blocking reads or writes, positioning it as a possible substitute for many uses of VACUUM FULL and CLUSTER. Administrators can steer query plans through the new pg_plan_advice and pg_stash_advice extensions without touching application code. Replication gains sequence support, and a new WAIT FOR LSN command lets applications hold reads until a standby has replayed a given WAL position. Two changes affect upgrades: JIT compilation is now off by default, and a warning appears after successful MD5 password logins, since MD5 is slated for removal in a later release.

Why it matters

For database administrators and the developers who depend on them, PostgreSQL 19 offers a built-in way to reclaim table space and reorder rows without locking out reads and writes, which may reduce reliance on older, blocking maintenance commands. Administrators also gain the ability to steer query plans without changing application code. The two upgrade-facing changes, JIT being off by default and the MD5 warning, signal that MD5 authentication is on a path to removal and that JIT is no longer assumed to be a net gain.

Sources · 1