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.

Show thread
Follow

@Gargron How big are the database and media directories in total? What size of server is required to host a community like mastodon.social?

· · SubwayTooter · 0 · 0 · 1
Sign in to participate in the conversation
Mastodon @ social.lsnet.eu

The social network of the future: No ads, no corporate surveillance, ethical design, and decentralization! Own your data with Mastodon!