I think we really need to address the scaling issue, one option could be to use clichhouse instead of postgres

We could add an openapi option, server admin will be able to provide an API key and we could use that for auto moderation, it’s fast and cheap enough ($20 per 10 M characters)

Issue is cpu and memory usage, it’s very intensive…

We just launched Lemmy fully managed hosting service and we can see indeed an important interest from all over the world :)

https://elest.io/open-source/lemmy