PostgreSQL 9.6 Test Data

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

Test Data of General-Enhanced DB Instances

Table 1 vCPU:Memory=1:2

vCPUs

Memory (GB)

Connections (in 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 CPU:Memory=1:4

vCPUs

Memory (GB)

Connections (in 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 CPU:Memory=1:8

vCPUs

Memory (GB)

Connections (in 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

Test Data of General-Enhanced DB Instances

Figure 1 General-purpose
Figure 2 Compute
Figure 3 Memory