• Is the blocker here that each instance is a single postgres/Lemmy process? I imagine a clustered inplementstion of the Lemmy backend could be used to shard individual communities to dedicated containers when they reach a given size, proxies through a community away load balancer? More to manage but would let instances scale up/down as needed. There are costs associated with this, but those of us who run instances do it because we like playing this game.

    • Yeah, from what I understand most instances are pretty much the modern day equivalent of a phpBB forum on a server in someone’s bedroom. This situation is basically an invitation for the sort of people who play with Kubernetes for fun, get one of them involved and a lot of these problems will be at least reduced a fair bit.