build1 publisher
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.
Publishers:dev.to
Reality
- Evidence55
- Adoption8
- Hype gap+12
- Incentives20
- Confidence58