Pgpool-II Configuration Parameters - reserved_connections
Pgpool-II is a feature-rich PostgreSQL cluster management tool. To determine which configuration is best for your database cluster, you need to understand the purpose of the parameters. Since this blog, I will introduce several effective parameters to improve performance. In this blog, I will explain reserved_connections parameter and how to configure this parameter. This parameter is used to refuse the incoming client connections with error message "Sorry, too many clients already" rather than block it, when the number of client connections exceeds the value of "num_init_children - reserved_connections" . First, let me describe why this parameter is added. Control of client connections in Pgpool-II 4.0 and earlier At startup, Pgpool-II parent process preforks num_init_children child processes, and each child process is waiting for a client connection. If the maximum number of concurrent client connections (the value of num_init_children ) has been reached, how...