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, 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.