Postgres 19 adds built-in table bloat cleanup
lavx.hu

Postgres 19 adds built-in table bloat cleanup

The gist

The PostgreSQL Global Development Group released PostgreSQL 19 on November 19, 2026, adding a REPACK command.
REPACK cleans bloated tables while they stay readable and writable, avoiding maintenance windows.

How it unfolded

  1. Nov 2, 2026A Snowflake engineering blog post by Craig Kerstiens describes Postgres 19 REPACK as reclaiming bloated table space while the table stays fully readable and writable, taking only a brief lock at the end and running without any extension.
  2. Nov 19, 2026The PostgreSQL Global Development Group announces the release of PostgreSQL 19, introducing the REPACK command and REPACK (CONCURRENTLY).
  3. Nov 19, 2026PostgreSQL 19 becomes generally available, with Aiven offering full production support from day one and EDB welcoming the release in the project's 30th year; Databricks makes it available on Lakebase.

Key terms

REPACK
A free and open-source relational database management system emphasizing extensibility and SQL compliance.
MVCC
A non-locking concurrency control method used by database systems to allow concurrent access to data.
VACUUM FULL
A domain-specific language for managing data in relational database management systems.

Source: Wikipedia

Sources

Read the full story in the app Gistline — free on the App Store