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.

Follow

@Gargron would be great if you could write up some instructions or docs for this 😀

Sign in to participate in the conversation
ABDL.link

ABDL.link is a community-led microblogging platform. We’re part of a decentralised federated social network, based on the open-source Mastodon project. ABDL.link is hosted on our own servers and supported by our patrons – we don’t sell your personal data or have ads.