Hi, we are running Docker based Discourse 2.7.7 with a very large user base. After upgrading from 2.4.2 to 2.7.7, we are experiencing that some Postgres process are stuck at 100% CPU. Further investigation results that such queries seem to cause the problem: discourse_prod=# select pid, datid, que…

We’ve found the issue was caused by a custom SQL query in a user badge. So this is not an upstream issue. Thanks.

This query seems to come from Jobs::BadgeGrant.

I suspect that you’ll also want to make sure that you vacuum and reindex as described in PostgreSQL 13 update .

Postgres يستهلك 100% CPU لقواعد البيانات الكبيرة، Discourse 2.7.7

pfaffman (Jay Pfaffman) 30 أغسطس 2021، 1:11م 5

أعتقد أنك ستريد أيضًا التأكد من إجراء عملية التنظيف وإعادة الفهرسة كما هو موضح في تحديث PostgreSQL 13.

الموضوع		الردود	مرات العرض
Postgres using 100% of CPU Self-hosting server-resources	18	20082	10 أبريل 2021
Unusually high CPU usage Self-hosting	32	525	20 مارس 2026
Some queries that don't finish Support	18	959	18 يونيو 2022
Long-Running Sidekiq Jobs Feature	21	1694	24 ديسمبر 2020
Primary Postgres database process (postmaster) eating all CPU Self-hosting server-resources	13	4146	28 مايو 2020