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 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

@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!!"

start the year off right, start the year’s mastodon off light

Sign in to participate in the conversation

The original server operated by the Mastodon gGmbH non-profit