OpenVZ & PostgreSQL: shmpages, shared_buffers, kernel.shmmax [message #33801] |
Tue, 11 November 2008 09:16 |
cadiolis
Messages: 2 Registered: June 2008
|
Junior Member |
|
|
Hi everyone, I am wondering if someone can shed some light on some of the various settings required for running PostgreSQL on OpenVZ
We have a server that has 8GB of ram that is running just one container that has Postgres. I have been trying in vain to figure out some of the above settings
I have read this page (http://wiki.openvz.org/Postgresql_and_shared_memory) but haven't gotten to far. From what I can tell there are 4 adjustments that need to be made
- /sbin/sysctl kernel.shmmax in the host node
- /sbin/sysctl kernel.shmmax in the VE
- shmpages for the VE
- shared_buffers in PostgreSQL
Can someone give me some pointers on what kinda values I should be putting in here? Does the shmmax in the host node need to be set the highest, and then each of the other values set to lower amounts? How much can I set for shmpages and shmmax? We would like to give as much of the 8GB as possible
Regards,
Collin
|
|
|