Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group