Re: refusing connections based on load ... - Mailing list pgsql-hackers

From Jan Wieck
Subject Re: refusing connections based on load ...
Date
Msg-id 200104232000.PAA03076@jupiter.jw.home
Whole thread Raw
In response to Re: refusing connections based on load ...  (ncm@zembu.com (Nathan Myers))
List pgsql-hackers
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.
 


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com



pgsql-hackers by date:

Previous
From: Jan Wieck
Date:
Subject: RI oddness
Next
From: Peter Eisentraut
Date:
Subject: Re: SET SESSION AUTHORIZATION (was Re: Real/effective user)