tpch raptor lake refresh Intel Core i9-14900K testing with a ASUS PRIME Z790-P WIFI (1402 BIOS) and AMD Radeon 15GB on Ubuntu 23.10 via the Phoronix Test Suite. a: Processor: Intel Core i9-14900K @ 5.70GHz (24 Cores / 32 Threads), Motherboard: ASUS PRIME Z790-P WIFI (1402 BIOS), Chipset: Intel Device 7a27, Memory: 32GB, Disk: Western Digital WD_BLACK SN850X 1000GB, Graphics: AMD Radeon 15GB (1617/1124MHz), Audio: Realtek ALC897, Monitor: ASUS VP28U OS: Ubuntu 23.10, Kernel: 6.5.0-10-generic (x86_64), Desktop: GNOME Shell 45.0, Display Server: X Server 1.21.1.7 + Wayland, OpenGL: 4.6 Mesa 24.0~git2311100600.05fb6b~oibaf~m (git-05fb6b9 2023-11-10 mantic-oibaf-ppa) (LLVM 16.0.6 DRM 3.54), Compiler: GCC 13.2.0, File-System: ext4, Screen Resolution: 3840x2160 b: Processor: Intel Core i9-14900K @ 5.70GHz (24 Cores / 32 Threads), Motherboard: ASUS PRIME Z790-P WIFI (1402 BIOS), Chipset: Intel Device 7a27, Memory: 32GB, Disk: Western Digital WD_BLACK SN850X 1000GB, Graphics: AMD Radeon 15GB (1617/1124MHz), Audio: Realtek ALC897, Monitor: ASUS VP28U OS: Ubuntu 23.10, Kernel: 6.5.0-10-generic (x86_64), Desktop: GNOME Shell 45.0, Display Server: X Server 1.21.1.7 + Wayland, OpenGL: 4.6 Mesa 24.0~git2311100600.05fb6b~oibaf~m (git-05fb6b9 2023-11-10 mantic-oibaf-ppa) (LLVM 16.0.6 DRM 3.54), Compiler: GCC 13.2.0, File-System: ext4, Screen Resolution: 3840x2160 c: Processor: Intel Core i9-14900K @ 5.70GHz (24 Cores / 32 Threads), Motherboard: ASUS PRIME Z790-P WIFI (1402 BIOS), Chipset: Intel Device 7a27, Memory: 32GB, Disk: Western Digital WD_BLACK SN850X 1000GB, Graphics: AMD Radeon 15GB (1617/1124MHz), Audio: Realtek ALC897, Monitor: ASUS VP28U OS: Ubuntu 23.10, Kernel: 6.5.0-10-generic (x86_64), Desktop: GNOME Shell 45.0, Display Server: X Server 1.21.1.7 + Wayland, OpenGL: 4.6 Mesa 24.0~git2311100600.05fb6b~oibaf~m (git-05fb6b9 2023-11-10 mantic-oibaf-ppa) (LLVM 16.0.6 DRM 3.54), Compiler: GCC 13.2.0, File-System: ext4, Screen Resolution: 3840x2160 Apache Spark TPC-H 3.5 Scale Factor: 1 - Geometric Mean Of All Queries Seconds < Lower Is Better a . 0.87776299 |=============================================================== b . 0.87254224 |============================================================== c . 0.88304768 |=============================================================== Apache Spark TPC-H 3.5 Scale Factor: 1 - Q01 Seconds < Lower Is Better a . 1.96544274 |============================================================== b . 2.00511034 |=============================================================== c . 2.00340517 |=============================================================== Apache Spark TPC-H 3.5 Scale Factor: 1 - Q02 Seconds < Lower Is Better a . 1.07954426 |============================================================ b . 1.12688188 |=============================================================== c . 1.02245081 |========================================================= Apache Spark TPC-H 3.5 Scale Factor: 1 - Q03 Seconds < Lower Is Better a . 1.11738197 |=========================================================== b . 1.19231228 |=============================================================== c . 1.15820253 |============================================================= Apache Spark TPC-H 3.5 Scale Factor: 1 - Q04 Seconds < Lower Is Better a . 0.95427678 |============================================================ b . 0.94041192 |=========================================================== c . 1.00064748 |=============================================================== Apache Spark TPC-H 3.5 Scale Factor: 1 - Q05 Seconds < Lower Is Better a . 1.12886059 |============================================================ b . 1.18735146 |=============================================================== c . 1.18902523 |=============================================================== Apache Spark TPC-H 3.5 Scale Factor: 1 - Q06 Seconds < Lower Is Better a . 0.44549557 |=============================================================== b . 0.44799783 |=============================================================== c . 0.44866244 |=============================================================== Apache Spark TPC-H 3.5 Scale Factor: 1 - Q07 Seconds < Lower Is Better a . 1.07457670 |============================================================= b . 1.07341138 |============================================================= c . 1.11568165 |=============================================================== Apache Spark TPC-H 3.5 Scale Factor: 1 - Q08 Seconds < Lower Is Better a . 0.95694945 |============================================================== b . 0.93207542 |============================================================= c . 0.96675164 |=============================================================== Apache Spark TPC-H 3.5 Scale Factor: 1 - Q09 Seconds < Lower Is Better a . 1.75682239 |=============================================================== b . 1.67170942 |============================================================ c . 1.70255299 |============================================================= Apache Spark TPC-H 3.5 Scale Factor: 1 - Q10 Seconds < Lower Is Better a . 1.00754728 |============================================================= b . 1.04567937 |=============================================================== c . 1.03905877 |=============================================================== Apache Spark TPC-H 3.5 Scale Factor: 1 - Q11 Seconds < Lower Is Better a . 0.50225742 |=============================================================== b . 0.47652994 |============================================================ c . 0.47693579 |============================================================ Apache Spark TPC-H 3.5 Scale Factor: 1 - Q12 Seconds < Lower Is Better a . 0.82615193 |============================================================== b . 0.84116596 |=============================================================== c . 0.81592511 |============================================================= Apache Spark TPC-H 3.5 Scale Factor: 1 - Q13 Seconds < Lower Is Better a . 0.62415369 |=========================================================== b . 0.66103216 |=============================================================== c . 0.63128043 |============================================================ Apache Spark TPC-H 3.5 Scale Factor: 1 - Q14 Seconds < Lower Is Better a . 0.60899427 |=============================================================== b . 0.59366890 |============================================================= c . 0.60517108 |=============================================================== Apache Spark TPC-H 3.5 Scale Factor: 1 - Q15 Seconds < Lower Is Better a . 0.63115869 |============================================================== b . 0.64634061 |=============================================================== c . 0.62265047 |============================================================= Apache Spark TPC-H 3.5 Scale Factor: 1 - Q16 Seconds < Lower Is Better a . 0.61313494 |============================================================== b . 0.59978543 |============================================================ c . 0.62539817 |=============================================================== Apache Spark TPC-H 3.5 Scale Factor: 1 - Q17 Seconds < Lower Is Better a . 1.16818933 |=============================================================== b . 1.14070034 |============================================================== c . 1.15393855 |============================================================== Apache Spark TPC-H 3.5 Scale Factor: 1 - Q18 Seconds < Lower Is Better a . 1.39310459 |============================================================= b . 1.44711113 |=============================================================== c . 1.44796231 |=============================================================== Apache Spark TPC-H 3.5 Scale Factor: 1 - Q19 Seconds < Lower Is Better a . 0.61544267 |============================================================= b . 0.57384835 |========================================================= c . 0.63374029 |=============================================================== Apache Spark TPC-H 3.5 Scale Factor: 1 - Q20 Seconds < Lower Is Better a . 0.88960985 |============================================================== b . 0.89402952 |=============================================================== c . 0.89802847 |=============================================================== Apache Spark TPC-H 3.5 Scale Factor: 1 - Q21 Seconds < Lower Is Better a . 3.03155541 |============================================================= b . 3.13926904 |=============================================================== c . 3.05967259 |============================================================= Apache Spark TPC-H 3.5 Scale Factor: 1 - Q22 Seconds < Lower Is Better a . 0.51143038 |=========================================================== b . 0.49454381 |========================================================= c . 0.54503864 |=============================================================== Apache Spark TPC-H 3.5 Scale Factor: 10 - Geometric Mean Of All Queries Seconds < Lower Is Better a . 4.62216384 |=============================================================== b . 4.58435868 |============================================================== c . 4.60235157 |=============================================================== Apache Spark TPC-H 3.5 Scale Factor: 10 - Q01 Seconds < Lower Is Better a . 5.41686615 |============================================================== b . 5.40697082 |============================================================== c . 5.49814351 |=============================================================== Apache Spark TPC-H 3.5 Scale Factor: 10 - Q02 Seconds < Lower Is Better a . 1.92796246 |============================================================== b . 1.96285824 |=============================================================== c . 1.96273367 |=============================================================== Apache Spark TPC-H 3.5 Scale Factor: 10 - Q03 Seconds < Lower Is Better a . 6.31316630 |=============================================================== b . 6.17067830 |============================================================== c . 6.28960355 |=============================================================== Apache Spark TPC-H 3.5 Scale Factor: 10 - Q04 Seconds < Lower Is Better a . 5.30403455 |=============================================================== b . 5.32599115 |=============================================================== c . 5.28160683 |============================================================== Apache Spark TPC-H 3.5 Scale Factor: 10 - Q05 Seconds < Lower Is Better a . 6.50930007 |=============================================================== b . 6.45656920 |============================================================== c . 6.52946170 |=============================================================== Apache Spark TPC-H 3.5 Scale Factor: 10 - Q06 Seconds < Lower Is Better a . 3.55662521 |============================================================== b . 3.58518855 |=============================================================== c . 3.55979506 |=============================================================== Apache Spark TPC-H 3.5 Scale Factor: 10 - Q07 Seconds < Lower Is Better a . 5.48920854 |============================================================== b . 5.52843539 |============================================================== c . 5.61377939 |=============================================================== Apache Spark TPC-H 3.5 Scale Factor: 10 - Q08 Seconds < Lower Is Better a . 6.09259685 |=============================================================== b . 6.05554024 |=============================================================== c . 5.98248800 |============================================================== Apache Spark TPC-H 3.5 Scale Factor: 10 - Q09 Seconds < Lower Is Better a . 8.06222518 |=============================================================== b . 7.67208004 |============================================================ c . 7.74055862 |============================================================ Apache Spark TPC-H 3.5 Scale Factor: 10 - Q10 Seconds < Lower Is Better a . 5.76961819 |============================================================= b . 5.54901536 |=========================================================== c . 5.94530900 |=============================================================== Apache Spark TPC-H 3.5 Scale Factor: 10 - Q11 Seconds < Lower Is Better a . 1.37076247 |============================================================ b . 1.29526591 |========================================================= c . 1.43875642 |=============================================================== Apache Spark TPC-H 3.5 Scale Factor: 10 - Q12 Seconds < Lower Is Better a . 4.95396805 |=============================================================== b . 4.96768411 |=============================================================== c . 4.90439066 |============================================================== Apache Spark TPC-H 3.5 Scale Factor: 10 - Q13 Seconds < Lower Is Better a . 2.36085304 |=============================================================== b . 2.31897950 |============================================================== c . 2.27665901 |============================================================= Apache Spark TPC-H 3.5 Scale Factor: 10 - Q14 Seconds < Lower Is Better a . 4.21481419 |=========================================================== b . 4.49574836 |=============================================================== c . 4.12753487 |========================================================== Apache Spark TPC-H 3.5 Scale Factor: 10 - Q15 Seconds < Lower Is Better a . 3.89074699 |============================================================= b . 3.91900571 |============================================================= c . 4.02124381 |=============================================================== Apache Spark TPC-H 3.5 Scale Factor: 10 - Q16 Seconds < Lower Is Better a . 1.87959651 |=============================================================== b . 1.75708278 |=========================================================== c . 1.69990770 |========================================================= Apache Spark TPC-H 3.5 Scale Factor: 10 - Q17 Seconds < Lower Is Better a . 9.53389549 |============================================================== b . 9.50786209 |============================================================== c . 9.68347200 |=============================================================== Apache Spark TPC-H 3.5 Scale Factor: 10 - Q18 Seconds < Lower Is Better a . 10.11 |==================================================================== b . 10.08 |==================================================================== c . 10.13 |==================================================================== Apache Spark TPC-H 3.5 Scale Factor: 10 - Q19 Seconds < Lower Is Better a . 4.16023095 |=============================================================== b . 4.06491566 |============================================================== c . 4.15926790 |=============================================================== Apache Spark TPC-H 3.5 Scale Factor: 10 - Q20 Seconds < Lower Is Better a . 4.88993009 |=============================================================== b . 4.91493909 |=============================================================== c . 4.83694919 |============================================================== Apache Spark TPC-H 3.5 Scale Factor: 10 - Q21 Seconds < Lower Is Better a . 19.76 |==================================================================== b . 19.52 |=================================================================== c . 19.47 |=================================================================== Apache Spark TPC-H 3.5 Scale Factor: 10 - Q22 Seconds < Lower Is Better a . 1.74507828 |========================================================== b . 1.88879923 |=============================================================== c . 1.84473832 |============================================================== Apache Spark TPC-H 3.5 Scale Factor: 50 - Geometric Mean Of All Queries Seconds < Lower Is Better a . 20.93 |==================================================================== b . 21.07 |==================================================================== c . 20.79 |=================================================================== Apache Spark TPC-H 3.5 Scale Factor: 50 - Q01 Seconds < Lower Is Better a . 21.31 |=================================================================== b . 21.63 |==================================================================== c . 21.72 |==================================================================== Apache Spark TPC-H 3.5 Scale Factor: 50 - Q02 Seconds < Lower Is Better a . 5.93661642 |=============================================================== b . 5.61999639 |============================================================ c . 5.70603227 |============================================================= Apache Spark TPC-H 3.5 Scale Factor: 50 - Q03 Seconds < Lower Is Better a . 29.69 |==================================================================== b . 29.43 |=================================================================== c . 29.43 |=================================================================== Apache Spark TPC-H 3.5 Scale Factor: 50 - Q04 Seconds < Lower Is Better a . 25.17 |================================================================= b . 26.33 |==================================================================== c . 25.36 |================================================================= Apache Spark TPC-H 3.5 Scale Factor: 50 - Q05 Seconds < Lower Is Better a . 30.44 |==================================================================== b . 30.07 |=================================================================== c . 30.47 |==================================================================== Apache Spark TPC-H 3.5 Scale Factor: 50 - Q06 Seconds < Lower Is Better a . 17.59 |==================================================================== b . 17.68 |==================================================================== c . 17.70 |==================================================================== Apache Spark TPC-H 3.5 Scale Factor: 50 - Q07 Seconds < Lower Is Better a . 27.19 |==================================================================== b . 27.04 |=================================================================== c . 27.26 |==================================================================== Apache Spark TPC-H 3.5 Scale Factor: 50 - Q08 Seconds < Lower Is Better a . 28.89 |=================================================================== b . 28.70 |=================================================================== c . 29.17 |==================================================================== Apache Spark TPC-H 3.5 Scale Factor: 50 - Q09 Seconds < Lower Is Better a . 37.07 |==================================================================== b . 36.35 |=================================================================== c . 36.77 |=================================================================== Apache Spark TPC-H 3.5 Scale Factor: 50 - Q10 Seconds < Lower Is Better a . 26.81 |=================================================================== b . 26.66 |=================================================================== c . 27.14 |==================================================================== Apache Spark TPC-H 3.5 Scale Factor: 50 - Q11 Seconds < Lower Is Better a . 4.56721529 |============================================================== b . 4.67158937 |=============================================================== c . 4.51339372 |============================================================= Apache Spark TPC-H 3.5 Scale Factor: 50 - Q12 Seconds < Lower Is Better a . 25.95 |==================================================================== b . 25.69 |=================================================================== c . 25.56 |=================================================================== Apache Spark TPC-H 3.5 Scale Factor: 50 - Q13 Seconds < Lower Is Better a . 10.46 |==================================================================== b . 10.27 |=================================================================== c . 10.21 |================================================================== Apache Spark TPC-H 3.5 Scale Factor: 50 - Q14 Seconds < Lower Is Better a . 20.20 |=================================================================== b . 20.35 |==================================================================== c . 20.35 |==================================================================== Apache Spark TPC-H 3.5 Scale Factor: 50 - Q15 Seconds < Lower Is Better a . 18.55 |==================================================================== b . 18.56 |==================================================================== c . 18.66 |==================================================================== Apache Spark TPC-H 3.5 Scale Factor: 50 - Q16 Seconds < Lower Is Better a . 5.83705902 |=============================================================== b . 5.42722893 |=========================================================== c . 5.18993664 |======================================================== Apache Spark TPC-H 3.5 Scale Factor: 50 - Q17 Seconds < Lower Is Better a . 47.40 |==================================================================== b . 47.11 |==================================================================== c . 47.34 |==================================================================== Apache Spark TPC-H 3.5 Scale Factor: 50 - Q18 Seconds < Lower Is Better a . 49.58 |================================================================ b . 52.83 |==================================================================== c . 50.04 |================================================================ Apache Spark TPC-H 3.5 Scale Factor: 50 - Q19 Seconds < Lower Is Better a . 20.10 |=========================================================== b . 23.01 |==================================================================== c . 20.29 |============================================================ Apache Spark TPC-H 3.5 Scale Factor: 50 - Q20 Seconds < Lower Is Better a . 23.00 |==================================================================== b . 23.06 |==================================================================== c . 23.12 |==================================================================== Apache Spark TPC-H 3.5 Scale Factor: 50 - Q21 Seconds < Lower Is Better a . 105.89 |================================================================== b . 106.39 |=================================================================== c . 107.18 |=================================================================== Apache Spark TPC-H 3.5 Scale Factor: 50 - Q22 Seconds < Lower Is Better a . 7.25329781 |============================================================== b . 7.36617533 |=============================================================== c . 7.26467959 |==============================================================