Re: refusing connections based on load ...

>Nathan Myers wrote:
>> On Mon, Apr 23, 2001 at 03:09:53PM -0300, The Hermit Hacker wrote:
>> >
>> > Anyone thought of implementing this, similar to how sendmail does it?
If
>> > load > n, refuse connections?
>> > ...
>> > If nobody is working on something like this, does anyone but me feel
that
>> > it has merit to make use of?  I'll play with it if so ...
>>
>> I agree that it would be useful.  Even more useful would be soft load
>> shedding, where once some load average level is exceeded the postmaster
>> delays a bit (proportionately) before accepting a connection.
>
>    Or  have  the  load  check  on  AtXactStart,  and  delay  new
>    transactions  until  load  is  back  below  x,  where  x   is
>    configurable  per  user/group  plus some per database scaling
>    factor.

How is this different than limiting the number of backends that can be
running at once?  It would seem to me that a user that has a "delayed"
startup is going to think there's something wrong with the server and keep
trying, where as a message like "too many clients - try again later"
explains what's really going on.

len morgan