PostgreSQL 19

Postgres 19's REPACK moves the exclusive lock from the whole rewrite to the file swap

PostgreSQL 19's beta REPACK rewrites a bloated table while writers keep committing, and one developer's benchmarks put nearly all of the cost in the sequential scan rather than in replaying the writes it captured.