| 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: | Whole Thread | Raw Message | 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.
>
>
| 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 |