DuckDB Benchmark - OpenBenchmarking.org

DuckDB is an in-progress SQL OLAP database management system optimized for analytics and features a vectorized and parallel engine.

To run this test with the Phoronix Test Suite, the basic command is: phoronix-test-suite benchmark duckdb.

* Uploading of benchmark result data to OpenBenchmarking.org is always optional (opt-in) via the Phoronix Test Suite for users wishing to share their results publicly.
** Data based on those opting to upload their test results to OpenBenchmarking.org and users enabling the opt-in anonymous statistics reporting while running benchmarks from an Internet-connected platform.
Data updated weekly as of 21 April 2024.

Revision History

pts/duckdb-1.0.0 [View Source] Sat, 28 Oct 2023 16:10:27 GMT
Initial commit of DuckDB benchmark.

Performance Metrics

DuckDB 0.9.1

Benchmark: TPC-H Parquet

OpenBenchmarking.org metrics for this test profile configuration based on 175 public results since 28 October 2023 with the latest data as of 17 April 2024.

Below is an overview of the generalized performance for components where there is sufficient statistically significant data based upon user-uploaded results. It is important to keep in mind particularly in the Linux/open-source space there can be vastly different OS configurations, with this overview intended to offer just general guidance as to the performance expectations.

Component

Percentile Rank

# Compatible Public Results

Seconds (Average)

Intel Core i9-14900K

99th

Intel Core i5-14600K

96th

AMD Ryzen 9 7950X 16-Core

91st

95 ^{+/- 2}

AMD Ryzen 7 7840U

86th

116

AMD Ryzen Threadripper PRO 7995WX 96-Cores

85th

118 ^{+/- 4}

AMD EPYC 9334 32-Core

81st

128

INTEL XEON PLATINUM 8592

77th

136 ^{+/- 2}

Mid-Tier

75th

> 139

AMD EPYC 9554 64-Core

75th

143

AMD EPYC 9654 96-Core

72nd

146

AMD EPYC 9684X 96-Core

70th

147

Intel Xeon Platinum 8490H

67th

148 ^{+/- 1}

2 x AMD EPYC 9554 64-Core

57th

149

2 x INTEL XEON PLATINUM 8592

55th

151 ^{+/- 4}

ARMv8 Neoverse-V2 72-Core

55th

151 ^{+/- 3}

Median

50th

156

2 x AMD EPYC 9654 96-Core

42nd

157 ^{+/- 1}

2 x AMD EPYC 9684X 96-Core

39th

158 ^{+/- 1}

2 x Intel Xeon Platinum 8490H

35th

161 ^{+/- 9}

Intel Xeon Platinum 8380

35th

167

2 x Intel Xeon Platinum 8380

31st

170

Low-Tier

25th

> 172

AMD EPYC 8534PN 64-Core

24th

174 ^{+/- 3}

AMD EPYC 8534P 64-Core

24th

174 ^{+/- 2}

AMD EPYC 9754 128-Core

21st

177

2 x Intel Xeon Platinum 8280

16th

178

AMD Ryzen Threadripper 3990X 64-Core

11th

189 ^{+/- 1}

2 x AMD EPYC 9754 128-Core

9th

191

ARMv8 Neoverse-N1 128-Core

6th

238 ^{+/- 1}

AMD EPYC 7601 32-Core

3rd

248 ^{+/- 2}

Based on OpenBenchmarking.org data, the selected test / test configuration (DuckDB 0.9.1 - Benchmark: TPC-H Parquet) has an average run-time of 11 minutes. By default this test profile is set to run at least 3 times but may increase if the standard deviation exceeds pre-defined defaults or other calculations deem additional runs necessary for greater statistical accuracy of the result.

Based on public OpenBenchmarking.org results, the selected test / test configuration has an average standard deviation of 0.1%.

Tested CPU Architectures

This benchmark has been successfully tested on the below mentioned architectures. The CPU architectures listed is where successful OpenBenchmarking.org result uploads occurred, namely for helping to determine if a given test is compatible with various alternative CPU architectures.

CPU Architecture

Kernel Identifier

Verified On

Intel / AMD x86 64-bit

x86_64

(Many Processors)

ARMv8 64-bit

arm64

Apple M2 Pro

ARMv8 64-bit

aarch64

ARMv8 Neoverse-N1 128-Core, ARMv8 Neoverse-V2 72-Core

SSD Storage 1 System - 192 Benchmark Results	AMD EPYC 8534P 64-Core - AMD Cinnabar - AMD Device 14a4 Ubuntu 23.10 - 6.8.1-060801-generic - GNOME Shell 45.2
gh200 nvidia 2 Systems - 62 Benchmark Results	ARMv8 Neoverse-V2 - Quanta Cloud QuantaGrid S74G-2U 1S7GZ9Z0000 S7G MB - 1 x 480 GB DRAM-6400MT Ubuntu 23.10 - 6.5.0-15-generic - GCC 13.2.0
AMD EPYC Zen 1 1 System - 403 Benchmark Results	AMD EPYC 7601 32-Core - TYAN B8026T70AE24HR - AMD 17h Ubuntu 23.10 - 6.6.9-060609-generic - GNOME Shell 45.0
AMD EPYC Zen 1 1 System - 390 Benchmark Results	AMD EPYC 7601 32-Core - TYAN B8026T70AE24HR - AMD 17h Ubuntu 23.10 - 6.6.9-060609-generic - GNOME Shell 45.0
fhe 3 Systems - 334 Benchmark Results	AMD Ryzen 5 5500U - NB01 NL5xNU - AMD Renoir Tuxedo 22.04 - 6.0.0-1010-oem - KDE Plasma 5.26.5
s5epyc40c256gbram2468gbvram_ 2 Systems - 834 Benchmark Results
ServerRun 1 System - 756 Benchmark Results
pts-database 1 System - 101 Benchmark Results	Apple M2 Pro - Apple Mac mini - 16GB macOS 13.5 - 22.6.0 - GCC 14.0.3 + Clang 17.0.6 + LLVM 17.0.6 + Xcode 14.3.1
pts-database 1 System - 101 Benchmark Results	Apple M2 Pro - Apple Mac mini - 16GB macOS 13.5 - 22.6.0 - GCC 14.0.3 + Clang 17.0.6 + LLVM 17.0.6 + Xcode 14.3.1
duck eave 2 Systems - 5 Benchmark Results	Intel Core i9-14900K - ASUS PRIME Z790-P WIFI - Intel Device 7a27 Ubuntu 23.10 - 6.5.0-10-generic - GNOME Shell 45.0
Arctic Freezer 4U-M Heatsink - AMD EPYC Siena Benchmarks 4 Systems - 350 Benchmark Results	AMD EPYC 8534P 64-Core - AMD Cinnabar - AMD Device 14a4 Ubuntu 23.10 - 6.5.0-5-generic - GNOME Shell 45.0
Noctua SP6 Heatsinks AMD EPYC Siena Benchmarks 3 Systems - 513 Benchmark Results	AMD EPYC 8534P 64-Core - AMD Cinnabar - AMD Device 14a4 Ubuntu 23.10 - 6.5.0-5-generic - GNOME Shell 45.0
atomicrulez_ubuntu_20.04.6_duckdb 1 System - 2 Benchmark Results	Intel Core i9-10850K - ASUS ROG MAXIMUS XII APEX - Intel Comet Lake PCH Ubuntu 20.04 - 5.15.0-88-generic - GNOME Shell 3.36.9
aug 2 Systems - 142 Benchmark Results	Intel Core i9-10980XE - ASRock X299 Steel Legend - Intel Sky Lake-E DMI3 Registers Ubuntu 22.04 - 6.2.0-33-generic - GNOME Shell 42.2
new-sat 14 Systems - 159 Benchmark Results	2 x Intel Xeon Platinum 8490H - Quanta Cloud S6Q-MB-MPS - Intel Device 1bce Ubuntu 23.10 - 6.6.0-rc5-phx-patched - GNOME Shell 45.0

GPTshop GH200 Linux Benchmarks 18 Systems - 33 Benchmark Results	2 x AMD EPYC 9684X 96-Core - AMD Titanite_4G - AMD Device 14a4 Ubuntu 23.10 - 6.6.0-rc5-phx - GNOME Shell 45.0
new sat 4 Systems - 98 Benchmark Results	2 x Intel Xeon Platinum 8490H - Quanta Cloud S6Q-MB-MPS - Intel Device 1bce Ubuntu 23.10 - 6.6.0-rc5-phx-patched - GNOME Shell 45.0
new tests Featured Processor Comparison	Intel Core i9-14900K - ASUS PRIME Z790-P WIFI - Intel Device 7a27 Ubuntu 23.10 - 6.5.0-9-generic - GNOME Shell 45.0
extra tests 3 4 Systems - 134 Benchmark Results	AMD EPYC 9334 32-Core - Supermicro H13SSW - 12 x 64 GB DDR5-4800MT AlmaLinux 9.2 - 5.14.0-284.25.1.el9_2.x86_64 - GCC 11.3.1 20221121
new-sat 14 Systems - 159 Benchmark Results	2 x Intel Xeon Platinum 8490H - Quanta Cloud S6Q-MB-MPS - Intel Device 1bce Ubuntu 23.10 - 6.6.0-rc5-phx-patched - GNOME Shell 45.0
oktoberfest 2 Systems - 246 Benchmark Results	Intel Core i5-12600K - ASUS PRIME Z690-P WIFI D4 - Intel Device 7aa7 Ubuntu 22.04 - 5.19.0-051900rc6daily20220716-generic - GNOME Shell 42.1
6850u tests 2 Systems - 84 Benchmark Results	AMD Ryzen 7 PRO 6850U - LENOVO 21CM0001US - AMD 17h-19h PCIe Root Complex Fedora Linux 39 - 6.5.7-300.fc39.x86_64 - GNOME Shell 45.0
miner spray 4 Systems - 31 Benchmark Results	AMD EPYC 7551 32-Core - GIGABYTE MZ31-AR0-00 v01010101 - AMD 17h Debian 12 - 6.1.0-10-amd64 - GCC 12.2.0
Intel Optimized Power Mode Xeon Platinum Benchmarks 2 Systems - 520 Benchmark Results	2 x INTEL XEON PLATINUM 8592+ - Quanta Cloud S6Q-MB-MPS - Intel Device 1bce Ubuntu 23.10 - 6.5.0-13-generic - GCC 13.2.0
extra tests 3 4 Systems - 98 Benchmark Results	AMD EPYC 9334 32-Core - Supermicro H13SSW - 12 x 64 GB DDR5-4800MT AlmaLinux 9.2 - 5.14.0-284.25.1.el9_2.x86_64 - GCC 11.3.1 20221121
ospray studio framework laptop 3 Systems - 20 Benchmark Results	AMD Ryzen 7 7840U - Framework FRANMDCP07 - AMD Device 14e8 Ubuntu 23.10 - 6.5.0-5-generic - GNOME Shell 45.0
Arctic Freezer 4U-M Heatsink - AMD EPYC Siena Benchmarks 4 Systems - 350 Benchmark Results	AMD EPYC 8534P 64-Core - AMD Cinnabar - AMD Device 14a4 Ubuntu 23.10 - 6.5.0-5-generic - GNOME Shell 45.0
Bcachefs Linux 6.7 Benchmarks Featured File-System Comparison	AMD Ryzen 9 7950X 16-Core - ASUS ROG STRIX X670E-E GAMING WIFI - AMD Device 14d8 Ubuntu 23.10 - 6.6.0-phx-bcachefs - GNOME Shell 45.0
okt 2 Systems - 358 Benchmark Results	AMD Ryzen 9 3900XT 12-Core - MSI MEG X570 GODLIKE - AMD Starship Ubuntu 22.04 - 6.2.0-35-generic - GNOME Shell 42.2
AMD EPYC Zen 4C Power Efficiency 5 Systems - 149 Benchmark Results	AMD EPYC 8324P 32-Core - AMD Cinnabar - AMD Device 14a4 Ubuntu 23.10 - 6.6.9-060609-generic - GNOME Shell 45.0

DuckDB

Project Site

Source Repository

Test Created

Test Maintainer

Test Type

Average Install Time

Average Run Time

Test Dependencies

Accolades

Supported Platforms

Revision History

Suites Using This Test

Performance Metrics

DuckDB 0.9.1

Benchmark: TPC-H Parquet

Tested CPU Architectures

Recent Test Results

Most Popular Test Results