I’m trying to fix this annoying slowness when posting to larger communities. (Just try replying here…) I’ll be doing some restarts of the docker stack and nginx.

Sorry for the inconvenience.

Edit: Well I’ve changed the nginx from running in a docker container to running on the host, but that hasn’t solved the posting slowness…

  • RoundSparrowEnglish
    1·
    1 year ago

    Well I’ve changed the nginx from running in a docker container to running on the host, but that hasn’t solved the posting slowness…

    I encourage you to install PostgreSQL extension pg_stat_statements to get a better idea of just how overloaded the database can be.

    I am finding SQL INSERTS are taking a long time on likes - and you have way more data than I do on your server.

    https://github.com/LemmyNet/lemmy/issues/2877#issuecomment-1597654037