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.

Postgresは大規模データベースでCPU使用率100%、Discourse 2.7.7

pfaffman (Jay Pfaffman) 2021 年 8 月 30 日午後 1:11 5

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

「いいね！」 2

トピック		返信	表示
Postgres using 100% of CPU Installation server-resources	18	19973	2021 年 4 月 10 日
Some queries that don't finish Support	18	903	2022 年 6 月 18 日
Long-Running Sidekiq Jobs Feature	21	1580	2020 年 12 月 24 日
Primary Postgres database process (postmaster) eating all CPU Installation server-resources	13	3992	2020 年 5 月 28 日
PostgreSQL runaway IO Installation	37	2950	2021 年 3 月 17 日