DuckDB

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.

Project Site

duckdb.org

Source Repository

github.com

Test Created

28 October 2023

Test Maintainer

Michael Larabel

Test Type

System

Average Install Time

19 Minutes, 34 Seconds

Average Run Time

11 Minutes

Test Dependencies

C/C++ Compiler Toolchain

Supported Platforms

* 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 1 December 2023.

Revision History

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

Suites Using This Test

Server

Performance Metrics

Analyze Test Configuration:

DuckDB 0.9.1

Benchmark: IMDB

OpenBenchmarking.org metrics for this test profile configuration based on 79 public results since 28 October 2023 with the latest data as of 29 November 2023.

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

98th

AMD Ryzen 9 7950X 16-Core

95th

AMD EPYC 9334 32-Core

92nd

Intel Core i5-14600K

79th

Intel Xeon Platinum 8490H

79th

Mid-Tier

75th

> 99

AMD EPYC 9554 64-Core

70th

104

AMD EPYC 9654 96-Core

60th

116

AMD EPYC 9684X 96-Core

60th

116

AMD EPYC 8534P 64-Core

55th

123

Median

50th

123

2 x AMD EPYC 9554 64-Core

41st

132

AMD Ryzen 7 7840U

33rd

144 ^{+/- 1}

AMD EPYC 9754 128-Core

27th

148

2 x AMD EPYC 9684X 96-Core

26th

154

2 x AMD EPYC 9654 96-Core

26th

154 ^{+/- 1}

Low-Tier

25th

> 154

AMD Ryzen Threadripper 3990X 64-Core

14th

182

2 x AMD EPYC 9754 128-Core

11th

202

Based on OpenBenchmarking.org data, the selected test / test configuration (DuckDB 0.9.1 - Benchmark: IMDB) has an average run-time of 10 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.2%.

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

aarch64

ARMv8 Neoverse-N1 128-Core

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 Max 9468 - Quanta Cloud S6Q-MB-MPS - Intel Device 1bce Ubuntu 23.10 - 6.6.0-rc5-phx-patched - GNOME Shell 45.0
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
new tests Featured Processor Comparison	Intel Core i5-13600K - Intel Core i5-14600K - Intel Core i9-14900K
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
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
Ubuntu 23.10 Server Benchmarks 1 System - 650 Benchmark Results
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
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
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
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
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

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
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
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
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
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
new-sat 14 Systems - 159 Benchmark Results	Intel Xeon Max 9468 - Quanta Cloud S6Q-MB-MPS - Intel Device 1bce Ubuntu 23.10 - 6.6.0-rc5-phx-patched - GNOME Shell 45.0
ospray studio threadripper 4 Systems - 20 Benchmark Results	AMD Ryzen Threadripper 3990X 64-Core - Gigabyte TRX40 AORUS PRO WIFI - AMD Starship Ubuntu 23.04 - 6.2.0-35-generic - GNOME Shell 44.3
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
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
new tests Featured Processor Comparison	Intel Core i5-14600K - ASUS PRIME Z790-P WIFI - Intel Device 7a27 Ubuntu 23.10 - 6.5.0-9-generic - 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
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
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