Re: refusing connections based on load ...

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: refusing connections based on load ...
Date: 2001-04-23 20:00:19
Message-ID: 200104232000.PAA03076@jupiter.jw.home
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)Yahoo(dot)com #

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message August Zajonc 2001-04-23 20:45:25 Re: refusing connections based on load ...
Previous Message Jan Wieck 2001-04-23 19:55:01 RI oddness