2022-09-29-1045

2 x AMD EPYC 7352 24-Core testing with a Dell 0YHMCJ (2.8.4 BIOS) and Matrox G200eW3 64GB on Ubuntu 20.04 via the Phoronix Test Suite.

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 2210015-FBEE-202209248
Jump To Table - Results

Statistics

Remove Outliers Before Calculating Averages

Graph Settings

Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
PERC H755 Front
September 29 2022
  1 Day, 14 Hours, 22 Minutes
Only show results matching title/arguments (delimit multiple options with a comma):
Do not show results matching title/arguments (delimit multiple options with a comma):

PERC H755 Front

Processor: 2 x AMD EPYC 7352 24-Core @ 2.30GHz (48 Cores / 96 Threads), Motherboard: Dell 0YHMCJ (2.8.4 BIOS), Chipset: AMD Starship/Matisse, Memory: 256GB, Disk: 960GB PERC H755 Front, Graphics: Matrox G200eW3 64GB, Network: 2 x Mellanox MT27800 + 2 x Broadcom NetXtreme BCM5720 2-port PCIe

OS: Ubuntu 20.04, Kernel: 5.15.0-46-generic (x86_64), Compiler: GCC 9.4.0, File-System: nfs, Screen Resolution: 1024x768

Kernel Notes: Transparent Huge Pages: madvise
Compiler Notes: --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++,gm2 --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-9-Av3uEd/gcc-9-9.4.0/debian/tmp-nvptx/usr,hsa --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib=auto --with-tune=generic --without-cuda-driver -v
Processor Notes: Scaling Governor: acpi-cpufreq ondemand (Boost: Enabled) - CPU Microcode: 0x8301052
Disk Scheduler Notes: MQ-DEADLINE
Security Notes: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Mitigation of untrained return thunk; SMT enabled with STIBP protection + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + 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

2022-09-29-1045OpenBenchmarking.orgPhoronix Test Suite2 x AMD EPYC 7352 24-Core @ 2.30GHz (48 Cores / 96 Threads)Dell 0YHMCJ (2.8.4 BIOS)AMD Starship/Matisse256GB960GB PERC H755 FrontMatrox G200eW3 64GB2 x Mellanox MT27800 + 2 x Broadcom NetXtreme BCM5720 2-port PCIeUbuntu 20.045.15.0-46-generic (x86_64)GCC 9.4.0nfs1024x768ProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelCompilerFile-SystemScreen Resolution2022-09-29-1045 BenchmarksSystem Logs- Transparent Huge Pages: madvise- --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++,gm2 --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-9-Av3uEd/gcc-9-9.4.0/debian/tmp-nvptx/usr,hsa --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib=auto --with-tune=generic --without-cuda-driver -v - Scaling Governor: acpi-cpufreq ondemand (Boost: Enabled) - CPU Microcode: 0x8301052- MQ-DEADLINE- itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Mitigation of untrained return thunk; SMT enabled with STIBP protection + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + 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

2022-09-29-1045pgbench: 1000 - 250 - Read Only - Average Latencypgbench: 1000 - 250 - Read Onlypgbench: 100 - 500 - Read Write - Average Latencypgbench: 100 - 500 - Read Writepgbench: 100 - 100 - Read Write - Average Latencypgbench: 100 - 100 - Read Writepgbench: 25000 - 1 - Read Only - Average Latencypgbench: 25000 - 1 - Read Onlypgbench: 1000 - 1 - Read Write - Average Latencypgbench: 1000 - 1 - Read Writepgbench: 100 - 500 - Read Only - Average Latencypgbench: 100 - 500 - Read Onlypgbench: 100 - 50 - Read Write - Average Latencypgbench: 100 - 50 - Read Writepgbench: 100 - 250 - Read Only - Average Latencypgbench: 100 - 250 - Read Onlypgbench: 100 - 100 - Read Only - Average Latencypgbench: 100 - 100 - Read Onlypgbench: 100 - 50 - Read Only - Average Latencypgbench: 100 - 50 - Read Onlypgbench: 100 - 1 - Read Write - Average Latencypgbench: 100 - 1 - Read Writepgbench: 1 - 100 - Read Write - Average Latencypgbench: 1 - 100 - Read Writepgbench: 1 - 500 - Read Only - Average Latencypgbench: 1 - 500 - Read Onlypgbench: 1 - 50 - Read Write - Average Latencypgbench: 1 - 50 - Read Writepgbench: 1 - 250 - Read Only - Average Latencypgbench: 1 - 250 - Read Onlypgbench: 1 - 100 - Read Only - Average Latencypgbench: 1 - 100 - Read Onlypgbench: 1 - 50 - Read Only - Average Latencypgbench: 1 - 50 - Read Onlypgbench: 1 - 1 - Read Write - Average Latencypgbench: 1 - 1 - Read Writeredis: LPUSH - 1000redis: SADD - 1000redis: LPUSH - 500redis: LPOP - 1000redis: SET - 1000redis: SADD - 500redis: LPUSH - 50redis: LPOP - 500redis: GET - 1000redis: SET - 500redis: SADD - 50redis: LPOP - 50redis: GET - 500redis: SET - 50redis: GET - 50clickhouse: 100M Rows Web Analytics Dataset, Third Runclickhouse: 100M Rows Web Analytics Dataset, Second Runsqlite: 1leveldb: Seq Fillleveldb: Seq Fillleveldb: Rand Deleteleveldb: Seek Randleveldb: Rand Readleveldb: Rand Fillleveldb: Rand Fillleveldb: Overwriteleveldb: Overwriteleveldb: Fill Syncleveldb: Fill Syncleveldb: Hot Readpgbench: 1000 - 500 - Read Only - Average Latencypgbench: 1000 - 500 - Read Onlypgbench: 1000 - 50 - Read Write - Average Latencypgbench: 1000 - 50 - Read Writepgbench: 1000 - 100 - Read Only - Average Latencypgbench: 1000 - 100 - Read Onlypgbench: 100 - 250 - Read Write - Average Latencypgbench: 100 - 250 - Read Writepgbench: 10000 - 1 - Read Only - Average Latencypgbench: 10000 - 1 - Read Onlypgbench: 1000 - 50 - Read Only - Average Latencypgbench: 1000 - 50 - Read Onlypgbench: 1000 - 1 - Read Only - Average Latencypgbench: 1000 - 1 - Read Onlypgbench: 1 - 500 - Read Write - Average Latencypgbench: 1 - 500 - Read Writepgbench: 1 - 250 - Read Write - Average Latencypgbench: 1 - 250 - Read Writepgbench: 100 - 1 - Read Only - Average Latencypgbench: 100 - 1 - Read Onlypgbench: 1 - 1 - Read Only - Average Latencypgbench: 1 - 1 - Read Onlyclickhouse: 100M Rows Web Analytics Dataset, First Run / Cold CachePERC H755 Front0.515486018145.427343927.331366013.751732.1804590.57187578616.59330140.2898638840.1039711270.1044793702.025494171.4915830.51497337978.8056350.2699286220.09810204920.1014967811.8615371097989.891397771.711104434.711051587.671204723.871337529.461054316.411740605.661557449.701215872.961387543.791836263.001562377.621223938.341800814.28254.69256.5591.771830.56512.8816.124192.086117.104862.23112.3857.00612.41291.1728.1109.9061.11046007119.90425740.22844736167.94937142.7595370.1732950660.18361141797.364281570.0434400.065154650.06315887242.91OpenBenchmarking.org

PostgreSQL pgbench

This is a benchmark of PostgreSQL using pgbench for facilitating the database benchmarks. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average LatencyPERC H755 Front0.11590.23180.34770.46360.5795SE +/- 0.002, N = 30.5151. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 250 - Mode: Read OnlyPERC H755 Front100K200K300K400K500KSE +/- 2200.78, N = 34860181. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average LatencyPERC H755 Front306090120150SE +/- 1.34, N = 3145.431. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 500 - Mode: Read WritePERC H755 Front7001400210028003500SE +/- 31.51, N = 334391. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average LatencyPERC H755 Front612182430SE +/- 0.30, N = 427.331. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 100 - Mode: Read WritePERC H755 Front8001600240032004000SE +/- 39.28, N = 436601. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 25000 - Clients: 1 - Mode: Read Only - Average LatencyPERC H755 Front48121620SE +/- 0.40, N = 313.751. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 25000 - Clients: 1 - Mode: Read OnlyPERC H755 Front1632486480SE +/- 2.08, N = 3731. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average LatencyPERC H755 Front0.49050.9811.47151.9622.4525SE +/- 0.029, N = 32.1801. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 1 - Mode: Read WritePERC H755 Front100200300400500SE +/- 6.10, N = 34591. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average LatencyPERC H755 Front0.12850.2570.38550.5140.6425SE +/- 0.002, N = 30.5711. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 500 - Mode: Read OnlyPERC H755 Front200K400K600K800K1000KSE +/- 2470.05, N = 38757861. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average LatencyPERC H755 Front48121620SE +/- 0.18, N = 316.591. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 50 - Mode: Read WritePERC H755 Front6001200180024003000SE +/- 31.75, N = 330141. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average LatencyPERC H755 Front0.0650.130.1950.260.325SE +/- 0.002, N = 30.2891. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 250 - Mode: Read OnlyPERC H755 Front200K400K600K800K1000KSE +/- 5492.22, N = 38638841. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average LatencyPERC H755 Front0.02320.04640.06960.09280.116SE +/- 0.000, N = 30.1031. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 100 - Mode: Read OnlyPERC H755 Front200K400K600K800K1000KSE +/- 1426.44, N = 39711271. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average LatencyPERC H755 Front0.02340.04680.07020.09360.117SE +/- 0.000, N = 30.1041. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 50 - Mode: Read OnlyPERC H755 Front100K200K300K400K500KSE +/- 578.48, N = 34793701. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average LatencyPERC H755 Front0.45560.91121.36681.82242.278SE +/- 0.018, N = 32.0251. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 1 - Mode: Read WritePERC H755 Front110220330440550SE +/- 4.29, N = 34941. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average LatencyPERC H755 Front4080120160200SE +/- 1.59, N = 3171.491. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 100 - Mode: Read WritePERC H755 Front130260390520650SE +/- 5.41, N = 35831. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average LatencyPERC H755 Front0.11570.23140.34710.46280.5785SE +/- 0.006, N = 30.5141. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 500 - Mode: Read OnlyPERC H755 Front200K400K600K800K1000KSE +/- 11261.41, N = 39733791. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average LatencyPERC H755 Front20406080100SE +/- 0.87, N = 378.811. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 50 - Mode: Read WritePERC H755 Front140280420560700SE +/- 7.07, N = 36351. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average LatencyPERC H755 Front0.06050.1210.18150.2420.3025SE +/- 0.003, N = 30.2691. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 250 - Mode: Read OnlyPERC H755 Front200K400K600K800K1000KSE +/- 10803.25, N = 39286221. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average LatencyPERC H755 Front0.02210.04420.06630.08840.1105SE +/- 0.001, N = 30.0981. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 100 - Mode: Read OnlyPERC H755 Front200K400K600K800K1000KSE +/- 4693.46, N = 310204921. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average LatencyPERC H755 Front0.02270.04540.06810.09080.1135SE +/- 0.000, N = 30.1011. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 50 - Mode: Read OnlyPERC H755 Front110K220K330K440K550KSE +/- 1167.36, N = 34967811. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average LatencyPERC H755 Front0.41870.83741.25611.67482.0935SE +/- 0.007, N = 31.8611. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read WritePERC H755 Front120240360480600SE +/- 1.98, N = 35371. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

Redis

Redis is an open-source in-memory data structure store, used as a database, cache, and message broker. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: LPUSH - Parallel Connections: 1000PERC H755 Front200K400K600K800K1000KSE +/- 9273.88, N = 81097989.891. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: SADD - Parallel Connections: 1000PERC H755 Front300K600K900K1200K1500KSE +/- 8207.38, N = 31397771.711. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: LPUSH - Parallel Connections: 500PERC H755 Front200K400K600K800K1000KSE +/- 1464.22, N = 31104434.711. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: LPOP - Parallel Connections: 1000PERC H755 Front200K400K600K800K1000KSE +/- 8984.33, N = 31051587.671. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: SET - Parallel Connections: 1000PERC H755 Front300K600K900K1200K1500KSE +/- 9110.11, N = 31204723.871. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: SADD - Parallel Connections: 500PERC H755 Front300K600K900K1200K1500KSE +/- 12363.75, N = 31337529.461. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: LPUSH - Parallel Connections: 50PERC H755 Front200K400K600K800K1000KSE +/- 9816.84, N = 31054316.411. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: LPOP - Parallel Connections: 500PERC H755 Front400K800K1200K1600K2000KSE +/- 18220.59, N = 151740605.661. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: GET - Parallel Connections: 1000PERC H755 Front300K600K900K1200K1500KSE +/- 15722.43, N = 141557449.701. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: SET - Parallel Connections: 500PERC H755 Front300K600K900K1200K1500KSE +/- 6426.81, N = 31215872.961. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: SADD - Parallel Connections: 50PERC H755 Front300K600K900K1200K1500KSE +/- 16637.15, N = 31387543.791. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: LPOP - Parallel Connections: 50PERC H755 Front400K800K1200K1600K2000KSE +/- 8964.19, N = 31836263.001. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: GET - Parallel Connections: 500PERC H755 Front300K600K900K1200K1500KSE +/- 9805.40, N = 31562377.621. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: SET - Parallel Connections: 50PERC H755 Front300K600K900K1200K1500KSE +/- 14412.37, N = 31223938.341. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: GET - Parallel Connections: 50PERC H755 Front400K800K1200K1600K2000KSE +/- 22289.76, N = 41800814.281. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

ClickHouse

ClickHouse is an open-source, high performance OLAP data management system. This test profile uses ClickHouse's standard benchmark recommendations per https://clickhouse.com/docs/en/operations/performance-test/ with the 100 million rows web analytics dataset. The reported value is the query processing time using the geometric mean of all queries performed. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse 22.5.4.19100M Rows Web Analytics Dataset, Third RunPERC H755 Front60120180240300SE +/- 3.39, N = 12254.69MIN: 34.44 / MAX: 60001. ClickHouse server version 22.5.4.19 (official build).

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse 22.5.4.19100M Rows Web Analytics Dataset, Second RunPERC H755 Front60120180240300SE +/- 1.36, N = 12256.55MIN: 29.78 / MAX: 5454.551. ClickHouse server version 22.5.4.19 (official build).

SQLite

This is a simple benchmark of SQLite. At present this test profile just measures the time to perform a pre-defined number of insertions on an indexed database. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 1PERC H755 Front20406080100SE +/- 1.08, N = 1591.771. (CC) gcc options: -O2 -lreadline -ltermcap -lz -lm -ldl -lpthread

LevelDB

LevelDB is a key-value storage library developed by Google that supports making use of Snappy for data compression and has other modern features. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Sequential FillPERC H755 Front2004006008001000SE +/- 6.39, N = 3830.571. (CXX) g++ options: -O3 -lpthread

OpenBenchmarking.orgMB/s, More Is BetterLevelDB 1.22Benchmark: Sequential FillPERC H755 Front3691215SE +/- 0.09, N = 312.81. (CXX) g++ options: -O3 -lpthread

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Random DeletePERC H755 Front2004006008001000SE +/- 2.74, N = 3816.121. (CXX) g++ options: -O3 -lpthread

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Seek RandomPERC H755 Front4080120160200SE +/- 1.88, N = 3192.091. (CXX) g++ options: -O3 -lpthread

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Random ReadPERC H755 Front306090120150SE +/- 1.18, N = 3117.101. (CXX) g++ options: -O3 -lpthread

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Random FillPERC H755 Front2004006008001000SE +/- 5.41, N = 3862.231. (CXX) g++ options: -O3 -lpthread

OpenBenchmarking.orgMB/s, More Is BetterLevelDB 1.22Benchmark: Random FillPERC H755 Front3691215SE +/- 0.09, N = 312.31. (CXX) g++ options: -O3 -lpthread

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: OverwritePERC H755 Front2004006008001000SE +/- 2.07, N = 3857.011. (CXX) g++ options: -O3 -lpthread

OpenBenchmarking.orgMB/s, More Is BetterLevelDB 1.22Benchmark: OverwritePERC H755 Front3691215SE +/- 0.03, N = 312.41. (CXX) g++ options: -O3 -lpthread

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Fill SyncPERC H755 Front30060090012001500SE +/- 13.48, N = 151291.171. (CXX) g++ options: -O3 -lpthread

OpenBenchmarking.orgMB/s, More Is BetterLevelDB 1.22Benchmark: Fill SyncPERC H755 Front246810SE +/- 0.09, N = 158.11. (CXX) g++ options: -O3 -lpthread

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Hot ReadPERC H755 Front20406080100SE +/- 0.50, N = 3109.911. (CXX) g++ options: -O3 -lpthread

PostgreSQL pgbench

This is a benchmark of PostgreSQL using pgbench for facilitating the database benchmarks. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average LatencyPERC H755 Front0.24980.49960.74940.99921.249SE +/- 0.063, N = 91.1101. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 500 - Mode: Read OnlyPERC H755 Front100K200K300K400K500KSE +/- 21379.29, N = 94600711. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average LatencyPERC H755 Front510152025SE +/- 1.39, N = 619.901. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 50 - Mode: Read WritePERC H755 Front6001200180024003000SE +/- 180.28, N = 625741. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average LatencyPERC H755 Front0.05130.10260.15390.20520.2565SE +/- 0.012, N = 60.2281. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 100 - Mode: Read OnlyPERC H755 Front100K200K300K400K500KSE +/- 27945.24, N = 64473611. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average LatencyPERC H755 Front1530456075SE +/- 2.27, N = 967.951. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 250 - Mode: Read WritePERC H755 Front8001600240032004000SE +/- 130.43, N = 937141. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 10000 - Clients: 1 - Mode: Read Only - Average LatencyPERC H755 Front0.62081.24161.86242.48323.104SE +/- 0.529, N = 92.7591. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 10000 - Clients: 1 - Mode: Read OnlyPERC H755 Front120240360480600SE +/- 126.01, N = 95371. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average LatencyPERC H755 Front0.03890.07780.11670.15560.1945SE +/- 0.008, N = 90.1731. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 50 - Mode: Read OnlyPERC H755 Front60K120K180K240K300KSE +/- 14693.01, N = 92950661. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average LatencyPERC H755 Front0.04120.08240.12360.16480.206SE +/- 0.023, N = 90.1831. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 1 - Mode: Read OnlyPERC H755 Front13002600390052006500SE +/- 672.89, N = 961141. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average LatencyPERC H755 Front400800120016002000SE +/- 69.79, N = 91797.361. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 500 - Mode: Read WritePERC H755 Front60120180240300SE +/- 9.76, N = 92811. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average LatencyPERC H755 Front120240360480600SE +/- 10.60, N = 12570.041. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 250 - Mode: Read WritePERC H755 Front100200300400500SE +/- 8.58, N = 124401. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average LatencyPERC H755 Front0.01460.02920.04380.05840.073SE +/- 0.001, N = 120.0651. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 1 - Mode: Read OnlyPERC H755 Front3K6K9K12K15KSE +/- 288.00, N = 12154651. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average LatencyPERC H755 Front0.01420.02840.04260.05680.071SE +/- 0.002, N = 120.0631. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read OnlyPERC H755 Front3K6K9K12K15KSE +/- 427.70, N = 12158871. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

etcd

Etcd is a distributed, reliable key-value store intended for critical data of a distributed system. Etcd is written in Golang and part of the Cloud Native Computing Foundation (CNCF) and used by Kubernetes, Rook, CoreDNS, and other open-source software. This test profile uses Etcd's built-in benchmark to stress the PUT and RANGE performance of a single node / local system. Learn more via the OpenBenchmarking.org test page.

Test: RANGE - Connections: 500 - Clients: 1000

PERC H755 Front: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: /home/vault/b139dc/b139dc10/installed-tests/pts/etcd-1.0.0/etcd: line 9: ./benchmark: No such file or directory

Test: RANGE - Connections: 100 - Clients: 1000

PERC H755 Front: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: /home/vault/b139dc/b139dc10/installed-tests/pts/etcd-1.0.0/etcd: line 9: ./benchmark: No such file or directory

Test: RANGE - Connections: 500 - Clients: 100

PERC H755 Front: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: /home/vault/b139dc/b139dc10/installed-tests/pts/etcd-1.0.0/etcd: line 9: ./benchmark: No such file or directory

Test: RANGE - Connections: 50 - Clients: 1000

PERC H755 Front: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: /home/vault/b139dc/b139dc10/installed-tests/pts/etcd-1.0.0/etcd: line 9: ./benchmark: No such file or directory

Test: RANGE - Connections: 100 - Clients: 100

PERC H755 Front: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: /home/vault/b139dc/b139dc10/installed-tests/pts/etcd-1.0.0/etcd: line 9: ./benchmark: No such file or directory

Test: RANGE - Connections: 50 - Clients: 100

PERC H755 Front: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: /home/vault/b139dc/b139dc10/installed-tests/pts/etcd-1.0.0/etcd: line 9: ./benchmark: No such file or directory

Test: PUT - Connections: 500 - Clients: 1000

PERC H755 Front: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: /home/vault/b139dc/b139dc10/installed-tests/pts/etcd-1.0.0/etcd: line 9: ./benchmark: No such file or directory

Test: PUT - Connections: 100 - Clients: 1000

PERC H755 Front: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: /home/vault/b139dc/b139dc10/installed-tests/pts/etcd-1.0.0/etcd: line 9: ./benchmark: No such file or directory

Test: PUT - Connections: 500 - Clients: 100

PERC H755 Front: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: /home/vault/b139dc/b139dc10/installed-tests/pts/etcd-1.0.0/etcd: line 9: ./benchmark: No such file or directory

Test: PUT - Connections: 50 - Clients: 1000

PERC H755 Front: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: /home/vault/b139dc/b139dc10/installed-tests/pts/etcd-1.0.0/etcd: line 9: ./benchmark: No such file or directory

Test: PUT - Connections: 100 - Clients: 100

PERC H755 Front: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: /home/vault/b139dc/b139dc10/installed-tests/pts/etcd-1.0.0/etcd: line 9: ./benchmark: No such file or directory

Test: PUT - Connections: 50 - Clients: 100

PERC H755 Front: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: /home/vault/b139dc/b139dc10/installed-tests/pts/etcd-1.0.0/etcd: line 9: ./benchmark: No such file or directory

ClickHouse

ClickHouse is an open-source, high performance OLAP data management system. This test profile uses ClickHouse's standard benchmark recommendations per https://clickhouse.com/docs/en/operations/performance-test/ with the 100 million rows web analytics dataset. The reported value is the query processing time using the geometric mean of all queries performed. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse 22.5.4.19100M Rows Web Analytics Dataset, First Run / Cold CachePERC H755 Front50100150200250SE +/- 5.76, N = 12242.91MIN: 8.77 / MAX: 50001. ClickHouse server version 22.5.4.19 (official build).

89 Results Shown

PostgreSQL pgbench:
  1000 - 250 - Read Only - Average Latency
  1000 - 250 - Read Only
  100 - 500 - Read Write - Average Latency
  100 - 500 - Read Write
  100 - 100 - Read Write - Average Latency
  100 - 100 - Read Write
  25000 - 1 - Read Only - Average Latency
  25000 - 1 - Read Only
  1000 - 1 - Read Write - Average Latency
  1000 - 1 - Read Write
  100 - 500 - Read Only - Average Latency
  100 - 500 - Read Only
  100 - 50 - Read Write - Average Latency
  100 - 50 - Read Write
  100 - 250 - Read Only - Average Latency
  100 - 250 - Read Only
  100 - 100 - Read Only - Average Latency
  100 - 100 - Read Only
  100 - 50 - Read Only - Average Latency
  100 - 50 - Read Only
  100 - 1 - Read Write - Average Latency
  100 - 1 - Read Write
  1 - 100 - Read Write - Average Latency
  1 - 100 - Read Write
  1 - 500 - Read Only - Average Latency
  1 - 500 - Read Only
  1 - 50 - Read Write - Average Latency
  1 - 50 - Read Write
  1 - 250 - Read Only - Average Latency
  1 - 250 - Read Only
  1 - 100 - Read Only - Average Latency
  1 - 100 - Read Only
  1 - 50 - Read Only - Average Latency
  1 - 50 - Read Only
  1 - 1 - Read Write - Average Latency
  1 - 1 - Read Write
Redis:
  LPUSH - 1000
  SADD - 1000
  LPUSH - 500
  LPOP - 1000
  SET - 1000
  SADD - 500
  LPUSH - 50
  LPOP - 500
  GET - 1000
  SET - 500
  SADD - 50
  LPOP - 50
  GET - 500
  SET - 50
  GET - 50
ClickHouse:
  100M Rows Web Analytics Dataset, Third Run
  100M Rows Web Analytics Dataset, Second Run
SQLite
LevelDB:
  Seq Fill:
    Microseconds Per Op
    MB/s
  Rand Delete:
    Microseconds Per Op
  Seek Rand:
    Microseconds Per Op
  Rand Read:
    Microseconds Per Op
  Rand Fill:
    Microseconds Per Op
    MB/s
  Overwrite:
    Microseconds Per Op
    MB/s
  Fill Sync:
    Microseconds Per Op
    MB/s
  Hot Read:
    Microseconds Per Op
PostgreSQL pgbench:
  1000 - 500 - Read Only - Average Latency
  1000 - 500 - Read Only
  1000 - 50 - Read Write - Average Latency
  1000 - 50 - Read Write
  1000 - 100 - Read Only - Average Latency
  1000 - 100 - Read Only
  100 - 250 - Read Write - Average Latency
  100 - 250 - Read Write
  10000 - 1 - Read Only - Average Latency
  10000 - 1 - Read Only
  1000 - 50 - Read Only - Average Latency
  1000 - 50 - Read Only
  1000 - 1 - Read Only - Average Latency
  1000 - 1 - Read Only
  1 - 500 - Read Write - Average Latency
  1 - 500 - Read Write
  1 - 250 - Read Write - Average Latency
  1 - 250 - Read Write
  100 - 1 - Read Only - Average Latency
  100 - 1 - Read Only
  1 - 1 - Read Only - Average Latency
  1 - 1 - Read Only
ClickHouse

PERC H755 Front

Processor: 2 x AMD EPYC 7352 24-Core @ 2.30GHz (48 Cores / 96 Threads), Motherboard: Dell 0YHMCJ (2.8.4 BIOS), Chipset: AMD Starship/Matisse, Memory: 256GB, Disk: 960GB PERC H755 Front, Graphics: Matrox G200eW3 64GB, Network: 2 x Mellanox MT27800 + 2 x Broadcom NetXtreme BCM5720 2-port PCIe

OS: Ubuntu 20.04, Kernel: 5.15.0-46-generic (x86_64), Compiler: GCC 9.4.0, File-System: nfs, Screen Resolution: 1024x768

Kernel Notes: Transparent Huge Pages: madvise
Compiler Notes: --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++,gm2 --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-9-Av3uEd/gcc-9-9.4.0/debian/tmp-nvptx/usr,hsa --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib=auto --with-tune=generic --without-cuda-driver -v
Processor Notes: Scaling Governor: acpi-cpufreq ondemand (Boost: Enabled) - CPU Microcode: 0x8301052
Disk Scheduler Notes: MQ-DEADLINE
Security Notes: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Mitigation of untrained return thunk; SMT enabled with STIBP protection + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + 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

Testing initiated at 29 September 2022 10:45 by user fbees.