@Gargron

I'm doing that safely on pleroma from time to time, even with vacuum full it works fine. Though it somehow resets postgres caching states and instance runs slower for few hours/days. And it needs 2x free space.