Re: [GENERAL] Maximum of connections in PG

Dear Melvin!

What is the meaning of PgBouncer with persistent, non-interruptable connections? To I know it (for learn).

They are non web connections (request, get connection, result, drop connection), they are pure, native applications which are keeping connection from the start to the termination.

Thank you!

dd

2017-03-14 15:29 GMT+01:00 Melvin Davidson <melvin6925@gmail.com>:

On Tue, Mar 14, 2017 at 10:15 AM, Durumdara <durumdara@gmail.com> 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?

Thanks for any info!

Best wishes

   dd

>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"?

It all depends on the amount of shared memory, which in turn is dependent on the O/S memory.

But if you are going to have thousands of users, you are better off using a connection pooler. My preference is for PgBouncer.
https://pgbouncer.github.io/

--

Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.