Re: refusing connections based on load ...

Поиск
Список
Период
Сортировка
От Lincoln Yeoh
Тема Re: refusing connections based on load ...
Дата
Msg-id 3.0.5.32.20010424123929.00d85100@192.228.128.13
обсуждение исходный текст
Ответ на refusing connections based on load ...  (The Hermit Hacker <scrappy@hub.org>)
Ответы Re: Re: refusing connections based on load ...  (ncm@zembu.com (Nathan Myers))
Список pgsql-hackers
At 03:09 PM 23-04-2001 -0300, you wrote:
>
>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 ...

Sorry, but I still don't understand the reasons why one would want to do
this. Could someone explain?

I'm thinking that if I allow 256 clients, and my hardware/OS bogs down when
60 users are doing lots of queries, I either accept that, or figure that my
hardware/OS actually can't cope with that many clients and reduce the max
clients or upgrade the hardware (or maybe do a little tweaking here and
there).

Why not be more deterministic about refusing connections and stick to
reducing max clients? If not it seems like a case where you're promised
something but when you need it, you can't have it. 

Cheerio,
Link.





В списке pgsql-hackers по дате отправления:

Предыдущее
От: The Hermit Hacker
Дата:
Сообщение: Re: refusing connections based on load ...
Следующее
От: Doug McNaught
Дата:
Сообщение: Re: refusing connections based on load ...