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 has 100% CPU for large databases, Discourse 2.7.7

pfaffman (Jay Pfaffman) August 30, 2021, 1:11pm 5

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

2 Likes

Topic		Replies	Views
Postgres using 100% of CPU Installation server-resources	18	19792	April 10, 2021
Some queries that don't finish Support	18	882	June 18, 2022
Primary Postgres database process (postmaster) eating all CPU Installation server-resources	13	3775	May 28, 2020
PostgreSQL runaway IO Installation	37	2912	March 17, 2021
Server Performance Issues Due to High CPU Usage Support	1	40	November 15, 2024