Re: Maximum number of client connection supported by Postgres 8.4.6

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Jenish Vyas *EXTERN*" <jenishvyas(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Maximum number of client connection supported by Postgres 8.4.6
Date: 2011-07-21 13:28:19
Message-ID: D960CB61B694CF459DCFB4B0128514C206ABA191@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jenish Vyaswrote:
> please let me know what is the maximum number of concurrent client
connection supported by Postgres
> 8.4.6
>
> max_connections = ????
>
> For my database,
>
> If I am running the test for more then 1000 concurrent active user it
is showing me error "running out
> of connection"
>
> I have set max_connections = 1200.

There is no error message "running out of connection" in the code base.
Could you quote the exact message?

Maybe you are hitting a kernel resource limit, see
http://www.postgresql.org/docs/8.4/static/kernel-resources.html
In that case you might have to increase SEMMNS or SEMMNI.

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rebecca Clarke 2011-07-21 13:53:53 Re: Error creating function
Previous Message Thomas Pasch 2011-07-21 13:20:23 Is there a way to 'unrestrict' drop view?