Help Center/ Data Warehouse Service/ Performance White Paper (9.1.0.x)/ TPC-H Performance Test/ TPC-H Test Result
Updated on 2025-07-22 GMT+08:00
View PDF
Share

TPC-H Test Result

GaussDB(DWS) tested the query performance of TPC-H 1 TB datasets in both the storage-compute coupled and storage-compute decoupled architectures. A total of 22 queries were performed. The total query time for the storage-compute coupled architecture was 170.08 seconds, compared to 172.62 seconds for the decoupled architecture.

The following table lists the detailed performance data.

Table 1 TPC-H Test Result

TPC-H Query

8.3.0

9.1.0.200

-

Storage-compute coupled architecture (s)

Storage-compute coupled architecture (s)

Storage-compute decoupled architecture (s)

Q1

16.97

5.82

6.25

Q2

1.44

1.11

1.15

Q3

13.02

6.17

6.64

Q4

65.56

15.39

15.26

Q5

21.90

12.72

13.40

Q6

0.84

0.42

0.46

Q7

11.08

5.55

5.65

Q8

87.18

8.62

9.37

Q9

55.98

23.46

24.69

Q10

12.20

6.75

6.76

Q11

3.57

3.52

3.41

Q12

5.92

5.05

3.60

Q13

14.28

12.16

12.31

Q14

1.87

1.29

1.26

Q15

2.24

1.25

1.44

Q16

4.52

2.19

2.14

Q17

10.54

8.40

9.42

Q18

47.97

18.34

15.16

Q19

110.03

6.88

7.50

Q20

10.07

5.19

5.60

Q21

28.82

16.25

17.37

Q22

7.04

3.53

3.76

Total duration (s)

533.05

170.08

172.62
Parent topic: TPC-H Performance Test