Conversation

Notices

1. Embed this notice
   Tobias Hellgren (thanius@mastodon.chuggybumba.com)'s status on Sunday, 20-Oct-2024 15:19:38 JST Tobias Hellgren

   Finally took care of some maintenance I've put off since migrating to 4.3, mainly refreshing remote account media and removing dead accounts (I lost 7 followers!! 😱)

   Is it best/good practice to do this regularly on schedule?

   #MastoAdmin

   • Embed this notice
     Tobias Hellgren (thanius@mastodon.chuggybumba.com)'s status on Sunday, 20-Oct-2024 17:43:57 JST Tobias Hellgren

     in reply to

     • Paul Chambers

     @paul I'll add that to my tasks then, thanks! I've only been using the tootctl thus far

   • Embed this notice
     Paul Chambers (paul@oldfriends.live)'s status on Sunday, 20-Oct-2024 17:43:58 JST Paul Chambers

     in reply to

     @thanius I'm doing those types of tasks, also. I just vacuumed my database. Being self-hosted, I use several relays and it gets big with garbage that should be cleaned out and for whatever reason, autovacuum is not keeping up and I'm not too keen to tweak it right now. Reduced my database by 10GB

     Code I used, after a backup of the db, is

     su - mastodon -s /bin/bash
     psql mastodon_production mastodon
     VACUUM(FULL, ANALYZE, VERBOSE);

     I'm on a Debian VPS box, not docker, nor managed hosting.

     #MastoAdmin https://www.postgresql.org/docs/current/sql-vacuum.html