I upgraded my server to 2 cores instead of 1, but I’m still seeing a cpu spike for postgres. If anyone has any postgres expertise and wants to help out troubleshooting it let me know.
You must log in or register to comment.
I’m not a DB person but I threw “postgres CPU spiking” into Duckduckgo and got some things to check from stack overflow and server fault.com
can you say more about the problem? what queries are you running?
So…turns out you have to tune databases. Who knew?! I set some variables from https://pgtune.leopard.in.ua/ and it looks way better now.
