To other Mastodon sysadmins: Check what pg_repack can do for you, especially if your server has been around for a really long time. PostgreSQL indexes get bloated over time and VACUUM does nothing about it. pg_repack can re-build indexes without downtime.
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 Ah, so you're starting the year with a thorough cleaning of the house. Quite respectable.
@Gargron Next Hogmanay come for a ceilidh instead :)
Bliadhna Ur Mhath
@gargron "Eugen used this one weird trick to reduce the size of his PostgreSQL database by 40 GB! Hosting vendors hate him!!"
@Gargron
start the year off right, start the year’s mastodon off light
@Gargron
Thank you very much, you are the best