2 small or 1 big server?
I have a an fat Omnis client connecting to Postgresql. There are several databases at the same server (multi tenant). It is very fast and reliable.
Postgresql are limited to 100 concurrent sessions by “factory settings”
The server is no slowly reaching this limit by peaks. The goal is to add more tenants. Adding more sessions = more memory needed
My qualified guess is that adding pooling possibilities will not do this alone – (pgBouncer). Or?
I have two main options that for me are equal (= same cost and configuring time):
1. Expand the existing server by adding more RAM and CPU.
2. Add another small server for new tenants.
I know there is many of you that already have been there and done that. Hopefully you can share some tip or advice.
Which option is the best one? Regarding speed etc?
TIA for any input.
Manage your list subscriptions at lists.omnis-dev.com