Anyone here knowledgeable about postgres? (midwest.social)

submitted 1 year 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

[-] InevitableWaffles@midwest.social 2 points 1 year 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

[-] greynoises@midwest.social 2 points 1 year ago

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

[-] seahorse@midwest.social 6 points 1 year 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.

this post was submitted on 08 Jun 2023

8 points (100.0% liked)

main

1307 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