Re: default resource limits

Поиск
Список
Период
Сортировка
От daveg
Тема Re: default resource limits
Дата
Msg-id 20051223222256.GA28050@sonic.net
обсуждение исходный текст
Ответ на default resource limits  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: default resource limits  (Andrew Dunstan <andrew@dunslane.net>)
Re: default resource limits  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
On Fri, Dec 23, 2005 at 03:38:56PM -0500, Andrew Dunstan wrote:
> >
> >What numbers would you like? If what I suggested seems odd, how about
> >targets of 400 connections, 4000 shared_buffers and 200,000
> >max_fsm_pages?
>
>
> Here's a patch that does what I had in mind. On my modest workstation it
> tops out at 400 connections and 2500/125000
> shared_buffers/max_fsm_pages. An idle postmaster with these settings
> consumed less than 4% of the 380Mb of memory, according to top, making
> it still dwarfed by X, mozilla, apache and amavisd among other memory hogs.

I don't understand the motivation for so many connections by default, it
seems wasteful in most cases.

-dg

--
David Gould                      daveg@sonic.net
If simplicity worked, the world would be overrun with insects.

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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: default resource limits
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: default resource limits