Nabil-Fareed Alikhan
happykhan@mstdn.science
<p>Admin for <span class="h-card" translate="no"><a href="https://mstdn.science/about/more?instance_actor=true" class="u-url mention">@<span>mstdn.science</span></a></span>. <a href="https://mstdn.science/tags/bioinformatician" class="mention hashtag" rel="tag">#<span>bioinformatician</span></a>. Interested in <a href="https://mstdn.science/tags/microbiology" class="mention hashtag" rel="tag">#<span>microbiology</span></a> and <a href="https://mstdn.science/tags/genomics" class="mention hashtag" rel="tag">#<span>genomics</span></a>.</p>
Posts
-
Post #1895727
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 conversations, mentions, statuses_tags, tombstones [ Back up your db first just in case! ]