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

**URL:** <https://meta.discourse.org/t/which-is-more-performant-a-separate-postgresql-server-or-local-postgresql/314659>\
**Category:** Development\
**Tags:** postgres\
**Created:** [July 2, 2024, 6:31pm UTC](https://meta.discourse.org/t/which-is-more-performant-a-separate-postgresql-server-or-local-postgresql/314659 "2024-07-02T18:31:06Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![kuaza](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/kuaza/32/264151_2.png) [@kuaza](https://meta.discourse.org/u/kuaza)\
**Post date:** [July 9, 2024, 7:07pm UTC](https://meta.discourse.org/t/which-is-more-performant-a-separate-postgresql-server-or-local-postgresql/314659/3 "2024-07-09T19:07:20Z")

</div>

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?

---

_[View the full topic](https://meta.discourse.org/t/which-is-more-performant-a-separate-postgresql-server-or-local-postgresql/314659)._
