Hi there, I’m seeing an issue on my docker install. It’s on Linode on Ubuntu 14.04. Postgres is using 100% of the CPU. The forum itself is working just fine, version v1.6.0.beta7 +156. Doesn’t seem any slower or anything. Here’s a screen capture from “htop”: [صورة] Any pointers on how I can …

Replying to my own post, because I realized my mistake :slight_smile: VACUUM VERBOSE ANALYZE only works if I select the discourse database, of course :slight_smile:

Postgres using 100% of CPU

تثبيت

sam (Sam Saffron) 5 يونيو 2016، 9:29م 10

Are you running on our latest docker image? How many posts does your forum have?

الموضوع		الردود	مرات العرض
Postgres has 100% CPU for large databases, Discourse 2.7.7 Installation server-resources	4	710	30 أغسطس 2021
Some queries that don't finish Support	18	904	18 يونيو 2022
Primary Postgres database process (postmaster) eating all CPU Installation server-resources	13	4011	28 مايو 2020
Slow Sidekiq + Postmaster using 95%+ CPU (32 cores) after Postgresql Version Upgrade Installation server-resources	23	2918	28 يونيو 2020
PostgreSQL runaway IO Installation	37	2979	17 مارس 2021

Postgres using 100% of CPU

الموضوعات ذات الصلة