Hello, you’ve probably experienced slowness and timeouts recently and I’m going to try to fix it by backing up the DB, blowing it away, and then recreating it from backup. Wish me luck.

    • seahorse [Ohio]@midwest.socialOPM
      link
      fedilink
      English
      arrow-up
      3
      ·
      1 year ago

      I was able to rebuild the DB but there’s still the CPU spiking issue with postgres which causes the site to slow way down.

      • WithMeDoctorWu@midwest.social
        link
        fedilink
        English
        arrow-up
        2
        ·
        1 year ago

        Been a few years but if I recall correctly the postgres “out of the box” settings are extremely conservative with regard to memory usage, to allow implementation on minimal hardware. (That might have changed in the last few years.) Once there’s significant data flow, some of the params need to be jacked up to run smoothly.

        Disclaimer, I’m certainly no expert, and you might already know more about this than I do.