@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 I guess now you've made it automatic

@Gargron at work we have an intense INSERT/UPDATE’ activity on the core DB so we must rebuild indexes every week to ensure performance and mitigate storage waste.

@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 pg_repack is nice, but maybe is a signal you need to adjust pg vacuuming parameters 🙂