clickhouse-rembrandt

AMD Ryzen 7 PRO 6850U testing with a LENOVO 21CM0001US (R22ET51W 1.21 BIOS) and AMD Radeon 680M 1GB on Ubuntu 22.10 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2301118-NE-CLICKHOUS98&grr&sro.

clickhouse-rembrandt ProcessorMotherboardChipsetMemoryDiskGraphicsAudioNetworkOSKernelDesktopDisplay ServerOpenGLVulkanCompilerFile-SystemScreen ResolutionAMD Ryzen 7 PRO 6850U - AMD Radeon 680M 1GB - LENOVObcdAMD Ryzen 7 PRO 6850U @ 4.77GHz (8 Cores / 16 Threads)LENOVO 21CM0001US (R22ET51W 1.21 BIOS)AMD Device 14b516GB512GB Micron MTFDKBA512TFKAMD Radeon 680M 1GB (2200/400MHz)AMD Rembrandt Radeon HD AudioQualcomm QCNFA765Ubuntu 22.106.1.0-060100rc2daily20221028-generic (x86_64)GNOME Shell 43.0X Server + Wayland4.6 Mesa 22.2.1 (LLVM 15.0.2 DRM 3.49)1.3.224GCC 12.2.0ext41920x1200OpenBenchmarking.orgKernel Details- Transparent Huge Pages: madviseProcessor Details- Scaling Governor: amd-pstate schedutil (Boost: Enabled) - Platform Profile: performance - CPU Microcode: 0xa404102 - ACPI Profile: performanceSecurity 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 Retpolines IBPB: conditional IBRS_FW STIBP: always-on RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected

clickhouse-rembrandt clickhouse: 100M Rows Hits Dataset, Third Runclickhouse: 100M Rows Hits Dataset, Second Runclickhouse: 100M Rows Hits Dataset, First Run / Cold CacheAMD Ryzen 7 PRO 6850U - AMD Radeon 680M 1GB - LENOVObcd119.57118.06102.40123.15118.53102.30119.51111.7993.92114.03113.1395.14OpenBenchmarking.org

ClickHouse

100M Rows Hits Dataset, Third Run

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse 22.12.3.5100M Rows Hits Dataset, Third RunAMD Ryzen 7 PRO 6850U - AMD Radeon 680M 1GB - LENOVObcd306090120150119.57123.15119.51114.03MIN: 5.42 / MAX: 6000MIN: 5.41 / MAX: 6000MIN: 5.42 / MAX: 5454.55MIN: 5.42 / MAX: 3157.89

ClickHouse

100M Rows Hits Dataset, Second Run

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse 22.12.3.5100M Rows Hits Dataset, Second RunAMD Ryzen 7 PRO 6850U - AMD Radeon 680M 1GB - LENOVObcd306090120150118.06118.53111.79113.13MIN: 5.39 / MAX: 5000MIN: 5.34 / MAX: 5000MIN: 5.4 / MAX: 4000MIN: 5.38 / MAX: 4285.71

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 CacheAMD Ryzen 7 PRO 6850U - AMD Radeon 680M 1GB - LENOVObcd20406080100102.40102.3093.9295.14MIN: 5.24 / MAX: 4615.38MIN: 5.22 / MAX: 3529.41MIN: 5.43 / MAX: 1875MIN: 5.26 / MAX: 2727.27

Phoronix Test Suite v10.8.5