Re: FreeBSD 7 needing to allocate lots of shared memory

Поиск
Список
Период
Сортировка
От Christiaan Willemsen
Тема Re: FreeBSD 7 needing to allocate lots of shared memory
Дата
Msg-id 4922BDB7.2020601@technocon.com
обсуждение исходный текст
Ответ на Re: FreeBSD 7 needing to allocate lots of shared memory  (Bill Moran <wmoran@collaborativefusion.com>)
Ответы Re: FreeBSD 7 needing to allocate lots of shared memory  (Shane Ambler <pgsql@Sheeky.Biz>)
Список pgsql-general
Hello Bill,

I have this one set to 512 in loader.conf
other params in loader.conf:

kern.ipc.semmni=1024
kern.ipc.semmns=1024
kern.ipc.semmnu=512

Kind regards,

Christiaan Willemsen

Bill Moran wrote:
In response to Christiaan Willemsen <cwillemsen@technocon.com>:
 
#sysctl -a | grep shm
kern.ipc.shm_allow_removed: 0
kern.ipc.shm_use_phys: 1
kern.ipc.shmall: 68719476736
kern.ipc.shmseg: 128
kern.ipc.shmmni: 192
kern.ipc.shmmin: 1
kern.ipc.shmmax: 68719476736   
Try bumping shmmni:
$ sysctl -d kern.ipc.shmmni
kern.ipc.shmmni: Number of shared memory identifiers

I have this set to 1000 on most of my systems.  Can't seem to find my
notes on it right now, but that may be your holdup.  The PG docs seem
to indicate that this number can be set very low, as PG only needs a
single identifier, but I must have had _some_ reason for raising it.
 

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

Предыдущее
От: Bill Moran
Дата:
Сообщение: Re: FreeBSD 7 needing to allocate lots of shared memory
Следующее
От: Gustavo Rosso
Дата:
Сообщение: Urgent - Grant