This topic describes TPC-C and TPC-B performance tests for AnalyticDB for PostgreSQL to evaluate the scale-out capabilities of the multi-coordinator architecture in online transaction processing (OLTP) scenarios.

Note The TPC-C and TPC-B performance tests described in this topic are implemented based on the TPC-C and TPC-B benchmark tests but cannot meet all requirements of TPC-C and TPC-B benchmark tests. Therefore, the test results described in this topic cannot be compared with the published TPC-C and TPC-B benchmark test results.

Instance specifications

In this topic, AnalyticDB for PostgreSQL instances that have the following specifications are used:

  • Coordinator node specifications: 8 cores, 64 GB
  • Number of coordinator nodes: 1 and 4
    Note Up to two coordinator nodes can be selected when you create an instance in the console. If you want to create an instance that has four coordinator nodes, Submit a ticket to contact technical support.
  • Compute node specifications: 4 cores, 32 GB
  • Number of compute nodes: 32
  • Storage type: enhanced SSD (ESSD)
  • Compute node storage capacity: 1,000 GB
Note The tested instances work in session consistency mode.

TPC-C performance tests

TPC-C is a major performance test benchmark provided by the Transaction Processing Performance Council (TPC). It is used to test the transaction processing capabilities of database systems. TPC-C performance tests may involve concurrent processing of multiple transactions and hybrid processing of online and offline transactions. These tests can comprehensively measure the transaction processing capabilities of database systems.

  • Test results for the instance that has one coordinator node:

    When 64 transactions are concurrently processed, the instance performance no longer increases with the number of concurrent transactions.

  • Test results for the instance that has four coordinator nodes:

    When more than 64 transactions are concurrently processed, the instance performance still increases with the number of concurrent transactions.

TPC-B performance tests

TPC-B is another performance test benchmark provided by the TPC. It is used to measure the number of concurrent transactions that a database system can process per second.

  • Test results for the instance that has one coordinator node:

    When 64 transactions are concurrently processed, the instance performance no longer increases with the number of concurrent transactions.

  • Test results for the instance that has four coordinator nodes:

    When more than 64 transactions are concurrently processed, the instance performance still increases with the number of concurrent transactions.