From owner-freebsd-questions  Thu Dec 13  6:48:32 2001
Delivered-To: freebsd-questions@freebsd.org
Received: from acmex.gatech.edu (acmex.gatech.edu [130.207.165.22])
	by hub.freebsd.org (Postfix) with ESMTP id 3087F37B405
	for <freebsd-questions@FreeBSD.ORG>; Thu, 13 Dec 2001 06:48:30 -0800 (PST)
Received: by acmex.gatech.edu (Postfix, from userid 19753)
	id 9BAA01DFAD; Thu, 13 Dec 2001 09:48:29 -0500 (EST)
Received: from localhost (localhost [127.0.0.1])
	by acmex.gatech.edu (Postfix) with ESMTP
	id 94FD61F170; Thu, 13 Dec 2001 14:48:29 +0000 (EDT)
Date: Thu, 13 Dec 2001 14:48:29 +0000 (EDT)
From: Michael Imamura <gte255n@prism.gatech.edu>
X-Sender: gte255n@acmex.gatech.edu
To: Joe Koenig <joe@jwebmedia.com>
Cc: freebsd-questions@FreeBSD.ORG
Subject: Re: shmmax?
In-Reply-To: <3C18B398.CFCE144A@jwebmedia.com>
Message-ID: <Pine.SOL.4.21.0112131443180.9407-100000@acmex.gatech.edu>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
Sender: owner-freebsd-questions@FreeBSD.ORG
Precedence: bulk
List-ID: <freebsd-questions.FreeBSD.ORG>
List-Archive: <http://docs.freebsd.org/mail/> (Web Archive)
List-Help: <mailto:majordomo@FreeBSD.ORG?subject=help> (List Instructions)
List-Subscribe: <mailto:majordomo@FreeBSD.ORG?subject=subscribe%20freebsd-questions>
List-Unsubscribe: <mailto:majordomo@FreeBSD.ORG?subject=unsubscribe%20freebsd-questions>
X-Loop: FreeBSD.ORG


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