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