SUB # How to configure / calculate the semaphore related values while making changes to max_connections - Mailing list pgsql-novice

From gk chinna
Subject SUB # How to configure / calculate the semaphore related values while making changes to max_connections
Date
Msg-id CAFGxe6WyL-zU0tHbChLN1vsTu7uADL=JF1bKBryuzzgtEVWUog@mail.gmail.com
Whole thread Raw
List pgsql-novice
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.

pgsql-novice by date:

Previous
From: Paul Linehan
Date:
Subject: Re: Generate a series of single days from a table of intervals.
Next
From: Steve Baldwin
Date:
Subject: Explanation of pg_column_size