Postgres has 100% CPU for large databases, Discourse 2.7.7

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

2 Likes