Re: [GENERAL] Maximum of connections in PG - Mailing list pgsql-general

From Adrian Klaver
Subject Re: [GENERAL] Maximum of connections in PG
Date
Msg-id 9ff5f544-4689-6aae-b5d7-c1deae4c6cbb@aklaver.com
Whole thread Raw
In response to [GENERAL] Maximum of connections in PG  (Durumdara <durumdara@gmail.com>)
List pgsql-general
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@aklaver.com


pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: [GENERAL] Maximum of connections in PG
Next
From: Glyn Astill
Date:
Subject: Re: [GENERAL] Table not cleaning up drom dead tuples