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.
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.
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.