If it's too much of a pain in the ass, bloat.cawfee.club feels a bit faster, maybe even is, and I bet it burdens the server a bit less.
Embed this noticeAdministrize (admin@cawfee.club)'s status on Tuesday, 03-Jun-2025 08:19:42 JST
AdministrizeHey. During the weekend, I ran the numbers in order to find out what are the top (Mastodon) instances that have us blocked, solely in order to block off some deaf driftwood clogging our pipes. I was surprised to see that even mastodon.social, the flagship, was just around 1% of objects created in the database in the last few months. So there we go, I'm opening up federating with all instances (that we didn't block before). The additional load shouldn't be too high, but I'll keep an eye on it.
During the last few weeks (since getting Cawfee back up), I also monitored the Known Network timeline a little and it's pretty evident that poa.st and misskey.io are kind of dominant there. So for the sake of wolesome diversity, those two instances are getting removed from the Known Network. No hard feelings against anyone there, you can still follow the accounts etc. It's mostly a gut feeling. (Maybe it will slow down the influx in unexpected ways, although I wouldn't bet on it.)
>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.
Brothers, xisters, welcome back. As you probably know, Cawfee Club has unprecedently been down for a month. What started as a weekend maintenance, kept dragging on and after a week or two, I became increasingly despondent and my mental state spiraled downwards. It was pretty much this feedback loop when the longer the instance was down, the less I felt like fixing things. So yeah, you could say it's my fault.
I could apologize endlessly, but for now, just seeing the levels of activity on here so high after only a few hours moves me beyond words. I really love you guys, and I missed you a lot.
A thorough explanation will come later. For now though, there's a particularly vile bit of disinformation I have to debunk - this downtime was NOT caused by updating Pleroma. I did not update Pleroma. I'm looking at you, hakui.
That being said, we'll be federating in whitelist mode for at least a day or two so that the server is not overloaded by catching up on too many posts. I'm open to adding any instances to the whitelist, just tell me the domains in response to this post.