On 03/14/2017 07:15 AM, Durumdara wrote:
Dear Members! In a very strong Linux machine (with many 16-30 GB RAM) what is the limit of the PGSQL server (9.4-9.5) "maximum connections"? 1000? 2000? The clients are native applications (Windows executables) with persistent connections, with more than 100 databases (every client have only one database connection). Now we must determine where is the upper limit to know when we must buy a new machine to customers clients (which have to migrate in future). I know my question is too common without precise numbers, but what is I need is your experiences in this theme? What areas are problematic when we increase the "max_connection" number?
https://wiki.postgresql.org/wiki/Number_Of_Database_Connections
Thanks for any info! Best wishes dd
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general