Обсуждение: Increasing Shared Memory - on MacOS X
Hi guys, does anybody know how I can increase the shared memory under MacOS X? I have tried but gotten an error message, telling me that it's too much. (PostgreSQL 7.2RC1). Best regards, Chris -- Chris Ruprecht Network grunt and bit pusher extraordinaíre _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com
You need to increase SHMMAX. For solaris, it's in /etc/system file; Linux: /etc/sysctl.conf. You should know corresponding file for your system or check with your SA to figure out. Anna Zhang -----Original Message----- From: Chris Ruprecht [mailto:chrup999@yahoo.com] Sent: Thursday, January 24, 2002 2:10 PM To: PostGreSQL Admin Group Subject: [ADMIN] Increasing Shared Memory - on MacOS X Hi guys, does anybody know how I can increase the shared memory under MacOS X? I have tried but gotten an error message, telling me that it's too much. (PostgreSQL 7.2RC1). Best regards, Chris -- Chris Ruprecht Network grunt and bit pusher extraordinaíre _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
At 14:21 -0500 01/24/2002, Zhang, Anna wrote: >You need to increase SHMMAX. For solaris, it's in /etc/system file; Linux: >/etc/sysctl.conf. You should know corresponding file for your system or >check with your SA to figure out. I have this well under control on my production server (Linux) with /sbin/sysctl. I am doing development on a PowerBook G4 running MacOS X 10.1.2 and I have tried to up the shared memory on the postgres.conf file. I have it at 256 8K blocks and it's working, but it's pretty slow. When I try and specify more memory (512 8K Blocks or more), I get an error, telling me that the system is not allowing more. I can not ask my SA, I AM the SA ;-). And there are no recognizable files in or around the /etc directory, I can modify. MacOS X has the sysctl command, but there is no kern.shmmax parameter to read or set. This is a MacOS X SPECIFIC question, and solutions for other UNIXen don't quite apply. I checked on the web and any other available resource on this, but came up empty handed ... Best regards, Chris -- Chris Ruprecht Network grunt and bit pusher extraordinaíre _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com
Chris Ruprecht <chrup999@yahoo.com> writes: > I can not ask my SA, I AM the SA ;-). And there are no recognizable > files in or around the /etc directory, I can modify. MacOS X has the > sysctl command, but there is no kern.shmmax parameter to read or set. > This is a MacOS X SPECIFIC question, and solutions for other UNIXen > don't quite apply. Since OSX is basically BSD under the hood, I'd expect BSD-ish solutions to be the place to look. Our notes about BSD systems say that a kernel rebuild is the only way to alter SHMMAX on those kernels :-( regards, tom lane
see docs: http://www.postgresql.org/idocs/ under Administrator's Guide, section 3.5 Managing Kernel Resources. Anna Zhang -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us] Sent: Thursday, January 24, 2002 9:06 PM To: Chris Ruprecht Cc: PostGreSQL Admin Group Subject: Re: [ADMIN] Increasing Shared Memory - on MacOS X Chris Ruprecht <chrup999@yahoo.com> writes: > I can not ask my SA, I AM the SA ;-). And there are no recognizable > files in or around the /etc directory, I can modify. MacOS X has the > sysctl command, but there is no kern.shmmax parameter to read or set. > This is a MacOS X SPECIFIC question, and solutions for other UNIXen > don't quite apply. Since OSX is basically BSD under the hood, I'd expect BSD-ish solutions to be the place to look. Our notes about BSD systems say that a kernel rebuild is the only way to alter SHMMAX on those kernels :-( regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly
Hi Chad, good try, but there is unfortunately no parameter related to memory. sysctl -a displays all of the parameters and their current settings, nothing amongst them which looks like it's of help here. Thanks for the help, I guess, I have to see if I can talk to somebody @ Apple or one of the darwin developer's groups. Best regards, Chris At 21:19 -0700 01/25/2002, Chad R. Larson wrote: >At 09:06 PM 1/24/02 -0500, Tom Lane wrote: >>Since OSX is basically BSD under the hood, I'd expect BSD-ish >>solutions to be the place to look. Our notes about BSD systems say >>that a kernel rebuild is the only way to alter SHMMAX on those >>kernels :-( > > >OS/X is FreeBSD, with a MACH kernel and Aqua as a window manager >(pretty much). > >I don't know enough about tuning the MACH kernel, but on a pure >FreeBSD system you can use "sysctl" to change the variable >"kernel.ipc.shmmax" on the fly to whatever you think makes sense. > > > -crl >-- >Chad R. Larson (CRL22) chad@eldocomp.com > Eldorado Computing, Inc. 602-604-3100 > 5353 North 16th Street, Suite 400 > Phoenix, Arizona 85016-3228 -- Chris Ruprecht Network grunt and bit pusher extraordinaíre _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com
Chris- This thread from Darwin might help you identify someone who is in the know about shared memory: http://www.darwinfo.org/devlist.php3?number=1385 -Nick -------------------------------------------------------------------------- Nick Fankhauser nickf@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ > -----Original Message----- > From: pgsql-admin-owner@postgresql.org > [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Chris Ruprecht > Sent: Saturday, January 26, 2002 11:12 AM > To: Chad R. Larson > Cc: PostGreSQL Admin Group > Subject: Re: [ADMIN] Increasing Shared Memory - on MacOS X > > > Hi Chad, > > good try, but there is unfortunately no parameter related to memory. > sysctl -a displays all of the parameters and their current settings, > nothing amongst them which looks like it's of help here. > > Thanks for the help, I guess, I have to see if I can talk to somebody > @ Apple or one of the darwin developer's groups. > > Best regards, > Chris > > At 21:19 -0700 01/25/2002, Chad R. Larson wrote: > >At 09:06 PM 1/24/02 -0500, Tom Lane wrote: > >>Since OSX is basically BSD under the hood, I'd expect BSD-ish > >>solutions to be the place to look. Our notes about BSD systems say > >>that a kernel rebuild is the only way to alter SHMMAX on those > >>kernels :-( > > > > > >OS/X is FreeBSD, with a MACH kernel and Aqua as a window manager > >(pretty much). > > > >I don't know enough about tuning the MACH kernel, but on a pure > >FreeBSD system you can use "sysctl" to change the variable > >"kernel.ipc.shmmax" on the fly to whatever you think makes sense. > > > > > > -crl > >-- > >Chad R. Larson (CRL22) chad@eldocomp.com > > Eldorado Computing, Inc. 602-604-3100 > > 5353 North 16th Street, Suite 400 > > Phoenix, Arizona 85016-3228 > > > -- > Chris Ruprecht > Network grunt and bit pusher extraordinaíre > _________________________________________________________ Do You > Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org >
At 09:06 PM 1/24/02 -0500, Tom Lane wrote: >Since OSX is basically BSD under the hood, I'd expect BSD-ish solutions to >be the place to look. Our notes about BSD systems say that a kernel >rebuild is the only way to alter SHMMAX on those kernels :-( OS/X is FreeBSD, with a MACH kernel and Aqua as a window manager (pretty much). I don't know enough about tuning the MACH kernel, but on a pure FreeBSD system you can use "sysctl" to change the variable "kernel.ipc.shmmax" on the fly to whatever you think makes sense. -crl -- Chad R. Larson (CRL22) chad@eldocomp.com Eldorado Computing, Inc. 602-604-3100 5353 North 16th Street, Suite 400 Phoenix, Arizona 85016-3228