From owner-freebsd-questions Thu Dec 13 9:48: 6 2001 Delivered-To: freebsd-questions@freebsd.org Received: from email.accessus.net (email.accessus.net [209.145.128.5]) by hub.freebsd.org (Postfix) with ESMTP id BE42437B417 for ; Thu, 13 Dec 2001 09:48:01 -0800 (PST) Received: from [209.145.133.59] (account jkoenig@accessus.net HELO jwebmedia.com) by email.accessus.net (CommuniGate Pro SMTP 3.4.8) with ESMTP id 32566010 for freebsd-questions@FreeBSD.ORG; Thu, 13 Dec 2001 11:48:00 -0600 Message-ID: <3C18ECE9.D7E2AF57@jwebmedia.com> Date: Thu, 13 Dec 2001 12:01:12 -0600 From: Joe Koenig Reply-To: joe@jwebmedia.com Organization: jWeb X-Mailer: Mozilla 4.77 (Macintosh; U; PPC) X-Accept-Language: en MIME-Version: 1.0 To: freebsd-questions@FreeBSD.ORG Subject: Re: shmmax? (PostgreSQL Help Please) References: <3C18C3EC.581AD09A@jwebmedia.com> <20011213163813.D68324@pcwin002.win.tue.nl> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG This seemed like it was the best response I got but I have no /etc/sysctl.conf, but I did find that file in /usr/src/etc, so I edited that to include my change. I restarted my machine and the settings did not change. Even so, I was able to change shmall for the time being, changed postgres' shared_buffers to 15200 and postgres would not start until I uncommented the line. Anyone here experienced with optimizing postgres and would be able to help me get the shared_buffers of postgres up? Thanks, Joe Stijn Hoop wrote: > > On Thu, Dec 13, 2001 at 09:06:19AM -0600, Joe Koenig wrote: > > I checked my LINT file and I've got the same SHMALL=1025. Doesn't that > > seem awefully small? My system as 1G of RAM and the article on > > optimizing postgresql recommended 128M for a system with 512M total. Any > > idea on a reasonable setting for SHMMAXPGS. Also, does the kernel need > > to be re-built and installed after changing this file, or will a reboot > > do the trick? I was reading about creating a custom kernel and in there > > is the option to use or not use shared memory, but nothing about the > > LINT file was ever mentioned. I didn't know if those values got built > > into the kernel on a make, or if they were read in at reboot. Any > > information is appreciated. Thanks! > > You can check on your defaults with sysctl: > > [stijn@pcwin002] <~> sysctl -a | grep shm > kern.ipc.shmmax: 33554432 > kern.ipc.shmmin: 1 > kern.ipc.shmmni: 192 > kern.ipc.shmseg: 128 > kern.ipc.shmall: 8192 > kern.ipc.shm_use_phys: 0 > > You can change them at runtime using sysctl -w: > > [stijn@pcwin002] <~> sudo sysctl -w kern.ipc.shmmin=1 > kern.ipc.shmmin: 1 -> 1 > > I'm not sure if all these values can be tuned however. > > Put changes in /etc/sysctl.conf to keep them permanent. > > HTH, > > --Stijn > > -- > "Linux has many different distributions, meaning that you can probably find > one that is exactly what you want (I even found one that looked like a Unix > system)." > -- Mike Meyer, freebsd-questions@freebsd.org, > in message <15252.28617.61423.224978@guru.mired.org> > > To Unsubscribe: send mail to majordomo@FreeBSD.org > with "unsubscribe freebsd-questions" in the body of the message To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message