Re: max_connections/shared_buffers (was Re: Beta4 Tag'd and Bundled ...)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: max_connections/shared_buffers (was Re: Beta4 Tag'd and Bundled ...)
Дата
Msg-id 29409.1065461195@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: max_connections/shared_buffers (was Re: Beta4 Tag'd  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> Tom Lane writes:
>> Anyone see a better way?

> Maybe just run one loop and try pairs of (shared_buffers, max_connections):
> (1000, 100) (800, 50) (600, 40) (400, 30) (200, 20) (50, 10)

Hmm ... that wouldn't work real well as-is, because if max_connections
is being constrained by a limit on SysV semaphores, we could find
ourselves restricting shared_buffers to no purpose.

Would it work to loop as above, and then try a second loop in which we
use the selected max_connections and see if we can make shared_buffers
bigger?
        regards, tom lane


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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: max_connections/shared_buffers (was Re: Beta4 Tag'd
Следующее
От: Andrew Dunstan
Дата:
Сообщение: db encoding