EDIT: It seems to have been fixed thanks to @graycube@lemmy.world. Running analyze verbose; in postgres.

After updating to 0.19.5 from 0.19.3 my postgres is often using up 500%+ of CPU according to docker stats and often going to 100% CPU on most cores according to htop. Also noticed in the uptime monitor:

htop shows one of the 5 postgres processes constantly on UPDATE. I think this might be part of the problem.

I’m not comfortable with postgres and am honestly completely in the dark how or where to mitigate or even pinpoint this issue.

Any help would be appreciated.

  • DosDude👾@retrolemmy.comOP
    5·
    5 months ago

    Thanks. I ran it. Hopefully it’ll make a difference.

    Edit: It looks like this did the trick. I’ll keep monitoring to see if it sticks. Thanks again!