Re: Can postgresql accept mutliple connections in the same instance? - Mailing list pgsql-hackers

From Zeugswetter Andreas DAZ SD
Subject Re: Can postgresql accept mutliple connections in the same instance?
Date
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA40184D23B@m0114.s-mxs.net
Whole thread Raw
In response to Can postgresql accept mutliple connections in the same instance?  (Dru <andru@treshna.com>)
Responses Re: Can postgresql accept mutliple connections in the same
List pgsql-hackers
>> I am running of postgresql database servers with generally 30-50 users
>> at a time per server.   I have noticed one thing for web based databases
>> that they fail to initialse a pg_connection connection every now and
>> again and return no error message at all.

I am thinking of the PG_SOMAXCONN maximum connects in the queue
of the listen socket. That would only be visible to the client app,
and would mainly happen when load is high so that postmaster cannot fork
new backends fast enough. And if the client does not properly report ...
IIRC some systems have a max of 5.

Andreas


pgsql-hackers by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Adding a suffix array index
Next
From: "Joshua D. Drake"
Date:
Subject: Re: [Plperlng-devel] Re: Concern about new PL/Perl