Release History
Help

YMatrix

Quick Start

Deployment

Data Usage

Manage Clusters

Security

Best Practice

Technical Principles

Advanced Features

Guide

SQL Reference

FAQ

TPC-H Benchmark

TPC-H is a decision support benchmark that consists of a suite of business-oriented ad-hoc queries and concurrent data modification operations. Both the selected queries and the underlying data have broad industry relevance. This benchmark demonstrates the capabilities of decision support systems to examine large volumes of data, execute highly complex queries, and answer critical business questions—while reflecting the multifaceted query-processing strengths of database systems.

This test compares the performance of YMatrix, CloudBerry, and Greenplum under TPC-H analytical query workloads.

Test Conclusion

The results show that, at the 1TB scale, YMatrix delivers 13.5× better performance than CloudBerry and 10.1× better performance than Greenplum.

Test Setup

Hardware Configuration

YMatrix, Greenplum, and CloudBerry were deployed on identically configured hosts:

VM 1 VM 2 VM 3
CPU 32 cores 32 cores 32 cores
Memory 128 GB 128 GB 128 GB
Storage 1 × SSD 4 × SSD 4 × SSD
Segment Nodes — 4 Primary (4P) 4 Primary (4P)

Note: The cluster uses 2 segment hosts (VM2 & VM3), each running 2 primary segments (total 4P).

Software Configuration

Component YMatrix CloudBerry Greenplum
Cluster Topology 1 Master + 2 Segments 1 Master + 2 Segments 1 Master + 2 Segments
Version 6.5.0 2.0.0 (Community Edition) 7.3.1
Configuration orca + runtimefilter=off + statement_mem=1GB orca + runtimefilter=off + statement_mem=1GB Default
Storage Engine MARS3 AOCO AOCO
Data Type FLOAT NUMERIC FLOAT

Test Results

The table below shows the execution latency (in seconds) for all 22 TPC-H queries.
The columns CloudBerry / YMatrix and Greenplum / YMatrix represent the slowdown ratio—i.e., how many times slower CloudBerry or Greenplum is compared to YMatrix. Higher values indicate superior performance by YMatrix.

Query YMatrix (s) CloudBerry (s) Greenplum (s) CloudBerry / YMatrix Greenplum / YMatrix
Q01 27 708 211 25.96 7.75
Q02 4 52 59 11.67 13.15
Q03 20 274 219 13.56 10.85
Q04 47 203 174 4.28 3.67
Q05 27 348 341 12.76 12.51
Q06 1 126 10 112.66 8.89
Q07 10 256 168 25.33 16.64
Q08 14 274 247 19.37 17.48
Q09 75 514 533 6.88 7.12
Q10 17 247 301 14.38 17.54
Q11 2 30 38 13.39 17.13
Q12 17 181 114 10.54 6.64
Q13 38 276 238 7.19 6.21
Q14 3 118 25 35.11 7.51
Q15 6 272 26 48.67 4.70
Q16 8 57 57 7.33 7.27
Q17 11 1,656 1,031 148.97 92.75
Q18 66 712 561 10.85 8.54
Q19 17 186 114 10.83 6.64
Q20 25 152 75 6.02 2.96
Q21 91 572 800 6.29 8.80
Q22 11 78 111 7.02 10.00
SUM 540 7,292 5,454 13.51 10.11
← Previous
Connect from code
Next →
TPC-DS