Note The performance test results of ApsaraDB RDS for PostgreSQL in the following table are for reference only. For more information about ApsaraDB RDS for PostgreSQL, see Performance optimization and diagnosis and Development and O&M recommendations for ApsaraDB RDS for PostgreSQL.
Instance type Number of data records that can be stored Number of tested data records Number of hot (active) data records Read-only QPS Read and write QPS
rds.pg.st.h43

(60 cores, 470 GB of memory, and 3 TB of storage)

15 billion 5 billion 0.1 billion 573651 336850
rds.pg.st.h43

(60 cores, 470 GB of memory, and 3 TB of storage)

15 billion 5 billion 0.5 billion 559255 309410
rds.pg.st.h43

(60 cores, 470 GB of memory, and 3 TB of storage)

15 billion 5 billion 1 billion 550090 284155
rds.pg.st.h43

(60 cores, 470 GB of memory, and 3 TB of storage)

15 billion 5 billion 5 billion 430596 204160
pg.x4.4xlarge.2

(32 cores, 128 GB of memory, and 2 TB of storage)

10 billion 1 billion 0.1 billion 400144 254915
pg.x4.4xlarge.2

(32 cores, 128 GB of memory, and 2 TB of storage)

10 billion 1 billion 0.5 billion 375522 228440
pg.x4.4xlarge.2

(32 cores, 128 GB of memory, and 2 TB of storage)

10 billion 1 billion 1 billion 360007 200250
pg.x8.2xlarge.2

(16 cores, 128 GB of memory, and 2 TB of storage)

10 billion 1 billion 0.1 billion 235592 156330
pg.x8.2xlarge.2

(16 cores, 128 GB of memory, and 2 TB of storage)

10 billion 1 billion 0.5 billion 221153 133125
pg.x8.2xlarge.2

(16 cores, 128 GB of memory, and 2 TB of storage)

10 billion 1 billion 1 billion 211268 115915
pg.x8.xlarge.2

(8 cores, 64 GB of memory, and 1 TB of storage)

5 billion 1 billion 0.1 billion 129323 71820
pg.x8.xlarge.2

(8 cores, 64 GB of memory, and 1 TB of storage)

5 billion 1 billion 0.5 billion 115498 58140
pg.x8.xlarge.2

(8 cores, 64 GB of memory, and 1 TB of storage)

5 billion 1 billion 1 billion 102735 58555
pg.x8.large.2

(4 cores, 32 GB of memory, and 500 GB of storage)

2.5 billion 0.5 billion 0.1 billion 75729 45110
pg.x8.large.2

(4 cores, 32 GB of memory, and 500 GB of storage)

2.5 billion 0.5 billion 0.5 billion 63818 36375
pg.x8.medium.2

(2 cores, 16 GB of memory, and 250 GB of storage)

1.25 billion 0.1 billion 0.05 billion 37245 24520
pg.x8.medium.2

(2 cores, 16 GB of memory, and 250 GB of storage)

1.25 billion 0.1 billion 0.1 billion 35321 19880
Note
  • Instance type: indicates the code that represents the specifications of an ApsaraDB RDS for PostgreSQL instance.
  • Number of data records that can be stored: indicates the maximum number of data records that can be stored for the instance type.
  • Number of tested data records: indicates the number of data records that are used in the test.
  • Number of hot (active) data records: indicates the number of data records that are queried and updated by using SQL statements in the test.
  • Read-only QPS: indicates the number of read requests that are processed per second.
  • Read and write QPS: the number of read requests and write requests that are processed per second.