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
Show Result Confidence Charts
Allow Limiting Results To Certain Suite(s)

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
Toggle/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 Behavior (Only Show Selected Data)
  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):


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

tpch sparkyspark-tpch: 100 - Geometric Mean Of All Queriesspark-tpch: 50 - Geometric Mean Of All Queriesspark-tpch: 1 - Geometric Mean Of All Queriesspark-tpch: 10 - Geometric Mean Of All Queriesspark-tpch: 100 - Q22spark-tpch: 100 - Q21spark-tpch: 100 - Q20spark-tpch: 100 - Q19spark-tpch: 100 - Q18spark-tpch: 100 - Q17spark-tpch: 100 - Q16spark-tpch: 100 - Q15spark-tpch: 100 - Q14spark-tpch: 100 - Q13spark-tpch: 100 - Q12spark-tpch: 100 - Q11spark-tpch: 100 - Q10spark-tpch: 100 - Q09spark-tpch: 100 - Q08spark-tpch: 100 - Q07spark-tpch: 100 - Q06spark-tpch: 100 - Q05spark-tpch: 100 - Q04spark-tpch: 100 - Q03spark-tpch: 100 - Q02spark-tpch: 100 - Q01spark-tpch: 50 - Q22spark-tpch: 50 - Q21spark-tpch: 50 - Q20spark-tpch: 50 - Q19spark-tpch: 50 - Q18spark-tpch: 50 - Q17spark-tpch: 50 - Q16spark-tpch: 50 - Q15spark-tpch: 50 - Q14spark-tpch: 50 - Q13spark-tpch: 50 - Q12spark-tpch: 50 - Q11spark-tpch: 50 - Q10spark-tpch: 50 - Q09spark-tpch: 50 - Q08spark-tpch: 50 - Q07spark-tpch: 50 - Q06spark-tpch: 50 - Q05spark-tpch: 50 - Q04spark-tpch: 50 - Q03spark-tpch: 50 - Q02spark-tpch: 50 - Q01spark-tpch: 10 - Q22spark-tpch: 10 - Q21spark-tpch: 10 - Q20spark-tpch: 10 - Q19spark-tpch: 10 - Q18spark-tpch: 10 - Q17spark-tpch: 10 - Q16spark-tpch: 10 - Q15spark-tpch: 10 - Q14spark-tpch: 10 - Q13spark-tpch: 10 - Q12spark-tpch: 10 - Q11spark-tpch: 10 - Q10spark-tpch: 10 - Q09spark-tpch: 10 - Q08spark-tpch: 10 - Q07spark-tpch: 10 - Q06spark-tpch: 10 - Q05spark-tpch: 10 - Q04spark-tpch: 10 - Q03spark-tpch: 10 - Q02spark-tpch: 10 - Q01spark-tpch: 1 - Q22spark-tpch: 1 - Q21spark-tpch: 1 - Q20spark-tpch: 1 - Q19spark-tpch: 1 - Q18spark-tpch: 1 - Q17spark-tpch: 1 - Q16spark-tpch: 1 - Q15spark-tpch: 1 - Q14spark-tpch: 1 - Q13spark-tpch: 1 - Q12spark-tpch: 1 - Q11spark-tpch: 1 - Q10spark-tpch: 1 - Q09spark-tpch: 1 - Q08spark-tpch: 1 - Q07spark-tpch: 1 - Q06spark-tpch: 1 - Q05spark-tpch: 1 - Q04spark-tpch: 1 - Q03spark-tpch: 1 - Q02spark-tpch: 1 - Q01ab52.1022899825.679560471.075517765.7549074015.61734390257.5032246957.6570739850.71526591128.13427480123.0399907413.4203198846.8868802451.2898979222.8182888066.3500747712.3399690066.99342346104.6476593072.4036076967.804687544.7201232975.2306823763.4572690368.9359105411.4985796649.179523478.09008837128.8945261628.7485974625.3085791363.0175603258.293804176.5423344023.3464965825.6421648711.8073056532.375083296.1217289033.0668780045.6652603236.2811991433.6409390822.1198902136.8637809731.1353219436.093758906.8570818925.412600842.1715943823.409882236.338078185.2017909712.6639394711.829778992.277861204.978137975.449492623.022573476.239727811.797285557.105355909.193227457.332035386.747567654.433709147.906052596.577117767.481011392.250048486.311233200.621126873.594456041.074701750.693959851.789312761.462197540.775601310.776500920.738675460.791692831.057829340.625227131.266760431.990826251.172779881.412877360.533354681.430737021.239550631.384356901.172841792.1504974451.0397653625.90475391.068308375.757356815.30221462251.074829156.2781066950.32149124124.86743164119.1663513213.1970300746.5463180550.800483722.0551490863.1657104512.1318111465.45317078102.8100509672.3209457468.3340606744.5996398974.5218429662.613918369.4283981311.5603275349.307121288.37519741129.6703338629.0145530725.7982997962.9690666259.476913457.1270375323.4703636226.2560977912.0069656432.26219945.9038305333.6288948144.2379646334.8936042833.1927261422.3126640337.9534797731.2826957735.117149356.8425216725.540374762.0851302123.304231646.109913355.226128112.6298131911.803380972.339059115.013192185.332581042.901242496.356723791.94165237.151951799.605816847.114100936.810297014.369860177.576030736.309422027.330416682.11009866.149677280.606661023.619772671.153450010.666547421.776160721.442211750.715276060.770980120.765403750.768678191.064730880.61058141.289570092.031487461.127421861.39594340.537158311.486977221.287102821.360372071.188475372.13585591OpenBenchmarking.org

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 - Geometric Mean Of All Queriesba1224364860SE +/- 0.11, N = 351.0452.10MIN: 12.13 / MAX: 251.07MIN: 12.07 / MAX: 259.51

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Geometric Mean Of All Queriesba612182430SE +/- 0.30, N = 325.9025.68MIN: 5.9 / MAX: 129.67MIN: 6.05 / MAX: 130.94

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 1 - Geometric Mean Of All Queriesba0.2420.4840.7260.9681.21SE +/- 0.01125755, N = 31.068308371.07551776MIN: 0.61 / MAX: 3.62MIN: 0.55 / MAX: 3.68

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 10 - Geometric Mean Of All Queriesba1.29542.59083.88625.18166.477SE +/- 0.01148675, N = 35.757356805.75490740MIN: 1.94 / MAX: 23.3MIN: 1.77 / MAX: 23.49