cancel
Showing results for 
Search instead for 
Did you mean: 

How to Calculate max_connections and kernel parameter values

Question:

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:
https://www.postgresql.org/docs/9.5/kernel-re

 

Version history
Revision #:
4 of 4
Last update:
3 weeks ago
Updated by:
 
Labels (2)
Contributors