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.

Mostra el fil
Segueix

@Gargron at work we have an intense INSERT/UPDATE’ activity on the core DB so we must rebuild indexes every week to ensure performance and mitigate storage waste.

Inicia la sessió per participar a la conversa
mastodont.cat, xarxa social pels catalans d'arreu.

Servidor social en català per a la comunitat de llengua i cultura catalanes d'arreu d'internet.