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
Ответ на
Список
Дерево обсуждения
FreeBSD 7 needing to allocate lots of shared memory Christiaan Willemsen <cwillemsen@technocon.com>
Re: FreeBSD 7 needing to allocate lots of shared memory Martijn van Oosterhout <kleptog@svana.org>
Re: FreeBSD 7 needing to allocate lots of shared memory Christiaan Willemsen <cwillemsen@technocon.com>
Re: FreeBSD 7 needing to allocate lots of shared memory Christiaan Willemsen <cwillemsen@technocon.com>
Re: FreeBSD 7 needing to allocate lots of shared memory "Isak Hansen" <isak.hansen@gmail.com>
Re: FreeBSD 7 needing to allocate lots of shared memory "Isak Hansen" <isak.hansen@gmail.com>
Re: FreeBSD 7 needing to allocate lots of shared memory Christiaan Willemsen <cwillemsen@technocon.com>
Re: FreeBSD 7 needing to allocate lots of shared memory "Isak Hansen" <isak.hansen@gmail.com>
Re: FreeBSD 7 needing to allocate lots of shared memory Christiaan Willemsen <cwillemsen@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 Tom Lane <tgl@sss.pgh.pa.us>
Re: FreeBSD 7 needing to allocate lots of shared memory Christiaan Willemsen <cwillemsen@technocon.com>
Re: FreeBSD 7 needing to allocate lots of shared memory Tom Lane <tgl@sss.pgh.pa.us>
Re: FreeBSD 7 needing to allocate lots of shared memory Christiaan Willemsen <cwillemsen@technocon.com>
Re: FreeBSD 7 needing to allocate lots of shared memory Shane Ambler <pgsql@Sheeky.Biz>
Re: FreeBSD 7 needing to allocate lots of shared memory Christiaan Willemsen <cwillemsen@technocon.com>
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:
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: 68719476736Try 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 по дате отправления