PostgreSQL 19 ships with REPACK, letting you rebuild bloated tables without locking out reads and writes
Postgres 19 is out, and it's available on Neon and Databricks Lakebase

PostgreSQL 19 hit GA and is already live on Databricks Lakebase, thanks to several team engineers who are Postgres committers. The release is practical rather than flashy: REPACK rebuilds tables concurrently, pg_plan_advice and pg_stash_advice let you correct bad query plans, parallel autovacuum and new statistics views improve maintenance, and logical replication gains sequence sync and WAIT FOR LSN. A few big features, including SQL/PGQ, were reverted before release.
Concurrent repacking is also not MVCC-safe: after it commits, transactions using snapshots taken before the repack began can see the table as empty.