Time for some database spring cleaning .
Here are my top tips for mastodon admins!
Index bloat is your #1 enemy. Federation churn (constant insert/delete cycles) destroys B-tree indexes fast. Run this on your Postgres server:
REINDEX TABLE CONCURRENTLY public.statuses;
Repeat for […]
