In an effort to update our Forum I did a fresh VPS install + Restore on the weekend. This was going to solve multiple issues for us: Renew outdated ubuntu Update Discourse Upgrade to Postgres 15 While generally things went fine I saw issues coming up afterwards with Postgres processes going wild…

重装/恢复后Postgres进程无限运行和性能差

pfaffman (Jay Pfaffman) 2025 年2 月 17 日 15:53 4

How much ram and cpu do you have?

How much memory do you give postgres?

话题		回复	浏览量
Slow Sidekiq + Postmaster using 95%+ CPU (32 cores) after Postgresql Version Upgrade Installation server-resources	23	2892	2020 年6 月 28 日
Postgres using 100% of CPU Installation server-resources	18	19974	2021 年4 月 10 日
Post 3.5.1 update - CPU maxed out 100% Support	5	81	2025 年2 月 4 日
Primary Postgres database process (postmaster) eating all CPU Installation server-resources	13	3992	2020 年5 月 28 日
Server load issues (after rebuild hanged) Installation	4	188	2024 年5 月 19 日