I’m not happy with the performance, especially when clicking ‘Post’ it takes too long.
First I will upgrade this VPS from 2cpu/4GB to 4cpu/16GB.
Then I will tune the database (more shared_buffers to start with)
After that I’ll see what more I can tune, together with the Lemmy admin channel.
Thanks for the offer! The database side is the side I’m most familiar with (I’m a (Postgres) DBA), but any help is appreciated at this moment because there’s a lot to do with this crazy inflow of users!