TLDR: The main reason was Lemmy hogging server resources.
Last year, during the Reddit 2023 API controversy I finally deleted my account and moved on to Lemmy. Here’s a look at my experiences and why I eventually decided to switch to PieFed.
But I get the database thing. Its spiking every couple minutes and a lot every hour. It’s not a big deal if you have 2 threads at least but I can see how it doesnt work for everyone in every scenario.
Yea database management seems to where the growing pains are right now (with the core devs welcoming help from anyone with DB/PostreSQL expertise) … and indeed it seems to be a perennial issue across the fediverse platforms.
If I may ask (sorry, probably annoying) … what sort of resources would you recommend for a small personal lemmy instance? (let’s say 1-5 users, ~200 community subs and a few local communities?)
Not annoying at all.
I‘m running a public instance on two threads and I think 2 gb of ram. A private instance shared with other services on 6 threads and 8 gb of ram. Make of that what you want. :)
I would probably rent a vps which you could extend if needed but start small. With 2 threads and 4 gb of ram at least.