| From: | "Isak Hansen" <isak(dot)hansen(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: shmget fails on OS X with proper settings |
| Date: | 2007-05-07 12:50:42 |
| Message-ID: | 6b9e1eb20705070550u32d131b9oc2f7579cfb21d85c@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Bah, evil google interface. My reply was ment for the list.
On 5/7/07, Isak Hansen <isak(dot)hansen(at)gmail(dot)com> wrote:
> On 5/7/07, Christopher S Martin <martin(dot)christopher(dot)s(at)gmail(dot)com> wrote:
> > sysctl -a reveals the following:
> > kern.sysv.shmmax: 12582912
>
> Maximum size of shared memory segment (afaik bytes - needs to be a
> multiple of 4096).
>
> > kern.sysv.shmall: 1024
>
> Total amount of shared memory available (afaik pages of 4k).
>
>
> Shouldn't matter how large you make shmmax if there's not enough
> shared memory to allocate chunks from.
>
>
> My settings:
> kern.sysv.shmmax: 134217728
> kern.sysv.shmmin: 1
> kern.sysv.shmmni: 32
> kern.sysv.shmseg: 8
> kern.sysv.shmall: 32768
>
> and shared_buffers = 80MB. Probably a bit excessive for my dev box, but..
>
>
> HTH,
> Isak
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sinead O Brien | 2007-05-07 13:23:01 | Re: did not find any relation for existing table |
| Previous Message | Christopher S Martin | 2007-05-07 11:59:44 | Re: shmget fails on OS X with proper settings |