From owner-freebsd-questions Thu Dec 13 6:53: 4 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 7874937B419 for ; Thu, 13 Dec 2001 06:53: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 32536215; Thu, 13 Dec 2001 08:53:00 -0600 Message-ID: <3C18C3EC.581AD09A@jwebmedia.com> Date: Thu, 13 Dec 2001 09:06:19 -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: Michael Imamura Cc: freebsd-questions@FreeBSD.ORG Subject: Re: shmmax? References: 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 Mike, Thanks for the info. 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! Joe Michael Imamura wrote: > > On Thu, 13 Dec 2001, Joe Koenig wrote: > > I was reading over an article about optimizing PostgreSQL. The article > > is specific to RedHat Linux 7.1, and refers to the amount of shmmax (max > > shared memory). Is there a similiar setting for FreeBSD? Thanks, > > This can be adjusted in the kernel config; here are the appropriate lines > out of LINT: > > options SYSVSHM # include support for shared memory > options SHMMAXPGS=1025 # max amount of shared memory pages (4k on i386) > options SHMALL=1025 # max amount of shared memory (bytes) > options SHMMAX="(SHMMAXPGS*PAGE_SIZE+1)" > # max shared memory segment size (bytes) > options SHMMIN=2 # min shared memory segment size (bytes) > options SHMMNI=33 # max number of shared memory identifiers > options SHMSEG=9 # max shared memory segments per process > > Adjusting SHMMAXPGS and SHMALL seem to be the way to go; I've avoided > touching the other settings. > > - Michael Imamura zoogie@lugatgt.org > LUG@GT Web Guy http://www.lugatgt.org/ To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message