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.
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.
Well, we’re still here. Which means it was successful?
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.
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.