main

1429 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 3 years ago

MODERATORS

seahorse@midwest.social

Anyone here knowledgeable about postgres? (midwest.social)

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

3 comments fedilink hide all child comments

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.

top 3 comments

sorted by: hot top controversial new old

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

can you say more about the problem? what queries are you running?

[–] seahorse@midwest.social 4 points 2 years ago

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.

[–] InevitableWaffles@midwest.social 2 points 2 years ago

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