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”: [imagen] Any pointers on how I ca…

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

Soporte Instalación

DeanMarkTaylor (Dean Taylor) 5 Junio, 2016 00:25 2

Are there any jobs running?

Try opening the following URL for your site:
/sidekiq

4 Me gusta

Tema		Respuestas	Vistas
Postgres has 100% CPU for large databases, Discourse 2.7.7 Self-hosting server-resources	4	755	30 Agosto 2021
Some queries that don't finish Support	18	943	18 Junio 2022
Primary Postgres database process (postmaster) eating all CPU Self-hosting server-resources	13	4110	28 Mayo 2020
Slow Sidekiq + Postmaster using 95%+ CPU (32 cores) after Postgresql Version Upgrade Self-hosting server-resources	23	3013	28 Junio 2020
Unusually high CPU usage Self-hosting	32	465	20 Marzo 2026

Postgres using 100% of CPU

Temas relacionados