Anyone thought of implementing this, similar to how sendmail does it? If
load > n, refuse connections?
Basically, if great to set max clients to 256, but if load hits 50 as a
result, the database is near to useless ... if you set it to 256, and 254
idle connections are going, load won't rise much, so is safe, but if half
of those processes are active, it hurts ...
so, if it was set so that a .conf variable could be set so that max
connection == 256 *or* load > n to refuse connections, you'd hvae best of
both worlds ...
sendmail does it now, and, apparently relatively portable across OSs ...
okay, just looked at the code, and its kinda painful, but its in
src/conf.c, as a 'getla' function ...
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 ...
pgsql-hackers by date
|Next:||From: Jan Wieck||Date: 2001-04-23 18:15:02|
|Subject: Re: RFC: planner statistics in 7.2|
|Previous:||From: Adam Rose||Date: 2001-04-23 17:29:54|
|Subject: Re: row name length|