Maximum of connections in PG

From: Durumdara <durumdara(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Maximum of connections in PG
Date: 2017-03-14 14:15:01
Message-ID: CAEcMXhn3KiTCgTi7vZw9YFfQmYDsPcizNnoDv7EOGimNKsi7Gw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Thanks for any info!

Best wishes
dd

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Farber 2017-03-14 14:23:41 Re: UPDATE ... ON CONFLICT DO NOTHING
Previous Message Adrian Klaver 2017-03-14 14:10:58 Re: UPDATE ... ON CONFLICT DO NOTHING