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
- 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.
- Nov 19, 2026The PostgreSQL Global Development Group announces the release of PostgreSQL 19, introducing the REPACK command and REPACK (CONCURRENTLY).
- 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