Re: initdb profiles

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: initdb profiles
Дата
Msg-id
2108.1126143433@sss.pgh.pa.us
Ответ на
Re: initdb profiles (Andrew Dunstan)
Список
Дерево обсуждения
Re: initdb profiles Andrew - Supernews <andrew+nonews@supernews.com>
Andrew Dunstan  writes:
> I accept the "run from init.d" argument. So then, is there a case for 
> increasing the limits that initdb works with, to reflect the steep rise 
> we have seen in typically available memory at the low end?

I can't see any particular harm in having initdb try somewhat-larger
values ... but how far does that really go towards fixing the issues?

Personally, the default value I currently see as far too tight is
max_fsm_pages.  I'd rather see initdb trying to push that up if it's
able to establish shared_buffers and max_connections at their current
maxima.

> ... it would be nice to try to allow 
> one connection per standard allowed apache client (default is 256 
> non-threaded and 400 threaded, I think).

That's a mostly independent consideration, but it seems fair enough.
Can we check the exact values rather than relying on "I think"?
		regards, tom lane

В списке pgsql-hackers по дате отправления
От: Peter Eisentraut
Дата:
Сообщение: Re: initdb profiles
От: Peter Eisentraut
Дата:
Сообщение: Re: pg_config/share_dir
FAQ