function dba_pgsql_report_help_connections in Database Administration 7

1 call to dba_pgsql_report_help_connections()

dba_pgsql_report_output in database/pgsql.report.inc

PostgreSQL report.

File

database/pgsql.report.inc, line 105

Code

function dba_pgsql_report_help_connections() {
  return t("PostgreSQL is currently using a significant percentage of available connections. By default, PostgreSQL allows 100 simultaneous connections, however on a well tuned server most queries last less than a second so even on a busy web server you rarely have more than a couple dozen simultaneous connections. It is generally not advisable to increase the connection limit beyond 100, unless you already have a well tuned server and the database is supporting multiple web servers. Before you consider raising this limit, look into first optimizing your queries and perform other tuning.\n\nTo allow additional PostgreSQL connections, adjust the max_connections tunable.");
}