Conversation

Notices

1. Embed this notice
   feld (feld@friedcheese.us)'s status on Tuesday, 18-Feb-2025 16:41:56 JST feld
   Every new post probably costs like $0.50 in electricity but every deleted post costs like $10 in electricity
   • Embed this notice
     feld (feld@friedcheese.us)'s status on Tuesday, 18-Feb-2025 16:49:36 JST feld

     in reply to
     "How is this possible?"
     
     Let's pretend m.s is connected to 30,000 instances. The example user has 1000 followers across 100 instances. Making the post sends it to those 100 instances.
     
     But when you delete it doesn't know who could possibly have a copy of the post, so it sends the delete to all 30,000 instances. Even if that instance has never seen the user before. It can't be certain, so it has to send it everywhere to be safe.
     
     Gigantic waste of resources
   • Embed this notice
     feld (feld@friedcheese.us)'s status on Wednesday, 19-Feb-2025 10:43:24 JST feld

     in reply to

     • holga
     @hpk The Postgres operations for cleaning up / cascading for deletes is a lot -- can cascade to other activities like favorites, boosts, etc, enough to break low powered servers. So it's made up but wouldn't surprise me. I wasn't even thinking about operations that Mastodon probably does to delete all media it is holding for them too.
     
     The number is completely made up but I think it's plausible if not today than in the near future for a delete coming from a Mastodon.social user
   • Embed this notice
     holga (hpk@chaos.social)'s status on Wednesday, 19-Feb-2025 10:43:25 JST holga

     in reply to

     @feld how did you get to the 10 dollar figure pee deleted post? Seems high for maybe 30 thousand network requests?