Help Center> Data Warehouse Service (DWS)> Performance White Paper> Test Result> TPC-H Single Query Test
Updated on 2022-07-26 GMT+08:00
View PDF

TPC-H Single Query Test

Test Environment

Table 1 Test environment

Product

Flavor

CPU

Memory

Storage

Version

GaussDB(DWS)

8xlarge

32U

256G

Cloud SSD

8.1.3

Test Result

The following is the TPC-H performance test result. (scale=1000, time unit=s)

Table 2 TPC-H 1000X test result

ID

TPC-H Query

Test Result (s)

1

Q1

22.15

2

Q2

2.65

3

Q3

28.29

4

Q4

49.07

5

Q5

44.45

6

Q6

1.24

7

Q7

33.26

8

Q8

32.10

9

Q9

112.67

10

Q10

20.63

11

Q11

6.49

12

Q12

13.73

13

Q13

20.61

14

Q14

3.10

15

Q15

3.45

16

Q16

7.77

17

Q17

16.97

18

Q18

81.23

19

Q19

16.74

20

Q20

16.99

21

Q21

53.11

22

Q22

10.20

23

Total duration (s)

596.90
Parent topic: Test Result