Conversation

Notices

1. Eugen 💀 (gargron@mastodon.social)'s status on Tuesday, 03-Jan-2023 16:53:16 UTC Eugen 💀

   in reply to

   I shaved off 40 GB from the mastodon.social database just by using pg_repack on indexes tonight.

   • Eugen 💀 (gargron@mastodon.social)'s status on Tuesday, 03-Jan-2023 16:53:17 UTC Eugen 💀

     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.

     Toni :mastodon: repeated this.