Which is more performant: A separate PostgreSQL server? Or local PostgreSQL? I have been running PostgreSQL on a separate server for a long time and use it on my site. From time to time I wonder, do you think this is necessary? So would local be more performant or a separate server?

I’m thinking forward, but right now there may or may not be 600-1000 unique users. I set up a separate server in case I need more in the future, but I don’t know the exact capacity of the discourse. If I host Postgresql on the same machine, will it slow down under heavy load? How many users can it handle locally at a time? my server; Intel® Core™ i5-13500 64GB DDR4 2 x 512GB NVMe SSD (Gen4) (Software-RAID 1) 1Gbit NIC I split it into 2 parts, I gave 25gb ram to the main server and 20gb ram to the postgresql server. I’m not sure if I configured it well this way. And sometimes I wonder if I should switch to cloud server. So I don’t want to spend too much money when there is a more suitable solution. What do you think the best server features should be for a population of 1000-5000 users at a time?

Are you going to have 5000 users active at once?

I assume this will happen. Of course, this may change. For example, when there is a panel on TV where people can ask questions and the presenters can see these questions, will it be able to handle this kind of traffic? This is a forward-looking thought, I want to make sure now.

Which is more performant: A separate PostgreSQL server? Or local PostgreSQL?

Development

Isambard (Isambard) July 2, 2024, 7:01pm 2

All else being equal, a local server would be more performant as you save on the inter-server communication overhead.

Topic		Replies	Views
How come the discourse server is so fast? Product Support	5	1633	October 18, 2015
How to optimize postgres and the discourse DB Product Support postgres	7	503	December 9, 2024
Is it possible to use two servers for same domain or database clone? Self-hosting	2	894	February 25, 2022
Should I change the value of db_shared_buffers and UNICORN_WORKERS with a multi discourses server? Product Support	2	701	December 14, 2020
Multiple Daily Backups Product Support	14	1740	December 14, 2021

Which is more performant: A separate PostgreSQL server? Or local PostgreSQL?

Related topics