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

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.

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

[–] 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.