tpch sparky

Tests for a future article. AMD Ryzen 9 7950X 16-Core testing with a ASUS ROG STRIX X670E-E GAMING WIFI (1416 BIOS) and NVIDIA NV174 8GB on Ubuntu 23.10 via the Phoronix Test Suite.

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 2312041-PTS-TPCHSPAR10
Jump To Table - Results

View

Do Not Show Noisy Results
Do Not Show Results With Incomplete Data
Do Not Show Results With Little Change/Spread
List Notable Results

Statistics

Show Overall Harmonic Mean(s)
Show Overall Geometric Mean
Show Wins / Losses Counts (Pie Chart)
Normalize Results
Remove Outliers Before Calculating Averages

Graph Settings

Force Line Graphs Where Applicable
Convert To Scalar Where Applicable
Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Highlight
Result
Hide
Result
Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
a
December 04 2023
  1 Day, 21 Hours, 49 Minutes
b
December 04 2023
  15 Hours, 8 Minutes
Invert Hiding All Results Option
  1 Day, 6 Hours, 29 Minutes
Only show results matching title/arguments (delimit multiple options with a comma):
Do not show results matching title/arguments (delimit multiple options with a comma):

a

Kernel Notes: Transparent Huge Pages: madvise
Processor Notes: Scaling Governor: amd-pstate-epp powersave (EPP: balance_performance) - CPU Microcode: 0xa601203
Java Notes: OpenJDK Runtime Environment (build 11.0.21+9-post-Ubuntu-0ubuntu123.10)
Python Notes: Python 3.11.6
Security Notes: gather_data_sampling: Not affected + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_rstack_overflow: Vulnerable: Safe RET no microcode + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced / Automatic IBRS IBPB: conditional STIBP: always-on RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected

b

Processor: AMD Ryzen 9 7950X 16-Core @ 5.88GHz (16 Cores / 32 Threads), Motherboard: ASUS ROG STRIX X670E-E GAMING WIFI (1416 BIOS), Chipset: AMD Device 14d8, Memory: 32GB, Disk: 2000GB Samsung SSD 980 PRO 2TB + 4001GB Western Digital WD_BLACK SN850X 4000GB, Graphics: NVIDIA NV174 8GB, Audio: NVIDIA GA104 HD Audio, Monitor: DELL U2723QE, Network: Intel I225-V + Intel Wi-Fi 6 AX210/AX211/AX411

OS: Ubuntu 23.10, Kernel: 6.7.0-060700rc2daily20231127-generic (x86_64), Desktop: GNOME Shell 45.1, Display Server: X Server 1.21.1.7 + Wayland, Display Driver: nouveau, OpenGL: 4.3 Mesa 24.0~git2311260600.945288~oibaf~m (git-945288f 2023-11-26 mantic-oibaf-ppa), Compiler: GCC 13.2.0 + LLVM 16.0.6, File-System: ext4, Screen Resolution: 3840x2160

tpch sparkyOpenBenchmarking.orgPhoronix Test SuiteAMD Ryzen 9 7950X 16-Core @ 5.88GHz (16 Cores / 32 Threads)ASUS ROG STRIX X670E-E GAMING WIFI (1416 BIOS)AMD Device 14d832GB2000GB Samsung SSD 980 PRO 2TB + 4001GB Western Digital WD_BLACK SN850X 4000GBNVIDIA NV174 8GBNVIDIA GA104 HD AudioDELL U2723QEIntel I225-V + Intel Wi-Fi 6 AX210/AX211/AX411Ubuntu 23.106.7.0-060700rc2daily20231127-generic (x86_64)GNOME Shell 45.1X Server 1.21.1.7 + Waylandnouveau4.3 Mesa 24.0~git2311260600.945288~oibaf~m (git-945288f 2023-11-26 mantic-oibaf-ppa)GCC 13.2.0 + LLVM 16.0.6ext43840x2160ProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay ServerDisplay DriverOpenGLCompilerFile-SystemScreen ResolutionTpch Sparky BenchmarksSystem Logs- Transparent Huge Pages: madvise- Scaling Governor: amd-pstate-epp powersave (EPP: balance_performance) - CPU Microcode: 0xa601203- OpenJDK Runtime Environment (build 11.0.21+9-post-Ubuntu-0ubuntu123.10)- Python 3.11.6- gather_data_sampling: Not affected + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_rstack_overflow: Vulnerable: Safe RET no microcode + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced / Automatic IBRS IBPB: conditional STIBP: always-on RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected

a vs. b ComparisonPhoronix Test SuiteBaseline+2.2%+2.2%+4.4%+4.4%+6.6%+6.6%+8.8%+8.8%2.1%2.1%2.6%2.5%2.6%3.3%3.5%5%2.4%3.7%3.2%4%2.8%4.1%3.7%2.2%4.2%3.1%4.4%4.2%2.1%6.6%2.6%2.4%4.1%8.4%3%2.4%4%100 - G.M.O.A.Q100 - Q22100 - Q21100 - Q20100 - Q18100 - Q17100 - Q13100 - Q12100 - Q1050 - Q223.5%50 - Q172%50 - Q168.9%50 - Q142.4%50 - Q1150 - Q0950 - Q0850 - Q053%50 - Q0310 - Q2210 - Q2010 - Q162.7%10 - Q1410 - Q1310 - Q118%10 - Q094.5%10 - Q0810 - Q0510 - Q0410 - Q0310 - Q0210 - Q011 - Q221 - Q207.3%1 - Q191 - Q161 - Q143.6%1 - Q131 - Q111 - Q092%1 - Q081 - Q053.9%1 - Q043.8%Apache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-HApache Spark TPC-Hab

Apache Spark TPC-H

This is a benchmark of Apache Spark using TPC-H data-set. Apache Spark is an open-source unified analytics engine for large-scale data processing and dealing with big data. This test profile benchmarks the Apache Spark in a single-system configuration using spark-submit. The test makes use of https://github.com/ssavvides/tpch-spark/ for facilitating the TPC-H benchmark. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q22ab48121620SE +/- 0.05, N = 315.6215.30

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q21ab60120180240300SE +/- 1.17, N = 3257.50251.07

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q20ab1326395265SE +/- 0.14, N = 357.6656.28

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q19ab1122334455SE +/- 0.10, N = 350.7250.32

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q18ab306090120150SE +/- 0.40, N = 3128.13124.87

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q17ab306090120150SE +/- 0.27, N = 3123.04119.17

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q16ab3691215SE +/- 0.11, N = 313.4213.20

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q15ab1122334455SE +/- 0.10, N = 346.8946.55

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q14ab1224364860SE +/- 0.30, N = 351.2950.80

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q13ab510152025SE +/- 0.67, N = 322.8222.06

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q12ab1530456075SE +/- 0.05, N = 366.3563.17

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q11ab3691215SE +/- 0.16, N = 312.3412.13

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q10ab1530456075SE +/- 0.38, N = 366.9965.45

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q09ab20406080100SE +/- 2.94, N = 3104.65102.81

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q08ab1632486480SE +/- 1.59, N = 372.4072.32

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q07ab1530456075SE +/- 0.86, N = 367.8068.33

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q06ab1020304050SE +/- 0.08, N = 344.7244.60

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q05ab20406080100SE +/- 1.50, N = 375.2374.52

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q04ab1428425670SE +/- 0.57, N = 363.4662.61

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q03ab1530456075SE +/- 0.74, N = 368.9469.43

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q02ab3691215SE +/- 0.22, N = 311.5011.56

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q01ab1122334455SE +/- 0.19, N = 349.1849.31

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Geometric Mean Of All Queriesab1224364860SE +/- 0.11, N = 352.1051.04MIN: 12.07 / MAX: 259.51MIN: 12.13 / MAX: 251.07
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q01ab1122334455SE +/- 0.19, N = 349.1849.31
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q02ab3691215SE +/- 0.22, N = 311.5011.56
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q03ab1530456075SE +/- 0.74, N = 368.9469.43
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q04ab1428425670SE +/- 0.57, N = 363.4662.61
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q05ab20406080100SE +/- 1.50, N = 375.2374.52
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q06ab1020304050SE +/- 0.08, N = 344.7244.60
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q07ab1530456075SE +/- 0.86, N = 367.8068.33
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q08ab1632486480SE +/- 1.59, N = 372.4072.32
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q09ab20406080100SE +/- 2.94, N = 3104.65102.81
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q10ab1530456075SE +/- 0.38, N = 366.9965.45
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q11ab3691215SE +/- 0.16, N = 312.3412.13
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q12ab1530456075SE +/- 0.05, N = 366.3563.17
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q13ab510152025SE +/- 0.67, N = 322.8222.06
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q14ab1224364860SE +/- 0.30, N = 351.2950.80
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q15ab1122334455SE +/- 0.10, N = 346.8946.55
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q16ab3691215SE +/- 0.11, N = 313.4213.20
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q17ab306090120150SE +/- 0.27, N = 3123.04119.17
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q18ab306090120150SE +/- 0.40, N = 3128.13124.87
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q19ab1122334455SE +/- 0.10, N = 350.7250.32
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q20ab1326395265SE +/- 0.14, N = 357.6656.28
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q21ab60120180240300SE +/- 1.17, N = 3257.50251.07
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 100 - Q22ab48121620SE +/- 0.05, N = 315.6215.30

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q22ab246810SE +/- 0.12625543, N = 38.090088378.37519741

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q21ab306090120150SE +/- 1.18, N = 3128.89129.67

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q20ab714212835SE +/- 0.15, N = 328.7529.01

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q19ab612182430SE +/- 0.05, N = 325.3125.80

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q18ab1428425670SE +/- 0.79, N = 363.0262.97

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q17ab1326395265SE +/- 0.33, N = 358.2959.48

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q16ab246810SE +/- 0.45590060, N = 36.542334407.12703753

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q15ab612182430SE +/- 0.07, N = 323.3523.47

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q14ab612182430SE +/- 0.18, N = 325.6426.26

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q13ab3691215SE +/- 0.16, N = 311.8112.01

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q12ab816243240SE +/- 0.50, N = 332.3832.26

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q11ab246810SE +/- 0.05184602, N = 36.121728905.90383053

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q10ab816243240SE +/- 0.08, N = 333.0733.63

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q09ab1020304050SE +/- 1.28, N = 345.6744.24

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q08ab816243240SE +/- 0.70, N = 336.2834.89

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q07ab816243240SE +/- 0.34, N = 333.6433.19

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q06ab510152025SE +/- 0.04, N = 322.1222.31

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q05ab918273645SE +/- 0.30, N = 336.8637.95

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q04ab714212835SE +/- 0.51, N = 331.1431.28

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q03ab816243240SE +/- 0.48, N = 336.0935.12

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q02ab246810SE +/- 0.10852285, N = 36.857081896.84252167

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q01ab612182430SE +/- 0.18, N = 325.4125.54

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Geometric Mean Of All Queriesab612182430SE +/- 0.30, N = 325.6825.90MIN: 6.05 / MAX: 130.94MIN: 5.9 / MAX: 129.67
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q01ab612182430SE +/- 0.18, N = 325.4125.54
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q02ab246810SE +/- 0.10852285, N = 36.857081896.84252167
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q03ab816243240SE +/- 0.48, N = 336.0935.12
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q04ab714212835SE +/- 0.51, N = 331.1431.28
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q05ab918273645SE +/- 0.30, N = 336.8637.95
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q06ab510152025SE +/- 0.04, N = 322.1222.31
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q07ab816243240SE +/- 0.34, N = 333.6433.19
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q08ab816243240SE +/- 0.70, N = 336.2834.89
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q09ab1020304050SE +/- 1.28, N = 345.6744.24
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q10ab816243240SE +/- 0.08, N = 333.0733.63
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q11ab246810SE +/- 0.05184602, N = 36.121728905.90383053
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q12ab816243240SE +/- 0.50, N = 332.3832.26
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q13ab3691215SE +/- 0.16, N = 311.8112.01
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q14ab612182430SE +/- 0.18, N = 325.6426.26
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q15ab612182430SE +/- 0.07, N = 323.3523.47
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q16ab246810SE +/- 0.45590060, N = 36.542334407.12703753
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q17ab1326395265SE +/- 0.33, N = 358.2959.48
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q18ab1428425670SE +/- 0.79, N = 363.0262.97
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q19ab612182430SE +/- 0.05, N = 325.3125.80
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q20ab714212835SE +/- 0.15, N = 328.7529.01
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q21ab306090120150SE +/- 1.18, N = 3128.89129.67
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q22ab246810SE +/- 0.12625543, N = 38.090088378.37519741

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q22ab0.48860.97721.46581.95442.443SE +/- 0.02290474, N = 32.171594382.08513021

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q21ab612182430SE +/- 0.05, N = 323.4123.30

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q20ab246810SE +/- 0.05893057, N = 36.338078186.10991335

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q19ab1.17592.35183.52774.70365.8795SE +/- 0.04884219, N = 35.201790975.22612810

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q18ab3691215SE +/- 0.02, N = 312.6612.63

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q17ab3691215SE +/- 0.07, N = 311.8311.80

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q16ab0.52631.05261.57892.10522.6315SE +/- 0.03214906, N = 32.277861202.33905911

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q15ab1.1282.2563.3844.5125.64SE +/- 0.05671005, N = 34.978137975.01319218

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q14ab1.22612.45223.67834.90446.1305SE +/- 0.03750473, N = 35.449492625.33258104

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q13ab0.68011.36022.04032.72043.4005SE +/- 0.04012746, N = 33.022573472.90124249

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q12ab246810SE +/- 0.06795618, N = 36.239727816.35672379

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q11ab0.43690.87381.31071.74762.1845SE +/- 0.02123125, N = 31.797285551.94165230

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q10ab246810SE +/- 0.04310040, N = 37.105355907.15195179

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q09ab3691215SE +/- 0.14272942, N = 39.193227459.60581684

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q08ab246810SE +/- 0.08511200, N = 37.332035387.11410093

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q07ab246810SE +/- 0.15015487, N = 36.747567656.81029701

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q06ab0.99761.99522.99283.99044.988SE +/- 0.05008379, N = 34.433709144.36986017

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q05ab246810SE +/- 0.08963252, N = 37.906052597.57603073

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q04ab246810SE +/- 0.07691562, N = 36.577117766.30942202

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q03ab246810SE +/- 0.05235045, N = 37.481011397.33041668

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q02ab0.50631.01261.51892.02522.5315SE +/- 0.04460037, N = 32.250048482.11009860

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q01ab246810SE +/- 0.10785121, N = 36.311233206.14967728

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Geometric Mean Of All Queriesab1.29542.59083.88625.18166.477SE +/- 0.01148675, N = 35.754907405.75735680MIN: 1.77 / MAX: 23.49MIN: 1.94 / MAX: 23.3
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q01ab246810SE +/- 0.10785121, N = 36.311233206.14967728
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q02ab0.50631.01261.51892.02522.5315SE +/- 0.04460037, N = 32.250048482.11009860
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q03ab246810SE +/- 0.05235045, N = 37.481011397.33041668
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q04ab246810SE +/- 0.07691562, N = 36.577117766.30942202
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q05ab246810SE +/- 0.08963252, N = 37.906052597.57603073
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q06ab0.99761.99522.99283.99044.988SE +/- 0.05008379, N = 34.433709144.36986017
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q07ab246810SE +/- 0.15015487, N = 36.747567656.81029701
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q08ab246810SE +/- 0.08511200, N = 37.332035387.11410093
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q09ab3691215SE +/- 0.14272942, N = 39.193227459.60581684
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q10ab246810SE +/- 0.04310040, N = 37.105355907.15195179
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q11ab0.43690.87381.31071.74762.1845SE +/- 0.02123125, N = 31.797285551.94165230
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q12ab246810SE +/- 0.06795618, N = 36.239727816.35672379
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q13ab0.68011.36022.04032.72043.4005SE +/- 0.04012746, N = 33.022573472.90124249
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q14ab1.22612.45223.67834.90446.1305SE +/- 0.03750473, N = 35.449492625.33258104
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q15ab1.1282.2563.3844.5125.64SE +/- 0.05671005, N = 34.978137975.01319218
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q16ab0.52631.05261.57892.10522.6315SE +/- 0.03214906, N = 32.277861202.33905911
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q17ab3691215SE +/- 0.07, N = 311.8311.80
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q18ab3691215SE +/- 0.02, N = 312.6612.63
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q19ab1.17592.35183.52774.70365.8795SE +/- 0.04884219, N = 35.201790975.22612810
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q20ab246810SE +/- 0.05893057, N = 36.338078186.10991335
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q21ab612182430SE +/- 0.05, N = 323.4123.30
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Q22ab0.48860.97721.46581.95442.443SE +/- 0.02290474, N = 32.171594382.08513021

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q22ab0.13980.27960.41940.55920.699SE +/- 0.03385261, N = 30.621126870.60666102

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q21ab0.81441.62882.44323.25764.072SE +/- 0.04461235, N = 33.594456043.61977267

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q20ab0.25950.5190.77851.0381.2975SE +/- 0.02430008, N = 31.074701751.15345001

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q19ab0.15610.31220.46830.62440.7805SE +/- 0.03020707, N = 30.693959850.66654742

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q18ab0.40260.80521.20781.61042.013SE +/- 0.05290042, N = 31.789312761.77616072

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q17ab0.3290.6580.9871.3161.645SE +/- 0.02547655, N = 31.462197541.44221175

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q16ab0.17450.3490.52350.6980.8725SE +/- 0.01281809, N = 30.775601310.71527606

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q15ab0.17470.34940.52410.69880.8735SE +/- 0.01635970, N = 30.776500920.77098012

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q14ab0.17220.34440.51660.68880.861SE +/- 0.00590603, N = 30.738675460.76540375

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q13ab0.17810.35620.53430.71240.8905SE +/- 0.01146951, N = 30.791692830.76867819

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q12ab0.23960.47920.71880.95841.198SE +/- 0.02665135, N = 31.057829341.06473088

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q11ab0.14070.28140.42210.56280.7035SE +/- 0.00652178, N = 30.625227130.61058140

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q10ab0.29020.58040.87061.16081.451SE +/- 0.00838453, N = 31.266760431.28957009

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q09ab0.45710.91421.37131.82842.2855SE +/- 0.01974284, N = 31.990826252.03148746

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q08ab0.26390.52780.79171.05561.3195SE +/- 0.00999755, N = 31.172779881.12742186

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q07ab0.31790.63580.95371.27161.5895SE +/- 0.03064907, N = 31.412877361.39594340

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q06ab0.12090.24180.36270.48360.6045SE +/- 0.00241116, N = 30.533354680.53715831

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q05ab0.33460.66921.00381.33841.673SE +/- 0.01308397, N = 31.430737021.48697722

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q04ab0.28960.57920.86881.15841.448SE +/- 0.03111532, N = 31.239550631.28710282

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q03ab0.31150.6230.93451.2461.5575SE +/- 0.05306582, N = 31.384356901.36037207

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q02ab0.26740.53480.80221.06961.337SE +/- 0.02240378, N = 31.172841791.18847537

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q01ab0.48390.96781.45171.93562.4195SE +/- 0.02370651, N = 32.150497442.13585591

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Geometric Mean Of All Queriesab0.2420.4840.7260.9681.21SE +/- 0.01125755, N = 31.075517761.06830837MIN: 0.55 / MAX: 3.68MIN: 0.61 / MAX: 3.62
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q01ab0.48390.96781.45171.93562.4195SE +/- 0.02370651, N = 32.150497442.13585591
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q02ab0.26740.53480.80221.06961.337SE +/- 0.02240378, N = 31.172841791.18847537
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q03ab0.31150.6230.93451.2461.5575SE +/- 0.05306582, N = 31.384356901.36037207
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q04ab0.28960.57920.86881.15841.448SE +/- 0.03111532, N = 31.239550631.28710282
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q05ab0.33460.66921.00381.33841.673SE +/- 0.01308397, N = 31.430737021.48697722
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q06ab0.12090.24180.36270.48360.6045SE +/- 0.00241116, N = 30.533354680.53715831
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q07ab0.31790.63580.95371.27161.5895SE +/- 0.03064907, N = 31.412877361.39594340
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q08ab0.26390.52780.79171.05561.3195SE +/- 0.00999755, N = 31.172779881.12742186
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q09ab0.45710.91421.37131.82842.2855SE +/- 0.01974284, N = 31.990826252.03148746
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q10ab0.29020.58040.87061.16081.451SE +/- 0.00838453, N = 31.266760431.28957009
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q11ab0.14070.28140.42210.56280.7035SE +/- 0.00652178, N = 30.625227130.61058140
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q12ab0.23960.47920.71880.95841.198SE +/- 0.02665135, N = 31.057829341.06473088
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q13ab0.17810.35620.53430.71240.8905SE +/- 0.01146951, N = 30.791692830.76867819
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q14ab0.17220.34440.51660.68880.861SE +/- 0.00590603, N = 30.738675460.76540375
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q15ab0.17470.34940.52410.69880.8735SE +/- 0.01635970, N = 30.776500920.77098012
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q16ab0.17450.3490.52350.6980.8725SE +/- 0.01281809, N = 30.775601310.71527606
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q17ab0.3290.6580.9871.3161.645SE +/- 0.02547655, N = 31.462197541.44221175
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q18ab0.40260.80521.20781.61042.013SE +/- 0.05290042, N = 31.789312761.77616072
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q19ab0.15610.31220.46830.62440.7805SE +/- 0.03020707, N = 30.693959850.66654742
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q20ab0.25950.5190.77851.0381.2975SE +/- 0.02430008, N = 31.074701751.15345001
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q21ab0.81441.62882.44323.25764.072SE +/- 0.04461235, N = 33.594456043.61977267
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Q22ab0.13980.27960.41940.55920.699SE +/- 0.03385261, N = 30.621126870.60666102

a

Kernel Notes: Transparent Huge Pages: madvise
Processor Notes: Scaling Governor: amd-pstate-epp powersave (EPP: balance_performance) - CPU Microcode: 0xa601203
Java Notes: OpenJDK Runtime Environment (build 11.0.21+9-post-Ubuntu-0ubuntu123.10)
Python Notes: Python 3.11.6
Security Notes: gather_data_sampling: Not affected + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_rstack_overflow: Vulnerable: Safe RET no microcode + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced / Automatic IBRS IBPB: conditional STIBP: always-on RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected

Testing initiated at 4 December 2023 20:28 by user pts.

b

Processor: AMD Ryzen 9 7950X 16-Core @ 5.88GHz (16 Cores / 32 Threads), Motherboard: ASUS ROG STRIX X670E-E GAMING WIFI (1416 BIOS), Chipset: AMD Device 14d8, Memory: 32GB, Disk: 2000GB Samsung SSD 980 PRO 2TB + 4001GB Western Digital WD_BLACK SN850X 4000GB, Graphics: NVIDIA NV174 8GB, Audio: NVIDIA GA104 HD Audio, Monitor: DELL U2723QE, Network: Intel I225-V + Intel Wi-Fi 6 AX210/AX211/AX411

OS: Ubuntu 23.10, Kernel: 6.7.0-060700rc2daily20231127-generic (x86_64), Desktop: GNOME Shell 45.1, Display Server: X Server 1.21.1.7 + Wayland, Display Driver: nouveau, OpenGL: 4.3 Mesa 24.0~git2311260600.945288~oibaf~m (git-945288f 2023-11-26 mantic-oibaf-ppa), Compiler: GCC 13.2.0 + LLVM 16.0.6, File-System: ext4, Screen Resolution: 3840x2160

Kernel Notes: Transparent Huge Pages: madvise
Processor Notes: Scaling Governor: amd-pstate-epp powersave (EPP: balance_performance) - CPU Microcode: 0xa601203
Java Notes: OpenJDK Runtime Environment (build 11.0.21+9-post-Ubuntu-0ubuntu123.10)
Python Notes: Python 3.11.6
Security Notes: gather_data_sampling: Not affected + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_rstack_overflow: Vulnerable: Safe RET no microcode + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced / Automatic IBRS IBPB: conditional STIBP: always-on RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected

Testing initiated at 4 December 2023 22:52 by user pts.