From owner-freebsd-hackers Fri Dec 14 9:34:23 2001 Delivered-To: freebsd-hackers@freebsd.org Received: from elvis.mu.org (elvis.mu.org [216.33.66.196]) by hub.freebsd.org (Postfix) with ESMTP id BAF0337B417 for ; Fri, 14 Dec 2001 09:34:17 -0800 (PST) Received: by elvis.mu.org (Postfix, from userid 1192) id 3BEC181D03; Fri, 14 Dec 2001 11:34:12 -0600 (CST) Date: Fri, 14 Dec 2001 11:34:12 -0600 From: Alfred Perlstein To: GB Clark II Cc: hackers@FreeBSD.ORG Subject: Re: shared mem and locking it in core (Database usage) Message-ID: <20011214113412.K79896@elvis.mu.org> References: <01121315261800.27037@prime.vsservices.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <01121315261800.27037@prime.vsservices.com>; from gclarkii@vsservices.com on Thu, Dec 13, 2001 at 03:26:18PM -0600 Sender: owner-freebsd-hackers@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG * GB Clark II [011214 06:28] wrote: > Hello, > > I'm running PostgreSQL and it uses SysV shared mem for alot of its functions. > > How can verify that the shared mem is wired and not pageable? > > sysctl settings: > kern.ipc.shmmax: 128004097 > kern.ipc.shmmin: 1 > kern.ipc.shmmni: 512 > kern.ipc.shmseg: 1024 > kern.ipc.shmall: 31251 > kern.ipc.shm_use_phys: 1 <- This wires the mem right? > > Yes postgres shows to be 119M via top, but is this mem wired? As long as you set the sysctl before starting postgresql, then yes. -- -Alfred Perlstein [alfred@freebsd.org] 'Instead of asking why a piece of software is using "1970s technology," start asking why software is ignoring 30 years of accumulated wisdom.' http://www.morons.org/rants/gpl-harmful.php3 To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-hackers" in the body of the message