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

you are viewing a single comment's thread
view the rest of the comments
[-] 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

1333 readers
9 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