main

1450 readers

1 users here now

Default community for midwest.social. Post questions about the instance or questions you want to ask other users here.

founded 4 years ago

MODERATORS

seahorse@midwest.social

Database maintenance tonight (midwest.social)

submitted 2 years ago by seahorse@midwest.social to c/main@midwest.social

7 comments fedilink hide all child comments

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.

you are viewing a single comment's thread
view the rest of the comments

[–] seahorse@midwest.social 1 points 2 years ago (1 children)

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 2 points 2 years 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.