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 di…

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

インストール

MiG 2016 年 6 月 5 日午前 12:28 3

Doesn’t look like anything else is running.

「いいね！」 1

トピック		返信	表示
Postgres has 100% CPU for large databases, Discourse 2.7.7 Self-hosting support server-resources	4	752	2021 年 8 月 30 日
Some queries that don't finish Support	18	937	2022 年 6 月 18 日
Primary Postgres database process (postmaster) eating all CPU Self-hosting support server-resources	13	4106	2020 年 5 月 28 日
Unusually high CPU usage Self-hosting support	31	400	2026 年 2 月 18 日
Slow Sidekiq + Postmaster using 95%+ CPU (32 cores) after Postgresql Version Upgrade Self-hosting support server-resources	23	3000	2020 年 6 月 28 日

Postgres using 100% of CPU

関連トピック