Remix.run Logo
▲ jedberg 3 hours ago

REPACK is my favorite new feature. Vacuum was the bane of my existence when I ran Postgres at reddit. Partly because I didn't know what vacuum was for the first two years.

So I thought, "huh, every time vacuum runs it slows down, I should turn this off". Yeah it was dumb to not even google what it was for. About two years in, I hit the point where I ran out of row IDs, and that's when I finally learned what vacuum was for (and reddit was down for a bunch of hours).

Having REPACK would have been a godsend.

▲craigkerstiens 2 hours ago | parent [-]

Ha, you're not alone to have gone through "autovacuum slows things down let's turn it off". Yes, it's fundamental to how Postgres works, yes it's a pain in the ass so often.

I was so worried to talk much about repack when things started getting reverted. This felt like the riskiest thing of all the headline features in PG19 in my view. Not the graph support, not the split/merge partitions, not group by for all, repack felt like it wouldn't make it lone behold it was the one that did survive of so many headline features. Fingers crossed all the others hold up for PG20 and it ends up as packed with features as 19 was looking like, but at least for now we got repack.