Re: Hardware recommendations to scale to silly load
От | Vivek Khera |
---|---|
Тема | Re: Hardware recommendations to scale to silly load |
Дата | |
Msg-id | x7d6ejb2c0.fsf@yertle.int.kciLink.com обсуждение исходный текст |
Ответ на | Re: Hardware recommendations to scale to silly load ("Matt Clark" <matt@ymogen.net>) |
Ответы |
Re: Hardware recommendations to scale to silly load
|
Список | pgsql-performance |
>>>>> "MC" == Matt Clark <matt@ymogen.net> writes: MC> And concurrency is very high, because it's a web app, and each MC> httpd has one connection to PG, and there can be hundreds of MC> active httpd processes. Some kind of connection pooling scheme MC> might be in order when there are that many active clients. Any One thing you really should do (don't know if you already do it...) is have your web split into a front-end proxy and a back-end application server. There are lots of docs on how to do this for mod_perl, but it can apply to just about any backend technology that is pooling the connections. With a setup like this, my front-end web server typically has about 100 to 150 connections, and the backend doing the dynamic work (and accessing the database) has peaked at 60 or so. Usually the backend numbers at about 25. The front-end small processes get to deal with your dialup customers trickling down the data since it buffers your backend for you. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D. Khera Communications, Inc. Internet: khera@kciLink.com Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/
В списке pgsql-performance по дате отправления: