I shaved off 40 GB from the mastodon.social database just by using pg_repack on indexes tonight.
@Gargron How big are the database and media directories in total? What size of server is required to host a community like mastodon.social?
@gargron "Eugen used this one weird trick to reduce the size of his PostgreSQL database by 40 GB! Hosting vendors hate him!!"
The original server operated by the Mastodon gGmbH non-profit