refusing connections based on load ...

Поиск
Список
Период
Сортировка
От The Hermit Hacker
Тема refusing connections based on load ...
Дата
Msg-id Pine.BSF.4.33.0104231503200.4451-100000@mobile.hub.org
обсуждение исходный текст
Ответы Re: refusing connections based on load ...  (ncm@zembu.com (Nathan Myers))
Re: refusing connections based on load ...  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: refusing connections based on load ...  (Lincoln Yeoh <lyeoh@pop.jaring.my>)
Список pgsql-hackers
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 по дате отправления:

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Re: RFC: planner statistics in 7.2
Следующее
От: ncm@zembu.com (Nathan Myers)
Дата:
Сообщение: Re: refusing connections based on load ...