From owner-freebsd-stable@FreeBSD.ORG  Wed Mar 12 21:57:18 2008
Return-Path: <owner-freebsd-stable@FreeBSD.ORG>
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 44BEA1065670
	for <freebsd-stable@freebsd.org>; Wed, 12 Mar 2008 21:57:18 +0000 (UTC)
	(envelope-from bright@elvis.mu.org)
Received: from elvis.mu.org (elvis.mu.org [192.203.228.196])
	by mx1.freebsd.org (Postfix) with ESMTP id 3C07C8FC1F
	for <freebsd-stable@freebsd.org>; Wed, 12 Mar 2008 21:57:18 +0000 (UTC)
	(envelope-from bright@elvis.mu.org)
Received: by elvis.mu.org (Postfix, from userid 1192)
	id 9315D1A4D8B; Wed, 12 Mar 2008 14:56:24 -0700 (PDT)
Date: Wed, 12 Mar 2008 14:56:24 -0700
From: Alfred Perlstein <alfred@freebsd.org>
To: Ivan Voras <ivoras@freebsd.org>
Message-ID: <20080312215624.GR67856@elvis.mu.org>
References: <fr69hn$q0o$1@ger.gmane.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <fr69hn$q0o$1@ger.gmane.org>
User-Agent: Mutt/1.4.2.3i
Cc: freebsd-stable@freebsd.org
Subject: Re: Approaching the limit on PV entries
X-BeenThere: freebsd-stable@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Production branch of FreeBSD source code <freebsd-stable.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>, 
	<mailto:freebsd-stable-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-stable>
List-Post: <mailto:freebsd-stable@freebsd.org>
List-Help: <mailto:freebsd-stable-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>,
	<mailto:freebsd-stable-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 12 Mar 2008 21:57:18 -0000

* Ivan Voras <ivoras@freebsd.org> [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



-- 
- Alfred Perlstein