clickhouse hp dev one

AMD Ryzen 7 PRO 5850U testing with a HP 8A78 (F.04 BIOS) and AMD Cezanne 512MB on Pop 22.04 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2206251-NE-CLICKHOUS91&grr.

clickhouse hp dev oneProcessorMotherboardChipsetMemoryDiskGraphicsAudioNetworkOSKernelDesktopDisplay ServerOpenGLVulkanCompilerFile-SystemScreen ResolutionABCDEAMD Ryzen 7 PRO 5850U @ 4.51GHz (8 Cores / 16 Threads)HP 8A78 (F.04 BIOS)AMD Renoir/Cezanne16GB1024GB SK hynix PC711 HFS001TDE9X073NAMD Cezanne 512MB (2000/400MHz)AMD Renoir Radeon HD AudioRealtek RTL8822CE 802.11ac PCIePop 22.045.18.4-xanmod1 (x86_64)GNOME Shell 42.1X Server 1.21.1.34.6 Mesa 22.0.1 (LLVM 13.0.1 DRM 3.46)1.2.204GCC 11.2.0ext41920x1080OpenBenchmarking.orgKernel Details- Transparent Huge Pages: madviseProcessor Details- Scaling Governor: amd-pstate schedutil (Boost: Enabled) - CPU Microcode: 0xa50000c Security Details- itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: 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 Retpolines IBPB: conditional IBRS_FW STIBP: always-on RSB filling + srbds: Not affected + tsx_async_abort: Not affected

clickhouse hp dev oneclickhouse: 100M Rows Web Analytics Dataset, Third Runclickhouse: 100M Rows Web Analytics Dataset, Second Runclickhouse: 100M Rows Web Analytics Dataset, First Run / Cold CacheABCDE112.88110.23101.17115.38115.25101.44113.70113.44102.58116.09114.66102.39112.03114.51100.96OpenBenchmarking.org

ClickHouse

100M Rows Web Analytics Dataset, Third Run

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse100M Rows Web Analytics Dataset, Third RunABCDE306090120150SE +/- 0.82, N = 2SE +/- 1.47, N = 2SE +/- 0.62, N = 3SE +/- 0.25, N = 2SE +/- 1.59, N = 2112.88115.38113.70116.09112.03MIN: 7.67 / MAX: 15000MIN: 7.64 / MAX: 15000MIN: 7.68 / MAX: 15000MIN: 7.73 / MAX: 15000MIN: 7.58 / MAX: 150001. ClickHouse server version 22.7.1.687 (official build).

ClickHouse

100M Rows Web Analytics Dataset, Second Run

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse100M Rows Web Analytics Dataset, Second RunABCDE306090120150SE +/- 0.47, N = 2SE +/- 0.62, N = 2SE +/- 2.51, N = 3SE +/- 1.77, N = 2SE +/- 0.17, N = 2110.23115.25113.44114.66114.51MIN: 7.57 / MAX: 10000MIN: 7.73 / MAX: 15000MIN: 7.72 / MAX: 15000MIN: 7.71 / MAX: 15000MIN: 7.6 / MAX: 120001. ClickHouse server version 22.7.1.687 (official build).

ClickHouse

100M Rows Web Analytics Dataset, First Run / Cold Cache

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse100M Rows Web Analytics Dataset, First Run / Cold CacheABCDE20406080100SE +/- 1.37, N = 2SE +/- 0.13, N = 2SE +/- 0.77, N = 3SE +/- 0.43, N = 2SE +/- 1.25, N = 2101.17101.44102.58102.39100.96MIN: 7.62 / MAX: 15000MIN: 7.64 / MAX: 15000MIN: 7.63 / MAX: 15000MIN: 7.58 / MAX: 15000MIN: 7.57 / MAX: 150001. ClickHouse server version 22.7.1.687 (official build).

Phoronix Test Suite v10.8.5