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) 17 בפברואר,‏ 2025,‏ 3:53pm 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	28 ביוני,‏ 2020
Postgres using 100% of CPU Installation server-resources	18	19974	10 באפריל,‏ 2021
Post 3.5.1 update - CPU maxed out 100% Support	5	81	4 בפברואר,‏ 2025
Primary Postgres database process (postmaster) eating all CPU Installation server-resources	13	3992	28 במאי,‏ 2020
Server load issues (after rebuild hanged) Installation	4	188	19 במאי,‏ 2024