From owner-freebsd-stable Thu Jul 11 4:31:27 2002 Delivered-To: freebsd-stable@freebsd.org Received: from mx1.FreeBSD.org (mx1.FreeBSD.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 57CBD37B401 for ; Thu, 11 Jul 2002 04:31:25 -0700 (PDT) Received: from park.rambler.ru (park.rambler.ru [217.73.193.2]) by mx1.FreeBSD.org (Postfix) with ESMTP id 8D43A43E58 for ; Thu, 11 Jul 2002 04:31:23 -0700 (PDT) (envelope-from is@rambler-co.ru) Received: from is (is.stack.net [217.73.193.40]) by park.rambler.ru (8.11.6/8.9.3) with ESMTP id g6BBVJk92597; Thu, 11 Jul 2002 15:31:19 +0400 (MSD) (envelope-from is@rambler-co.ru) Date: Thu, 11 Jul 2002 15:31:19 +0400 (MSD) From: Igor Sysoev X-Sender: is@is To: Vince Vielhaber Cc: stable@FreeBSD.ORG Subject: Re: [GENERAL] was there a change in FreeBSD SHM implementation from 4.4 to 4.6? (postgres trouble) In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-stable@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG On Thu, 11 Jul 2002, Vince Vielhaber wrote: > On Thu, 11 Jul 2002, Igor Sysoev wrote: > > > > > Have you looked at the FreeBSD section here: > > > > > > > > > > http://www.postgresql.org/idocs/index.php?kernel-resources.html > > > > > > > > > > Most notably, I had to increase SHMMAXPGS on one of my FreeBSD machines. > > > > > There doesn't appear to be a sysctl variable for it. > > > > > > > > SHMMAXPGS is sysctl kern.ipc.shmmax. > > > > > > The kernel config has SHMMAX and SHMMAXPGS. > > > > Sorry, I'd meant "SHMMAXPGS is sysctl kern.ipc.shmall". > > Ok, but the kernel config has SHMALL as well. Is one (or more) > of the kernel options unused? The most priority has setting of kern.ipc.shmall. Next is 'options SHMALL' and next is 'options SHMMAXPGS'. If you do not define SHMALL then it will be equal to SHMMAXPGS. And as far as I know you need to set kern.ipc.shmall before any use of shared memory. You can not change it after use. The best place for kern.ipc.shmall setting is /etc/sysctl.conf. Setting in /boot/loader.conf is helpless. Igor Sysoev http://sysoev.ru To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-stable" in the body of the message