And hopefully never will be. It seems like the people hosting instances aren't in it for the money. Particularly the *.world guys have other fediverse projects big enough that they could've done something like, say, add ads to it.
You could implement in-closet indexing instead to make the cache misses hurt less, trading off some extra insertion time but needing less memory for the cache which is much more expensive cost wise. At this point you're storing almost your whole DB in the cache and your room's a mess.
Yeah, I think just like with email, systems will have to be built up to give instance owners more control of what other instances can do to their instance. I see a lot of infrastructure possibilities here, spam filters, relays, directories, so many things are possible and while it kinda sucks, it's also great that the fediverse has grown to a size where this kind of thing is necessary already.
And hopefully never will be. It seems like the people hosting instances aren't in it for the money. Particularly the *.world guys have other fediverse projects big enough that they could've done something like, say, add ads to it.