Untitled attachment

Notices where this attachment appears

1. Embed this notice
   Administrize (admin@cawfee.club)'s status on Saturday, 31-May-2025 07:29:35 JST Administrize

   in reply to
   @vokainen099 @r Sure.
   
   >How much space did it save in the end?
   If I remember correctly, 34 GB. The objects table got pretty much halved. As for activities, only about 2 GB got removed after 16 hours of running it on my laptop. When it ran directly on Cawfee for weeks, it was probably even less, but that's the throttled block storage for ya.
   Of course you'll have to squash/repack afterwards to reclaim the space.
   >Did you also pass the --prune-orphaned-activities argument?
   Yeah. That's the slow part. The queries have multiple joins, phnt said it can't really be done any other way. But years ago when only Akkoma had this, I took their commits and it took less than a day. (https://info.cawfee.club/soti-2024-04.html) The Pleroma implementation is different.
   It didn't even get to the second query.