From owner-freebsd-stable@FreeBSD.ORG Thu Mar 13 12:36:42 2008 Return-Path: Delivered-To: freebsd-stable@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id F02EA1065672 for ; Thu, 13 Mar 2008 12:36:42 +0000 (UTC) (envelope-from Stephen.Clark@seclark.us) Received: from smtpout10.prod.mesa1.secureserver.net (smtpout10-04.prod.mesa1.secureserver.net [64.202.165.238]) by mx1.freebsd.org (Postfix) with SMTP id AD5CB8FC1D for ; Thu, 13 Mar 2008 12:36:42 +0000 (UTC) (envelope-from Stephen.Clark@seclark.us) Received: (qmail 28694 invoked from network); 13 Mar 2008 12:10:02 -0000 Received: from unknown (24.144.77.185) by smtpout10-04.prod.mesa1.secureserver.net (64.202.165.238) with ESMTP; 13 Mar 2008 12:10:01 -0000 Message-ID: <47D91998.9030607@seclark.us> Date: Thu, 13 Mar 2008 08:10:00 -0400 From: Stephen Clark User-Agent: Thunderbird 2.0.0.12 (X11/20080226) MIME-Version: 1.0 To: Alfred Perlstein References: <20080312215624.GR67856@elvis.mu.org> In-Reply-To: <20080312215624.GR67856@elvis.mu.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cc: freebsd-stable@freebsd.org, Ivan Voras Subject: Re: Approaching the limit on PV entries X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: Stephen.Clark@seclark.us List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 13 Mar 2008 12:36:43 -0000 Alfred Perlstein wrote: > * Ivan Voras [080311 08:46] wrote: > >> During heavy postgresql load (pgbench), /var/log/messages registers >> (multiple times) the following message: >> >> "Approaching the limit on PV entries, consider increasing either the >> vm.pmap.shpgperproc or the vm.pmap.pv_entry_max sysctl" >> >> I'm increasing both, but no matter what I increase them to, after a >> short time they again get increased by the system (???). >> >> The values are currently: >> >> vm.pmap.shpgperproc: 1134 >> vm.pmap.pv_entry_max: 8000000 >> >> But the last sysctl setting, verified by retrieving it from my shell >> command line history, is that I set vm.pmap.shpgperproc to 800. >> >> Is this normal, and what are the common settings for these values? The >> machine is 2x4-core, currently 4 GB RAM (which will increase to at least >> 6 GB), amd64, running postgresql, php and apache. >> >> > > try setting: > > sysctl kern.ipc.shm_use_phys=1 > > > > Could you please explain what that does and why? Also could someone point me to where all these sysctls are documented other than in the source code - which lots of time has no explanation. It would really help the average sys admin/ user if these were documented. Thanks, Steve -- "They that give up essential liberty to obtain temporary safety, deserve neither liberty nor safety." (Ben Franklin) "The course of history shows that as a government grows, liberty decreases." (Thomas Jefferson)