other

REPACK

PostgreSQL SQL command that rewrites a table to reclaim space held by dead rows, optionally in the physical order of an index, with a CONCURRENTLY variant that keeps the table available during the rewrite.

Known aliases

REPACK (CONCURRENTLY)
REPACK USING INDEX

Relationships

No evidence-backed relationships are recorded.

Current clusters

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