seekdb TPC-H benchmark report

This topic describes the test plan, test environment, and detailed results for a TPC-H benchmark run on seekdb.

Test plan

• Two machines are used for this benchmark. The TPC-H tools run on one machine, and seekdb runs on the other. The seekdb host is configured with 4 vCPUs and 8 GB memory. The log disk, clog disk, and data disk are separate disks with PL1 performance level.

• The test data size is 10 GB.

For step-by-step instructions, see TPC-H benchmark test for seekdb.

Test environment

This benchmark uses Alibaba Cloud ECS as an example environment. seekdb runs on an ECS instance with 4 vCPUs and 8 GB memory.

• When seekdb runs on a 4 vCPU / 8 GB ECS instance, the hardware configuration and software versions are as follows:

  • Hardware configuration

    Service type	ECS type	Instances	vCPUs	Memory
    seekdb	ecs.c8i.xlarge	1	4C	8G

  • Software versions

    Component	Version
    seekdb	seekdb 1.1.0
    TPC-H	V3.0.0
    OS	CentOS Linux 7 (Core)

Test results

This benchmark covers the 10 GB data scale. All queries are executed with a concurrency of 4.

Query	10G
Q1	1.54
Q2	0.15
Q3	0.43
Q4	0.51
Q5	0.58
Q6	0.02
Q7	0.45
Q8	0.66
Q9	1.24
Q10	0.55
Q11	0.13
Q12	0.38
Q13	1.10
Q14	0.11
Q15	0.17
Q16	0.34
Q17	0.28
Q18	1.40
Q19	0.36
Q20	0.13
Q21	1.26
Q22	0.21
Total	12.16s