Help Center/ TaurusDB_TaurusDB for PostgreSQL/ FAQs/ Database Connection/ What Is the Maximum Number of Connections to a TaurusDB for PostgreSQL Instance?
Updated on 2025-11-14 GMT+08:00
View PDF
Share

What Is the Maximum Number of Connections to a TaurusDB for PostgreSQL Instance?

TaurusDB for PostgreSQL does not have constraints on the number of connections. It depends on the default values and value ranges of certain parameters in your DB engine.

Definition

The maximum number of connections refers to the concurrent connections allowed for a DB instance.

How to Change It

  • You can change the maximum number of connections allowed on the console. For details, see Modifying Instance Parameters.
  • You can run the following command to query the maximum number of connections allowed: 
    show max_connections;

    If you want to change the maximum number of connections by running commands, submit a service ticket to apply for required permissions.

Setting the Maximum Number of Connections to an Appropriate Value

The max_connections parameter is closely related to the memory (GB) of the DB instance.

Table 1 Calculation formula

Parameter

Formula

Version Involved

Unit

max_connections

min((total_mem_kb – shared_buffer) x 1,024.0/16 MB, 5,000)

All versions

Count

The following table lists the default values of max_connections for different memory specifications.

Table 2 Default values of max_connections for different memory specifications

Memory (GB)

Max Client Connections (max_connections)

512

5,000

384

5,000

256

5,000

128

5,000

64

3,072

32

1,536

16

768

8

384

4

192

2

96
Parent Topic: Database Connection