Docs

RDS for PostgreSQL

Performance document

Test methods

This topic describes the environments, tools, steps, and metrics used for RDS for PostgreSQL performance testing.

Test Environment

Region: cn-beijing-autodriving, with S20 models in the node pool

Availability zone: Availability zone B

ECS of client: Computation type c3i 32 vCPU 64 GiB, Specification code: ecs.c3i.8xlarge

OS mirror image: CentOS 8.3 64-bit version

tip

Because you must install additional compilation tools for the stress test tools, we recommend you bind the ECS instance to an EIP.

Test tool

SysBench is a modular benchmarking test tool that supports multiple platforms and multiple threads. It evaluates the performance of core parameters when the system runs a high-load database to gain quick insights into the database system performance.

Downloading and installing the testing tool

Test steps

Replace the database, username, password, port, host domain, and other information in the command correctly as needed. The duration of this performance test is 180 seconds.

1. Initializing test data

Use the sysbench tool to load test data.The command is as follows:

2. Starting test

Execute the following command to test the performance. During the testing process, the threads parameter will be adjusted to find the optimal number of threads that achieve the best performance and record the results.

3. Clearing test data

After the performance test is completed, clear the test data with the following command.

Test metrics

Transactions Per Second: the number of transactions executed per second by the database.

Queries Per Second: the number of SQL queries executed per second by the database. It contains Read, Write, and Other query types.

The test results are as follows.

For details about test results, refer to Performance test results.

Last updated: 2026.06.04 15:16:45