Updated on 2025-07-22 GMT+08:00

SSB Test Result

In the SSB wide table scenario, GaussDB(DWS) outperforms the open source OLAP product ClickHouse in terms of query performance. When utilizing the hstore_opt table, Turbo storage, and Turbo engine, GaussDB(DWS) demonstrates twice the query performance compared to ClickHouse.

Table 1 SSB Test Result

SSB

GaussDB(DWS)

ClickHouse

Q1.1

0.074

0.059

Q1.2

0.039

0.021

Q1.3

0.102

0.022

Q2.1

0.052

0.254

Q2.2

0.236

0.281

Q2.3

0.064

0.214

Q3.1

0.101

0.434

Q3.2

0.049

0.348

Q3.3

0.032

0.299

Q3.4

0.010

0.025

Q4.1

0.085

0.456

Q4.2

0.047

0.171

Q4.3

0.023

0.146

Total duration (s)

0.913

2.73