Sometimes DB gets fired because of some queries, and we were told that we need to optimize the PostgreSQL, any idea hot to achieve this? In the screen below this is our DB resources CPU: 4 vcpu Memory: 22 GB [image]

Hello all, I’m working with @Abdelrahman_MoHamed on this. We recently migrated a site with roughly 500k topics and 3.5 million users to discourse. We are self hosted on GCP. During this process our partner who assisted with the migration mentioned it might make sense to optimize Postgres to get prop…

Do you have more detailed evidence that the DB is the limiting factor, or is the cause of these CPU loads? Output of ps or top, for example. If it is the DB, I imagine there’s some way of asking it which queries it is working on. Such details might be helpful.

Thanks @Ed_S we will add more data here soon. Just monitoring things for now. Appreciate the response.

that does seem like a weird combo … 22GB memory but only 4 vcpu? Overkill on memory, but potentially too few cores. normally you’d have a server with much more vcpu per GB that’s because web serving is very parallel and for each unicorn you need only around 1GB. Each Unicorn can run on a differe…

Is small sidestep allowed? Are unicorns similar thing than workers of PHP? Some document tried explain that unicorns are actually HTTP-servers with own workers delivering requests to Ruby, and that’s why it is totally different. But both handles http-reguests allowing more concurrent requests and th…

[image] Jakke Flemming: Are unicorns similar thing than workers of PHP? yes, I think that’s a fair comparison

Related: How might an admin find out if they have too few, or too many, unicorns for their web traffic? Related: How might an admin find out if they have much more RAM than they need? My understanding is that the number of unicorns is generally scaled according to the number of CPUs, but it needn’…

How to optimize postgres and the discourse DB

Product Support

merefield (Robert) December 9, 2024, 11:54am 13

yes, I think that’s a fair comparison

Topic		Replies	Views
Optimizing the number of Unicorns and buffer size Self-hosting server-resources	22	7157	June 9, 2018
Should I change the value of db_shared_buffers and UNICORN_WORKERS with a multi discourses server? Product Support	2	695	December 14, 2020
Primary Postgres database process (postmaster) eating all CPU Self-hosting server-resources	13	4473	May 28, 2020
Recommendation for number of workers: cores × 2? Self-hosting	16	722	April 29, 2025
Configure Discourse Docker on servers with more RAM and CPU Self-Hosting docker , how-to	0	6455	August 7, 2014

How to optimize postgres and the discourse DB

Related topics