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