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.

  • veroxii@lemmy.world
    link
    fedilink
    English
    arrow-up
    6
    ·
    1 year ago

    Let me know if you need some advice. I’ve been helping the Lemmy devs with their db queries on GitHub. They should release a new version soon which will help a bit. And I gave some more advice today.

    You seem to know what you’re doing on the infra side but if you need someone to review pg settings and tuning I’m happy to help. I’m not sure how you installed this instance but I’d recommend pumping up the db connections from default and using a connection pooler like pgbouncer if you’re not already.

    • Ruud@lemmy.worldOPM
      link
      fedilink
      English
      arrow-up
      7
      ·
      1 year ago

      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!