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…

Endlessly running Postgres processes & bad performance after Reinstall/restore

Falco (Falco) February 17, 2025, 2:08pm 3

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

1 Like

Topic		Replies	Views
Primary Postgres database process (postmaster) eating all CPU Installation server-resources	13	3892	May 28, 2020
Slow Sidekiq + Postmaster using 95%+ CPU (32 cores) after Postgresql Version Upgrade Installation server-resources	23	2849	June 28, 2020
Postgres using 100% of CPU Installation server-resources	18	19898	April 10, 2021
Some queries that don't finish Support	18	886	June 18, 2022
Long-Running Sidekiq Jobs Feature	21	1514	December 24, 2020