Admin for @mstdn.science. #bioinformatician. Interested in #microbiology and #genomics.
🌉 bridged from ⁂ https://mstdn.science/@happykhan, follow @ap.brid.gy to interact
Nabil-Fareed Alikhan
Loading...
You need a phd to admin a moodle. My god.
TGIF team.
How we all doing.
It appears today is the one sanctioned day of summer in the UK (per year). You have my permission to take the day off.
Tgif
"Tombstones" accumulate fast:
DELETE FROM tombstones WHERE created_at < NOW() - INTERVAL '3 months' LIMIT 100000;
Loop until DELETE 0, then VACUUM tombstones.
It's caturday. Post some mother liking cats.
Caturday. #CatsOfMastodon #Caturday
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 […]
Here's my suggestions for toolctl
tootctl media remove
tootctl media remove-orphans
tootctl preview_cards remove
tootctl media remove --prune-profiles
tootctl media remove --remove-headers
tootctl cache clear
tootctl statuses remove
tootctl accounts prune […]
As far as i know the SLURM scheduler was named after the drink in futurama.