Search Postgresql Archives

Re: Maximum of connections in PG

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux