clickhouse sappgire rapids no accel

2 x Intel Xeon Platinum 8490H testing with a Quanta Cloud S6Q-MB-MPS (3A10.uh BIOS) and ASPEED on Ubuntu 22.04 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2301129-NE-CLICKHOUS57.

clickhouse sappgire rapids no accelProcessorMotherboardChipsetMemoryDiskGraphicsMonitorNetworkOSKernelDesktopDisplay ServerCompilerFile-SystemScreen Resolution2 x Intel Xeon Platinum 8490H - ASPEED - Quanta Cloudbcd2 x Intel Xeon Platinum 8490H @ 3.50GHz (120 Cores / 240 Threads)Quanta Cloud S6Q-MB-MPS (3A10.uh BIOS)Intel Device 1bce1008GB2 x 1920GB SAMSUNG MZWLJ1T9HBJR-00007 + 960GB INTEL SSDSC2KG96ASPEEDVGA HDMI4 x Intel E810-C for QSFP + 2 x Intel X710 for 10GBASE-TUbuntu 22.046.1.4-060104-generic (x86_64)GNOME Shell 42.2X Server 1.21.1.3GCC 11.3.0ext41920x1080OpenBenchmarking.orgKernel Details- Transparent Huge Pages: madviseProcessor Details- Scaling Governor: intel_pstate powersave (EPP: balance_performance) - CPU Microcode: 0x2b0000c0Security Details- itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + 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 IBRS IBPB: conditional RSB filling PBRSB-eIBRS: SW sequence + srbds: Not affected + tsx_async_abort: Not affected

clickhouse sappgire rapids no accelclickhouse: 100M Rows Hits Dataset, First Run / Cold Cacheclickhouse: 100M Rows Hits Dataset, Second Runclickhouse: 100M Rows Hits Dataset, Third Run2 x Intel Xeon Platinum 8490H - ASPEED - Quanta Cloudbcd196.85225.80238.84201.82228.86240.20196.98222.23232.69199.34226.97234.86OpenBenchmarking.org

ClickHouse

100M Rows Hits Dataset, First Run / Cold Cache

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse 22.12.3.5100M Rows Hits Dataset, First Run / Cold Cache2 x Intel Xeon Platinum 8490H - ASPEED - Quanta Cloudbcd4080120160200SE +/- 2.28, N = 3SE +/- 2.02, N = 5SE +/- 1.77, N = 3SE +/- 1.92, N = 6196.85201.82196.98199.34MIN: 10.73 / MAX: 1463.41MIN: 11.39 / MAX: 1818.18MIN: 10.44 / MAX: 1714.29MIN: 10.52 / MAX: 1935.48

ClickHouse

100M Rows Hits Dataset, Second Run

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse 22.12.3.5100M Rows Hits Dataset, Second Run2 x Intel Xeon Platinum 8490H - ASPEED - Quanta Cloudbcd50100150200250SE +/- 0.61, N = 3SE +/- 1.56, N = 5SE +/- 3.11, N = 3SE +/- 2.06, N = 6225.80228.86222.23226.97MIN: 35.29 / MAX: 1463.41MIN: 35.78 / MAX: 2222.22MIN: 34.29 / MAX: 1818.18MIN: 26.97 / MAX: 1764.71

ClickHouse

100M Rows Hits Dataset, Third Run

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse 22.12.3.5100M Rows Hits Dataset, Third Run2 x Intel Xeon Platinum 8490H - ASPEED - Quanta Cloudbcd50100150200250SE +/- 1.84, N = 3SE +/- 2.02, N = 5SE +/- 1.73, N = 3SE +/- 2.74, N = 6238.84240.20232.69234.86MIN: 41.75 / MAX: 1578.95MIN: 36.45 / MAX: 1935.48MIN: 38.54 / MAX: 1463.41MIN: 40.03 / MAX: 1875

Phoronix Test Suite v10.8.4