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.

Follow

@gargron "Eugen used this one weird trick to reduce the size of his PostgreSQL database by 40 GB! Hosting vendors hate him!!"

· · Web · 0 · 1 · 1
Sign in to participate in the conversation
Cybrespace

the mastodon instance at cybre.space is retiring

see the end-of-life plan for details: https://cybre.space/~chr/cybre-space-eol