Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
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.