@silverpill I dunno, see Phantasm's most recent reply here. He claims this isn't a problem that's unique to #pleroma:
This is regular maintenance that is also done on every day databases, nothing special. The table bloat is a side-effect of how Postgres works and you can never get rid of it completely.