Quick onboard
Deployment
Data Modeling
Connecting
Migration
Query
Operations and Maintenance
Common Maintenance
Partition
Backup and Restore
Expansion
Mirroring
Resource Management
Security
Monitoring
Performance Tuning
Troubleshooting
Reference Guide
Tool guide
Data type
Storage Engine
Executor
Stream
DR (Disaster Recovery)
Configuration
Index
Extension
SQL Reference
The Star Schema Benchmark (SSB) is a widely adopted analytical benchmark derived from TPC-H. It serves as a cost-performance evaluation standard tailored for analytical workloads. The SSB defines 13 query scenarios that evaluate an analytical database’s performance from multiple dimensions.
This benchmark compares the SSB performance of YMatrix, Greenplum, and CloudBerry in single-table analytical query scenarios.
Based on the execution of all 13 queries over a 100 GB SSB dataset, YMatrix delivers 118× faster performance than Greenplum and 145× faster performance than CloudBerry in terms of total query time.
All three systems—YMatrix, Greenplum, and CloudBerry—were deployed on identical hardware:
| 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).
| 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) | 7.3.1 |
| Configuration | Default | Default | Default |
| Storage Engine | MARS3 | AOCO | AOCO |
The table below shows the execution latency (in milliseconds) for each of the 13 SSB queries.
The columns CloudBerry / YMatrix and Greenplum / YMatrix represent the speedup ratio—i.e., how many times slower CloudBerry or Greenplum is compared to YMatrix. Higher values indicate better performance by YMatrix.
| Query | YMatrix (ms) | CloudBerry (ms) | Greenplum (ms) | CloudBerry / YMatrix | Greenplum / YMatrix |
|---|---|---|---|---|---|
| Q1.1 | 50 | 1,049 | 1,280 | 20.90 | 25.49 |
| Q1.2 | 51 | 852 | 898 | 16.65 | 17.55 |
| Q1.3 | 50 | 834 | 937 | 16.80 | 18.87 |
| Q2.1 | 40 | 8,134 | 6,305 | 201.81 | 156.44 |
| Q2.2 | 40 | 9,169 | 6,508 | 232.00 | 164.68 |
| Q2.3 | 30 | 7,958 | 5,788 | 262.42 | 190.85 |
| Q3.1 | 51 | 4,864 | 5,165 | 95.37 | 101.26 |
| Q3.2 | 26 | 9,104 | 6,858 | 356.46 | 268.53 |
| Q3.3 | 23 | 9,066 | 6,023 | 393.77 | 261.60 |
| Q3.4 | 9 | 1,565 | 1,181 | 171.21 | 129.26 |
| Q4.1 | 26 | 5,772 | 5,903 | 221.53 | 226.57 |
| Q4.2 | 15 | 1,012 | 1,496 | 69.19 | 102.21 |
| Q4.3 | 10 | 1,712 | 1,387 | 173.36 | 140.44 |
| Total | 420 | 61,092 | 49,730 | 145.29 | 118.27 |
