(www.cs.cmu.edu)

366 points virtualwhys | 1 comments | 20 Oct 24 15:30 UTC | HN request time: 0.201s | source

Show context

thr0w ◴[20 Oct 24 20:27 UTC] 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. fovc ◴[20 Oct 24 23:42 UTC] No.41899466[source]▶

>>41898232 #

The requirement for having two copies of the table simultaneously on systems that make it easy to add but not subtract storage. Otherwise pg_repack has worked really well.

We solved the 2x storage with partitions, but it feels like the tail wagging the dog

↑

MVCC – the part of PostgreSQL we hate the most (2023)