Re: [GENERAL] settings for 8.2.5 on Mac OS X 10.4.11

2007-12-21 Thread Erik Jones
On Dec 21, 2007, at 2:12 AM, Wolfgang Keller wrote: The best thing is to fix the OS' ridiculously small shmem limits. I've got this in /etc/sysctl.conf: kern.sysv.shmmax=33554432 kern.sysv.shmmin=1 kern.sysv.shmmni=32 kern.sysv.shmseg=8 kern.sysv.shmall=8192 Dependency on the available RAM?

Re: [GENERAL] settings for 8.2.5 on Mac OS X 10.4.11

2007-12-21 Thread Wolfgang Keller
The best thing is to fix the OS' ridiculously small shmem limits. I've got this in /etc/sysctl.conf: kern.sysv.shmmax=33554432 kern.sysv.shmmin=1 kern.sysv.shmmni=32 kern.sysv.shmseg=8 kern.sysv.shmall=8192 Dependency on the available RAM? and on a production DB you'd probably want shmmax and

Re: [GENERAL] settings for 8.2.5 on Mac OS X 10.4.11

2007-12-14 Thread Tom Lane
Matthew Hixson <[EMAIL PROTECTED]> writes: > What are good settings for shared_buffers and max_connections with > the above software combo? Out of the box I'm getting the "Cannot > allocate memory" message upon doing a 'make check'. The best thing is to fix the OS' ridiculously small shmem li

[GENERAL] settings for 8.2.5 on Mac OS X 10.4.11

2007-12-14 Thread Matthew Hixson
What are good settings for shared_buffers and max_connections with the above software combo? Out of the box I'm getting the "Cannot allocate memory" message upon doing a 'make check'. Thanks, -M@ ---(end of broadcast)--- TIP 1: if posting/