Re: FreeBSD 7 needing to allocate lots of shared memory

From: Christiaan Willemsen <cwillemsen(at)technocon(dot)com>
To: Bill Moran <wmoran(at)collaborativefusion(dot)com>
Cc: Isak Hansen <isak(dot)hansen(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: FreeBSD 7 needing to allocate lots of shared memory
Date: 2008-11-18 13:05:59
Message-ID: 4922BDB7.2020601@technocon.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)technocon(dot)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.
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2008-11-18 13:25:30 Re: strange commit behavior
Previous Message Bill Moran 2008-11-18 13:02:43 Re: FreeBSD 7 needing to allocate lots of shared memory