Primary Postgres database process (postmaster) eating all CPU

[markersocial]

Just a heads up, I had the same issue and it was fixed by doing this:

Slow Sidekiq + Postmaster using 95%+ CPU (32 cores) after Postgresql Version Upgrade

Ok so to follow up, everything still looks good, postmaster has calmed down drastically and sidekiq is moving really fast again. To summarise on what worked in my scenario (with default db name of ‘discourse’): cd /var/discourse/ ./launcher enter app sudo -u postgres psql \c discourse Then from the postgres console, each of these below were run. Each one takes a bit of time to complete, depending on DB size, heavy CPU usage for the first two also: VACUUM FULL VERBOSE; REINDEX DATABASE disco…