I use htop command,
I noticed the CPU goes too high.
I get the error: postgres: 10/main
How to handle this error?
2 Likes
I think that PG 10 is no longer supported. See PostgreSQL 13 update.
But if you did an upgrade and didn’t get an error, then it’s probably OK (but you should upgrade to PG13). The PG13 upgrade was pushed because it improves some performance issues that might include the one that you’re seeing.
2 Likes
This is not, strictly speaking, an error. But a large is running which may be a scheduled job or migration.
Regardless, this is a good suggestion:
I would allow it some time to settle after the upgrade; you do have a lot of CPU still available. After it settles down, back up your data and go through the update procedure, it’ll likely increase performance.
5 Likes
I guess so, and that’s why I want to stop Jobs::PeriodicalUpdates (Jobs::PeriodicalUpdates is the cause of high CPU (over 100%) - #7 by hokod)
2 Likes