Maximum Number of Connections

If the number of GaussDB connections is too large, excessive server resources are consumed and the operation response becomes slow. You can optimize the following parameters. For details, see Connection Settings.

• max_connections: maximum number of concurrent connections to the database. This parameter affects the concurrency capability of the cluster.
• max_inner_tool_connections: maximum number of concurrent connections of a tool which is allowed to connect to the database. This parameter influences the maximum concurrency of the GaussDB tool.
• sysadmin_reserved_connections: minimum number of connections reserved for the administrator. You are advised not to set this parameter to a large value. This parameter is used together with the max_connections parameter. The maximum number of connections of the administrator is equal to the value of max_connections + the value of sysadmin_reserved_connections.

  This parameter is a POSTMASTER parameter. Set it based on instructions provided in Setting Parameters.