Showing results for 
Search instead for 
Did you mean: 

How to Calculate max_connections and kernel parameter values


How we can calculate max_connections parameter value, if there is any formula to calculate?.
How much we need to set the kernel parameter value if we set the max_connections parameter to 1000?


Answer: There is no standard formula to calculate max_connections. It depends on the application, how many active connections you want to allow at any point of time. We generally recommend to use a connection pooler if the active connections go beyond 500. As the memory management will be good on the server if there is a connection pooler in between the application and database.

Please refer to the following link which gives information about setting kernel parameters that will affect Postgres:


Version history
Revision #:
4 of 4
Last update:
‎03-06-2019 11:55 AM
Updated by:
Labels (2)