Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

[NOVICE] SUB # How to configure / calculate the semaphore related values while making changes to max_connections

1 view

Skip to first unread message

gk chinna

unread,

Jul 27, 2016, 7:47:59 PM7/27/16

Hi Team,

I want to increase the max_connections on postgresql 9.4 , when going to change the max_connections , i believe we need to consider changing the work_mem and kernel semaphore , file descriptor values as well .

At present , i have kernel.sem set to value 250 32000 100 128 , and in google found someone suggesting the value of kernel.sem = 4096 512000 1600 2048 .

Is there any way to calculate these values ? Is it really necessary to modify ? I believe it is necessary to modify the semaphore values as this is playing role in communicating between the processes .

Your help in this regards is highly appreciated , thanks in advance for spending your valuable time to help me.

0 new messages