Manage
CO.NF for your Blog
Configuration Snippet Parameter Snippet

max_connections

  1. Documentation
  2. Connections and Authentication
  3. Connection Settings
  4. max_connections
COPY SHARING LINK
Type: integer
Default: 100
Min: 1
Max: 262143
Context: postmaster
Restart: true
Sets the maximum number of concurrent connections

Determines the maximum number of concurrent connections to the database server. The default is typically 100 connections, but might be less if your kernel settings will not support it (as determined during initdb). This parameter can only be set at server start.

PostgreSQL sizes certain resources based directly on the value of max_connections. Increasing its value leads to higher allocation of those resources, including shared memory.

When running a standby server, you must set this parameter to the same or higher value than on the primary server. Otherwise, queries will not be allowed in the standby server.

Official docs

Search in source code

Recommendations

Should be set to the maximum number of connections which you expect to need at peak load. Note that each connection uses shared_buffer memory, as well as additional non-shared memory, so be careful not to run the system out of memory. In general, if you need more than 200 connections, you should probably be making more use of connection pooling.
By annotated.conf

Comments