RFC on my SHM tunings for multiple jailed postgres...

2002-05-03 Thread Patrick Thomas
I have a large server that will be running ~24 jails, 8 of which will be running their own postgres server. Because of this fact: By default, Postgres allocates 34 semaphores, which is over half the default system total of 60. I need to tune kernel SHM settings in order to even run the second

Re: RFC on my SHM tunings for multiple jailed postgres...

2002-05-03 Thread Alfred Perlstein
* Patrick Thomas [EMAIL PROTECTED] [020503 00:38] wrote: I have a large server that will be running ~24 jails, 8 of which will be running their own postgres server. You should be aware of the kern.ipc.shm_use_phys sysctl, you might want to try flipping it on if you encounter problems as it

Re: RFC on my SHM tunings for multiple jailed postgres...

2002-05-03 Thread Alfred Perlstein
* Patrick Thomas [EMAIL PROTECTED] [020503 07:19] wrote: So kern.ipc.shm_use_phys=1 will give me more flexibility, but will slow down performance (vs. using kernel memory) ? It will not cause any problems unless you don't have enough memory. -- -Alfred Perlstein [[EMAIL PROTECTED]]