OpenConceptLab / ocl_issues

Issues for all OCL repos. NOTE: Install ZenHub Browser Extension and request access to the OCL Roadmap board to view all issues and to contribute
4 stars 2 forks source link

Investigate slow DB responses #1944

Open rkorytkowski opened 1 month ago

rkorytkowski commented 1 month ago

Our DB occasionally has some hiccups and queries take much longer to respond.

One possibility is that auto vacuuming kicks in and slows the system down.

I'm also trying to determine why we continue to hit IOPS limits. I've set "log_temp_files" to 10 MBs to check for possible inefficiencies.