Re: [GENERAL] FreeBSD 7 needing to allocate lots of shared memory

Christiaan Willemsen <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> 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.

Re: [GENERAL] FreeBSD 7 needing to allocate lots of shared memory

Hello Shane, All settings are as expected by both sysctl.conf and loader.conf Shane Ambler wrote: Christiaan Willemsen wrote: Bill Moran wrote: In response to Christiaan Willemsen <[EMAIL PROTECTED]>: #sysctl -a | grep shm kern.ipc.shm_allow_removed: 0 kern.ipc.shm_use_phys: 1 kern.ipc.sh

Re: [GENERAL] FreeBSD 7 needing to allocate lots of shared memory

Christiaan Willemsen wrote: Bill Moran wrote: In response to Christiaan Willemsen <[EMAIL PROTECTED]>: #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: 68719

Re: [GENERAL] FreeBSD 7 needing to allocate lots of shared memory

Hi Tom, Tom Lane wrote: 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. Hmm, might be.. I can try lowering the value, but

Re: [GENERAL] FreeBSD 7 needing to allocate lots of shared memory

Bill Moran <[EMAIL PROTECTED]> writes: > In response to Christiaan Willemsen <[EMAIL PROTECTED]>: >> #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.s

Re: [GENERAL] FreeBSD 7 needing to allocate lots of shared memory

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 <[EMAIL PROTECTED]>: #sysctl -a | grep shm kern.ipc.s

Re: [GENERAL] FreeBSD 7 needing to allocate lots of shared memory

In response to Christiaan Willemsen <[EMAIL PROTECTED]>: > #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

Re: [GENERAL] FreeBSD 7 needing to allocate lots of shared memory

#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 Isak Hansen wrote: On Mon, Nov 17, 2008 at 12:11 PM, Christiaan Willemsen <[EMAIL PROTECTED]> wrote:

Re: [GENERAL] FreeBSD 7 needing to allocate lots of shared memory

On Mon, Nov 17, 2008 at 12:11 PM, Christiaan Willemsen <[EMAIL PROTECTED]> wrote: > Yes, I did ;) > Still the same error, i.e. unable to allocate shared memory? What does "sysctl -a | grep shm" say? Isak -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to y

Re: [GENERAL] FreeBSD 7 needing to allocate lots of shared memory

Yes, I did ;) Isak Hansen wrote: On Mon, Nov 17, 2008 at 12:03 PM, Isak Hansen <[EMAIL PROTECTED]> wrote: On Mon, Nov 17, 2008 at 9:51 AM, Christiaan Willemsen <[EMAIL PROTECTED]> wrote: I still would like to allocate a bit more than 1 Gb of shared_memory on FreeBSD. So if anyone has a

Re: [GENERAL] FreeBSD 7 needing to allocate lots of shared memory

On Mon, Nov 17, 2008 at 12:03 PM, Isak Hansen <[EMAIL PROTECTED]> wrote: > On Mon, Nov 17, 2008 at 9:51 AM, Christiaan Willemsen > <[EMAIL PROTECTED]> wrote: >> I still would like to allocate a bit more than 1 Gb of shared_memory on >> FreeBSD. So if anyone has any pointers what settings I do need

Re: [GENERAL] FreeBSD 7 needing to allocate lots of shared memory

On Mon, Nov 17, 2008 at 9:51 AM, Christiaan Willemsen <[EMAIL PROTECTED]> wrote: > I still would like to allocate a bit more than 1 Gb of shared_memory on > FreeBSD. So if anyone has any pointers what settings I do need to make, > please let me know. > Did you already try changing shmall as Martij

Re: [GENERAL] FreeBSD 7 needing to allocate lots of shared memory

I still would like to allocate a bit more than 1 Gb of shared_memory on FreeBSD. So if anyone has any pointers what settings I do need to make, please let me know. Kind regards, Christiaan Willemsen Christiaan Willemsen wrote: Yes, it is a 64 bit machine, I'm sure of that: file ../bin/post

Re: [GENERAL] FreeBSD 7 needing to allocate lots of shared memory

Yes, it is a 64 bit machine, I'm sure of that: file ../bin/postgres ../bin/postgres: ELF 64-bit LSB executable, x86-64, version 1 (FreeBSD), for FreeBSD 7.0 (700055), dynamically linked (uses shared libs), FreeBSD-style, not stripped I just set kern.ipc.shmall equal to kern.ipc.shmmax, still

Re: [GENERAL] FreeBSD 7 needing to allocate lots of shared memory

On Fri, Nov 14, 2008 at 01:56:31PM +0100, Christiaan Willemsen wrote: > I'm trying to get postgressql running on FreeBSD with 64 GB of memory. > Postgres will the the only thing running, so I want it to use as much > memory as needed. > > So I increased shared_memory to 50GB, and also set: Umm,

[GENERAL] FreeBSD 7 needing to allocate lots of shared memory

I'm trying to get postgressql running on FreeBSD with 64 GB of memory. Postgres will the the only thing running, so I want it to use as much memory as needed. So I increased shared_memory to 50GB, and also set: kern.ipc.semmni=512 kern.ipc.semmns=1024 kern.ipc.semmnu=512 in loader.conf and: