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プロセスの無限実行とパフォーマンス低下

Falco (Falco) 2025 年 2 月 17 日午後 2:08 3

After such moves it is a good idea to run a vacuum for database stats.

「いいね！」 1

トピック		返信	表示
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	19976	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	3993	2020 年 5 月 28 日
Server load issues (after rebuild hanged) Installation	4	188	2024 年 5 月 19 日