AnalyticDB:Performance test for data import and query in Serverless Pro mode

Configuration information

The test in this topic uses the following Serverless Pro pattern instance type:

• Reserved computing resources: 96 CUs (96 compute nodes)

• Serverless cache size: 1 TB

The AnalyticDB for PostgreSQL instance in elastic storage mode used for this test has the following specifications:

• Compute node specifications: 2 cores, 16 GB

• Number of compute nodes: 48

Data import performance

The data import test uses an OSS Foreign Data Wrapper (FDW) to import data.

• Test table: This test uses the TPC-H lineitem table. The volume of test data generated is 1 TB. For more information about how to generate test data, see TPC-H performance test for V7.0.

• Test method: OSS FDW. For more information about the operation, see Use an OSS foreign table for data lake analytics.

• Test results:

  Data volume	Elastic storage mode	Serverless Pro mode
  TPC-H 1 TB	791.3 s	556.71 s

Data query performance

This performance test uses the TPC-H qgen tool to generate 1 TB of data. The test measures and compares the query time of Serverless Pro mode with that of elastic storage mode. For more information about the test operation, see TPC-H. The following table shows the test results: