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 ...
|
Список | 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 по дате отправления: