| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Bill Moran <wmoran(at)collaborativefusion(dot)com> |
| Cc: | Christiaan Willemsen <cwillemsen(at)technocon(dot)com>, 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 16:26:37 |
| Message-ID: | 20496.1227025597@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Bill Moran <wmoran(at)collaborativefusion(dot)com> writes:
> 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:
I'm wondering about the shmall setting myself. The Postgres docs
suggest that FreeBSD measures shmall in pages. If so, the above
setting is far too large and is perhaps resulting in an internal
overflow in the kernel.
(For that matter, are you certain that shmmax can be set beyond
2G either? It might only be int inside the kernel.)
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christiaan Willemsen | 2008-11-18 16:29:25 | Re: FreeBSD 7 needing to allocate lots of shared memory |
| Previous Message | Flavio Palumbo | 2008-11-18 16:21:00 | Re: strange commit behavior |