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?)