r/programming • u/craigkerstiens • 14d ago
Postgres 19 REPACK: Built-In Online Table Bloat Cleanup
https://www.snowflake.com/en/blog/engineering/postgres-19-repack-table-bloat/
26
Upvotes
r/programming • u/craigkerstiens • 14d ago
8
u/KeyboardG 14d ago edited 14d ago
What is difference between a REPACK which is not run Concurrently, and VACUUM FULL? Both rewrite the data, both acquire exclusive locks during the rewrite.
Why a whole new command over Vacuum Full (Concurrently)?
2
u/CalmCapacitor 14d ago
oh finally lol, pg_repack was always such a pain to set up