Admin for @mstdn.science. #bioinformatician. Interested in #microbiology and #genomics.
Admin for @mstdn.science. #bioinformatician. Interested in #microbiology and #genomics.
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! ]
Admin for @mstdn.science. #bioinformatician. Interested in #microbiology and #genomics.
Admin for @mstdn.science. #bioinformatician. Interested in #microbiology and #genomics.
Admin for @mstdn.science. #bioinformatician. Interested in #microbiology and #genomics.
Admin for @mstdn.science. #bioinformatician. Interested in #microbiology and #genomics.
Admin for @mstdn.science. #bioinformatician. Interested in #microbiology and #genomics.
Admin for @mstdn.science. #bioinformatician. Interested in #microbiology and #genomics.
Admin for @mstdn.science. #bioinformatician. Interested in #microbiology and #genomics.
Admin for @mstdn.science. #bioinformatician. Interested in #microbiology and #genomics.
Admin for @mstdn.science. #bioinformatician. Interested in #microbiology and #genomics.
Admin for @mstdn.science. #bioinformatician. Interested in #microbiology and #genomics.
Admin for @mstdn.science. #bioinformatician. Interested in #microbiology and #genomics.
Admin for @mstdn.science. #bioinformatician. Interested in #microbiology and #genomics.