Performance
Vitesse Deepgreen DB is a scalable MPP data warehouse solution derived from the open source Greenplum Database Project. While maintaining 100% compatibility with the open source GPDB project, Deepgreen DB has a next-genaration query processor enhanced with (1) better join and aggregation algorithms, (2) new subsystem to handle spills, and (3) advanced techniques that maximize CPU performance through JIT-compiled query execution, vectorized scans, and data-path optimization.
Contact Sales
TPC-H 10G Results
All 22 queries of TPC-H are measured against Greenplum DB and Deepgreen DB. Q1 and Q5 are specifically graphed below for comparisons.
All Results
Raw result: Deepgreen DB vs Greenplum DB using Heap Tables
Q1: Scan and aggregate fact table
Q1 is a typical aggregate query running against the fact table.
Q5: 6-way-join
Q5 is an aggregate over a 6-way hashjoin that joins the fact table
lineitem table against the
orders and supplier tables, and subsequently against other dimension tables.
