Re: Scaling postgres

Поиск
Список
Период
Сортировка
От Michael Loftis
Тема Re: Scaling postgres
Дата
Msg-id 3CB9DA71.9030706@wgops.com
обсуждение исходный текст
Ответ на Re: Scaling postgres  (Neil Conway <nconway@klamath.dyndns.org>)
Ответы OT: Re: Scaling postgres  (Sean Chittenden <sean@chittenden.org>)
Список pgsql-general
KEepAlives must be enabled on client and server, Netscape 4 doesn't do keep-alives, NS6 I don't know, mosta ll versions of MSIE do keep alive if the server allows them.

Martijn van Oosterhout wrote:
On Sat, Apr 13, 2002 at 08:45:56PM -0400, Neil Conway wrote:
On Sun, 14 Apr 2002 10:38:06 +1000
"Martijn van Oosterhout" <kleptog@svana.org> wrote:
Also, an idling client generally does not keep a connection open to the
Apache server. So if you have 800 people changing webpage once a minute,
you're really only going to be handling 15 processes at the same time.
This assumes you're not using KeepAlives, in which case an httpd child
will wait around for KeepAliveTimeout seconds before serving other
clients.

Hmm, the default is 15 seconds. So if you are expecting lots of short
transactions, this could blow out your connection count to 200 or so.
Depending on the situation I'd be tempted to drop that down since the costs
of setting up connections is much lower on a LAN than over the internet
(assuming he's running on a LAN).

But a valid point notheless...

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

Предыдущее
От: Michael Loftis
Дата:
Сообщение: Re: Scaling postgres
Следующее
От: Sean Chittenden
Дата:
Сообщение: OT: Re: Scaling postgres