←back to thread

366 points virtualwhys | 1 comments | | HN request time: 0.388s | source
Show context
thr0w ◴[] No.41898232[source]
Don't agree with their characterization of `pg_repack`. `VACUUM FULL` is definitely crushing, but that's why repack exists as a faster/lighter alternative. Anyone have a different experience?
replies(2): >>41898486 #>>41899466 #
1. dfox ◴[] No.41898486[source]
pg_repack is an hack-ish solution to do what VACUUM FULL does without completely locking the relation in question. But well, when you care about either of these things, your workload has significant issues, with the typical case being using pgsql as a backend for something that was originally a thick client designed for some kind of RDBMS based on shared files (InterBase mentioned in TFA, MS Jet whatever…)