← Sunday, October 4, 2026DatabasesBenchmark

Postgres 19 REPACK CONCURRENTLY was fastest in an online rewrite comparison

postgresweekly.com 4 min read Editor score 6/10

A measurement comparing Postgres 19’s REPACK CONCURRENTLY with pg_repack and pg_squeeze found REPACK fastest, while noting trade-offs. The results can inform online table-rewrite choices, though the excerpt does not detail the downsides.

What

Postgres 19’s REPACK CONCURRENTLY was compared with pg_repack and pg_squeeze for online table rewriting.

How

REPACK was fastest in the tests, but a bug that could lose updates was fixed and testing found a hard limit on concurrent changes it can absorb.

Why it matters

Engineers evaluating online table maintenance need to weigh rewrite speed against concurrency limits and update-safety concerns.

Read on postgresweekly.com →

Headline, summary, brief and diagram are written by a model from the source's own text; the link, byline and numbers come from the source. Read the original before relying on a claim.