Updated on 2022-10-31 GMT+08:00

RDS for PostgreSQL 9.6 Test Data

The Maximum Connections (Stress Testing) columns in the following tables indicate the results of the RDS performance stress testing. For running services on the live network, set the parameter max_connections.

General-Enhanced DB Instance Test List

Table 1 vCPU:Memory = 1:2

vCPUs

Memory (GB)

Maximum Connections (Stress Testing)

TPS

QPS

IOPS

1

2

300

150

3,086

1,200

2

4

500

263

5,257

2,000

4

8

1,200

578

11,554

6,000

60

128

12,000

1,398

27,965

20,000

Table 2 vCPU:Memory = 1:4

vCPUs

Memory (GB)

Maximum Connections (Stress Testing)

TPS

QPS

IOPS

1

4

500

166

3,312

1,400

2

8

1,200

517

10,340

4,000

4

16

2,500

705

14,093

8,000

8

32

5,000

821

16,421

12,000

16

64

10,000

880

17,590

16,000

32

128

12,000

1,392

27,832

20,000

60

256

20,000

2,017

40,336

20,000

Table 3 vCPU:Memory = 1:8

vCPUs

Memory (GB)

Maximum Connections (Stress Testing)

TPS

QPS

IOPS

2

16

2,500

554

11,099

5,000

4

32

5,000

781

15,614

7,000

8

64

5,000

931

18,613

11,000

General-Enhanced DB Instance Test Results

Figure 1 vCPU:Memory = 1:2
Figure 2 vCPU:Memory = 1:4
Figure 3 vCPU:Memory = 1:8