AnalyticDB for PostgreSQL in Serverless Pro mode imports 1 TB of TPC-H data faster and completes all 22 TPC-H queries faster than elastic storage mode. This page presents the full benchmark results.
The TPC-H implementation used in this test is based on TPC-H benchmarking. These test results cannot be compared with published TPC-H benchmark results because the tests do not meet all TPC-H benchmark requirements.
Test configuration
The following table lists the specifications for each instance type used in this test.
| Attribute | Serverless Pro mode | Elastic storage mode |
|---|---|---|
| Reserved computing resources | 96 CUs (96 compute nodes) | — |
| Serverless cache size | 1 TB | — |
| Compute node specifications | — | 2 cores, 16 GB |
| Number of compute nodes | — | 48 |
Data import performance
The import test loads the TPC-H lineitem table (1 TB) from Object Storage Service (OSS) using the OSS Foreign Data Wrapper (FDW).
For details on generating the test dataset, see TPC-H performance test for V7.0.
For details on the OSS FDW import procedure, see Use an OSS foreign table for data lake analytics.
Results are measured in seconds. Lower is better.
| Data volume | Elastic storage mode | Serverless Pro mode |
|---|---|---|
| TPC-H 1 TB | 791.3 s | 556.71 s |
Serverless Pro mode imported 1 TB of data in 556.71 s, compared to 791.3 s for elastic storage mode.
Data query performance
The query test uses the TPC-H qgen tool to generate 1 TB of data and measures query time for all 22 standard TPC-H queries. For the full test procedure, see TPC-H performance testing for AnalyticDB for PostgreSQL V6.
Results are measured in seconds. Lower is better.
| Query | Elastic storage mode | Serverless Pro mode |
|---|---|---|
| Q01 | 14.28 s | 9.41 s |
| Q02 | 0.52 s | 0.61 s |
| Q03 | 4.58 s | 3.43 s |
| Q04 | 2.66 s | 1.72 s |
| Q05 | 4.92 s | 3.75 s |
| Q06 | 0.62 s | 0.49 s |
| Q07 | 3.96 s | 3.12 s |
| Q08 | 3.75 s | 2.44 s |
| Q09 | 18.87 s | 13.32 s |
| Q10 | 4.19 s | 3.23 s |
| Q11 | 0.93 s | 1.03 s |
| Q12 | 2.4 s | 2.25 s |
| Q13 | 11.75 s | 8.21 s |
| Q14 | 0.81 s | 0.64 s |
| Q15 | 3.94 s | 4.74 s |
| Q16 | 2.34 s | 2.95 s |
| Q17 | 1.83 s | 1.49 s |
| Q18 | 22.3 s | 12.48 s |
| Q19 | 3.41 s | 2.28 s |
| Q20 | 2.2 s | 2.1 s |
| Q21 | 9.56 s | 5.54 s |
| Q22 | 3.02 s | 2.41 s |
| Total | 122.84 s | 87.64 s |
Serverless Pro mode completed all 22 queries in 87.64 s, compared to 122.84 s for elastic storage mode.