freebsd stable - Mar 2008 - Approaching the limit on PV entries

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.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: OpenPGP digital signature
Url :
http://lists.freebsd.org/pipermail/freebsd-stable/attachments/20080311/b5baa425/signature.pgp

* 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