Re: Can postgresql accept mutliple connections in the same instance?

From: "Zeugswetter Andreas DAZ SD" <ZeugswetterA(at)spardat(dot)at>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Dru" <andru(at)treshna(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Can postgresql accept mutliple connections in the same instance?
Date: 2004-11-19 13:38:59
Message-ID: 46C15C39FEB2C44BA555E356FBCD6FA40184D23B@m0114.s-mxs.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2004-11-19 14:58:39 Re: [Plperlng-devel] Re: Concern about new PL/Perl
Previous Message Oleg Bartunov 2004-11-19 13:35:06 Re: Adding a suffix array index