clickhouse raptor lake
Intel Core i9-13900K testing with a ASUS PRIME Z790-P WIFI (0602 BIOS) and AMD Radeon RX 6700 XT 12GB on Ubuntu 22.10 via the Phoronix Test Suite.


a: 

	Processor: Intel Core i9-13900K @ 5.50GHz (24 Cores / 32 Threads), Motherboard: ASUS PRIME Z790-P WIFI (0602 BIOS), Chipset: Intel Device 7a27, Memory: 32GB, Disk: 2048GB SOLIDIGM SSDPFKKW020X7, Graphics: AMD Radeon RX 6700 XT 12GB (2855/1000MHz), Audio: Realtek ALC897, Monitor: ASUS VP28U, Network: Intel Device 7a70

	OS: Ubuntu 22.10, Kernel: 6.2.0-rc2-phx (x86_64), Desktop: GNOME Shell 43.1, Display Server: X Server 1.21.1.4 + Wayland, OpenGL: 4.6 Mesa 23.0.0-devel (git-fc0e23b 2023-01-02 kinetic-oibaf-ppa) (LLVM 15.0.5 DRM 3.49), Vulkan: 1.3.238, Compiler: GCC 12.2.0, File-System: ext4, Screen Resolution: 3840x2160

b: 

	Processor: Intel Core i9-13900K @ 5.50GHz (24 Cores / 32 Threads), Motherboard: ASUS PRIME Z790-P WIFI (0602 BIOS), Chipset: Intel Device 7a27, Memory: 32GB, Disk: 2048GB SOLIDIGM SSDPFKKW020X7, Graphics: AMD Radeon RX 6700 XT 12GB (2855/1000MHz), Audio: Realtek ALC897, Monitor: ASUS VP28U, Network: Intel Device 7a70

	OS: Ubuntu 22.10, Kernel: 6.2.0-rc2-phx (x86_64), Desktop: GNOME Shell 43.1, Display Server: X Server 1.21.1.4 + Wayland, OpenGL: 4.6 Mesa 23.0.0-devel (git-fc0e23b 2023-01-02 kinetic-oibaf-ppa) (LLVM 15.0.5 DRM 3.49), Vulkan: 1.3.238, Compiler: GCC 12.2.0, File-System: ext4, Screen Resolution: 3840x2160

c: 

	Processor: Intel Core i9-13900K @ 5.50GHz (24 Cores / 32 Threads), Motherboard: ASUS PRIME Z790-P WIFI (0602 BIOS), Chipset: Intel Device 7a27, Memory: 32GB, Disk: 2048GB SOLIDIGM SSDPFKKW020X7, Graphics: AMD Radeon RX 6700 XT 12GB (2855/1000MHz), Audio: Realtek ALC897, Monitor: ASUS VP28U, Network: Intel Device 7a70

	OS: Ubuntu 22.10, Kernel: 6.2.0-rc2-phx (x86_64), Desktop: GNOME Shell 43.1, Display Server: X Server 1.21.1.4 + Wayland, OpenGL: 4.6 Mesa 23.0.0-devel (git-fc0e23b 2023-01-02 kinetic-oibaf-ppa) (LLVM 15.0.5 DRM 3.49), Vulkan: 1.3.238, Compiler: GCC 12.2.0, File-System: ext4, Screen Resolution: 3840x2160

d: 

	Processor: Intel Core i9-13900K @ 5.50GHz (24 Cores / 32 Threads), Motherboard: ASUS PRIME Z790-P WIFI (0602 BIOS), Chipset: Intel Device 7a27, Memory: 32GB, Disk: 2048GB SOLIDIGM SSDPFKKW020X7, Graphics: AMD Radeon RX 6700 XT 12GB (2855/1000MHz), Audio: Realtek ALC897, Monitor: ASUS VP28U, Network: Intel Device 7a70

	OS: Ubuntu 22.10, Kernel: 6.2.0-rc2-phx (x86_64), Desktop: GNOME Shell 43.1, Display Server: X Server 1.21.1.4 + Wayland, OpenGL: 4.6 Mesa 23.0.0-devel (git-fc0e23b 2023-01-02 kinetic-oibaf-ppa) (LLVM 15.0.5 DRM 3.49), Vulkan: 1.3.238, Compiler: GCC 12.2.0, File-System: ext4, Screen Resolution: 3840x2160

e: 

	Processor: Intel Core i9-13900K @ 5.50GHz (24 Cores / 32 Threads), Motherboard: ASUS PRIME Z790-P WIFI (0602 BIOS), Chipset: Intel Device 7a27, Memory: 32GB, Disk: 2048GB SOLIDIGM SSDPFKKW020X7, Graphics: AMD Radeon RX 6700 XT 12GB (2855/1000MHz), Audio: Realtek ALC897, Monitor: ASUS VP28U, Network: Intel Device 7a70

	OS: Ubuntu 22.10, Kernel: 6.2.0-rc2-phx (x86_64), Desktop: GNOME Shell 43.1, Display Server: X Server 1.21.1.4 + Wayland, OpenGL: 4.6 Mesa 23.0.0-devel (git-fc0e23b 2023-01-02 kinetic-oibaf-ppa) (LLVM 15.0.5 DRM 3.49), Vulkan: 1.3.238, Compiler: GCC 12.2.0, File-System: ext4, Screen Resolution: 3840x2160


ClickHouse 22.12.3.5
100M Rows Hits Dataset, Second Run
Queries Per Minute, Geo Mean > Higher Is Better
a . 303.03 |==================================================================
b . 298.58 |=================================================================
c . 305.12 |===================================================================
d . 305.00 |===================================================================
e . 305.93 |===================================================================


ClickHouse 22.12.3.5
100M Rows Hits Dataset, First Run / Cold Cache
Queries Per Minute, Geo Mean > Higher Is Better
a . 280.53 |==================================================================
b . 282.74 |===================================================================
c . 282.41 |===================================================================
d . 279.35 |==================================================================
e . 283.14 |===================================================================


ClickHouse 22.12.3.5
100M Rows Hits Dataset, Third Run
Queries Per Minute, Geo Mean > Higher Is Better
a . 306.32 |==================================================================
b . 307.38 |==================================================================
c . 309.89 |===================================================================
d . 308.85 |===================================================================
e . 306.50 |==================================================================