Re: FreeBSD 7 needing to allocate lots of shared memory

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: FreeBSD 7 needing to allocate lots of shared memory
Дата
Msg-id 22121.1227031871@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: FreeBSD 7 needing to allocate lots of shared memory  (Christiaan Willemsen <cwillemsen@technocon.com>)
Список pgsql-general
Christiaan Willemsen <cwillemsen@technocon.com> writes:
> Tom Lane wrote:
>> I'm wondering about the shmall setting myself.  The Postgres docs
>> suggest that FreeBSD measures shmall in pages.  If so, the above
>> setting is far too large and is perhaps resulting in an internal
>> overflow in the kernel.
>>
> Hmm, might be.. I can try lowering the value, but if this is the problem
> what is max?

No idea, but I'd recommend setting it to physical RAM measured in pages.
Not sure what FreeBSD uses as page size though.

            regards, tom lane

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

Предыдущее
От: "Pavel Stehule"
Дата:
Сообщение: Re: Foreign Key 'walker'?
Следующее
От: "Phoenix Kiula"
Дата:
Сообщение: Any risks in using FUNCTIONs (stored procedures) instead of raw sql queries?