VM DB tests

KVM testing on Ubuntu 22.04 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2311298-NE-VMDBTESTS77&grt&rdt.

VM DB testsProcessorMotherboardChipsetMemoryDiskGraphicsMonitorNetworkOSKernelVulkanCompilerFile-SystemScreen ResolutionSystem Layerjammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_med-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.24 x AMD EPYC (with IBPB) (4 Cores)QEMU Standard PC (i440FX + PIIX 1996) (1.15.0-1 BIOS)Intel 440FX 82441FX PMC1 x 8 GB RAM QEMU107GB QEMU HDDbochs-drmdrmfbQEMU MonitorRed Hat Virtio deviceUbuntu 22.045.15.0-88-generic (x86_64)1.3.238GCC 11.4.0ext41024x768KVM16 x AMD EPYC (with IBPB) (16 Cores)4 x 16 GB RAM QEMU8 x AMD EPYC (with IBPB) (8 Cores)1 x 16 GB RAM QEMU16 x AMD EPYC (with IBPB) (16 Cores)4 x 16 GB RAM QEMUOpenBenchmarking.orgKernel Details- Transparent Huge Pages: madviseCompiler Details- --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-bootstrap --enable-cet --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++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-link-serialization=2 --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-11-XeT9lY/gcc-11-11.4.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-11-XeT9lY/gcc-11-11.4.0/debian/tmp-gcn/usr --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-build-config=bootstrap-lto-lean --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 Details- CPU Microcode: 0x1000065Security Details- gather_data_sampling: Not affected + 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 disabled + spec_rstack_overflow: Mitigation of SMT disabled + spec_store_bypass: Vulnerable + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Retpolines IBPB: conditional STIBP: disabled RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected

VM DB testsinfluxdb: 4 - 10000 - 2,5000,1 - 10000influxdb: 64 - 10000 - 2,5000,1 - 10000influxdb: 1024 - 10000 - 2,5000,1 - 10000mysqlslap: 1mysqlslap: 64mysqlslap: 128mysqlslap: 256mysqlslap: 512pgbench: 100 - 1 - Read Onlypgbench: 100 - 1 - Read Only - Average Latencypgbench: 100 - 1 - Read Writepgbench: 100 - 1 - Read Write - Average Latencypgbench: 100 - 50 - Read Onlypgbench: 100 - 50 - Read Only - Average Latencypgbench: 100 - 100 - Read Onlypgbench: 100 - 100 - Read Only - Average Latencypgbench: 100 - 250 - Read Onlypgbench: 100 - 250 - Read Only - Average Latencypgbench: 100 - 50 - Read Writepgbench: 100 - 50 - Read Write - Average Latencypgbench: 100 - 500 - Read Onlypgbench: 100 - 500 - Read Only - Average Latencypgbench: 100 - 100 - Read Writepgbench: 100 - 100 - Read Write - Average Latencypgbench: 100 - 250 - Read Writepgbench: 100 - 250 - Read Write - Average Latencypgbench: 100 - 500 - Read Writepgbench: 100 - 500 - Read Write - Average Latencyrocksdb: Rand Fillrocksdb: Rand Readrocksdb: Update Randrocksdb: Seq Fillrocksdb: Rand Fill Syncrocksdb: Read While Writingrocksdb: Read Rand Write Randjammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_med-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.2528273.1690751.434650.41032292149127127313880.0334782.0941465430.3411344520.7441228392.037130638.8011167544.283131677.2961373183.9111337380.46319018122334662139914212628481355565422690766058.91422637.01610766.6972305205173170339780.0304582.1834987310.1005114170.1963597640.695117343.9564033491.240127079.9631327190.9101206418.554301962899016812734803235471581137370410762221033323206164152426060.0244792.090769556.01429053.11604726.11025316194171171361260.0284722.1205157840.0975054830.1983498080.715109746.3463776861.325117385.9121278197.7051253405.07830108490437013272273313768149613702221090527OpenBenchmarking.org

InfluxDB

Concurrent Streams: 4 - Batch Size: 10000 - Tags: 2,5000,1 - Points Per Series: 10000

OpenBenchmarking.orgval/sec, More Is BetterInfluxDB 1.8.2Concurrent Streams: 4 - Batch Size: 10000 - Tags: 2,5000,1 - Points Per Series: 10000jammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.2160K320K480K640K800KSE +/- 2236.56, N = 3SE +/- 7253.73, N = 3SE +/- 6485.90, N = 3528273.1766058.9769556.0

InfluxDB

Concurrent Streams: 64 - Batch Size: 10000 - Tags: 2,5000,1 - Points Per Series: 10000

OpenBenchmarking.orgval/sec, More Is BetterInfluxDB 1.8.2Concurrent Streams: 64 - Batch Size: 10000 - Tags: 2,5000,1 - Points Per Series: 10000jammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.2300K600K900K1200K1500KSE +/- 3008.21, N = 3SE +/- 9456.18, N = 13SE +/- 15741.74, N = 5690751.41422637.01429053.1

InfluxDB

Concurrent Streams: 1024 - Batch Size: 10000 - Tags: 2,5000,1 - Points Per Series: 10000

OpenBenchmarking.orgval/sec, More Is BetterInfluxDB 1.8.2Concurrent Streams: 1024 - Batch Size: 10000 - Tags: 2,5000,1 - Points Per Series: 10000jammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.2300K600K900K1200K1500KSE +/- 7773.54, N = 15SE +/- 9278.36, N = 3SE +/- 21316.26, N = 334650.41610766.61604726.1

MariaDB

Clients: 1

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.0.1Clients: 1jammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_med-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.22004006008001000SE +/- 10.53, N = 6SE +/- 12.73, N = 12SE +/- 11.97, N = 14SE +/- 7.44, N = 121032972103310251. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

MariaDB

Clients: 64

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.0.1Clients: 64jammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_med-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.270140210280350SE +/- 3.19, N = 9SE +/- 3.95, N = 3SE +/- 1.82, N = 3SE +/- 1.90, N = 32923053233161. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

MariaDB

Clients: 128

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.0.1Clients: 128jammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_med-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.250100150200250SE +/- 0.93, N = 3SE +/- 2.23, N = 4SE +/- 0.67, N = 3SE +/- 0.81, N = 31492052061941. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

MariaDB

Clients: 256

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.0.1Clients: 256jammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_med-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.24080120160200SE +/- 0.15, N = 3SE +/- 1.86, N = 3SE +/- 2.13, N = 9SE +/- 1.73, N = 51271731641711. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

MariaDB

Clients: 512

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.0.1Clients: 512jammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_med-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.24080120160200SE +/- 1.61, N = 3SE +/- 1.36, N = 3SE +/- 2.49, N = 9SE +/- 1.10, N = 31271701521711. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

PostgreSQL

Scaling Factor: 100 - Clients: 1 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 1 - Mode: Read Onlyjammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_med-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.29K18K27K36K45KSE +/- 2533.19, N = 9SE +/- 1332.41, N = 12SE +/- 1111.41, N = 12SE +/- 1597.17, N = 12313883397842606361261. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latencyjammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_med-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.20.00740.01480.02220.02960.037SE +/- 0.002, N = 9SE +/- 0.001, N = 12SE +/- 0.001, N = 12SE +/- 0.001, N = 120.0330.0300.0240.0281. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 1 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 1 - Mode: Read Writejammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_med-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.2100200300400500SE +/- 5.76, N = 12SE +/- 3.82, N = 12SE +/- 4.69, N = 3SE +/- 5.95, N = 124784584794721. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latencyjammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_med-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.20.49120.98241.47361.96482.456SE +/- 0.025, N = 12SE +/- 0.018, N = 12SE +/- 0.021, N = 3SE +/- 0.026, N = 122.0942.1832.0902.1201. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 50 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 50 - Mode: Read Onlyjammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.2110K220K330K440K550KSE +/- 1152.35, N = 3SE +/- 2922.45, N = 3SE +/- 6410.49, N = 41465434987315157841. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latencyjammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.20.07670.15340.23010.30680.3835SE +/- 0.003, N = 3SE +/- 0.000, N = 3SE +/- 0.001, N = 40.3410.1000.0971. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 100 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 100 - Mode: Read Onlyjammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.2110K220K330K440K550KSE +/- 1085.16, N = 12SE +/- 4390.54, N = 3SE +/- 3994.01, N = 121344525114175054831. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latencyjammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.20.16740.33480.50220.66960.837SE +/- 0.006, N = 12SE +/- 0.002, N = 3SE +/- 0.001, N = 120.7440.1960.1981. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 250 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 250 - Mode: Read Onlyjammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.280K160K240K320K400KSE +/- 983.66, N = 12SE +/- 3692.72, N = 3SE +/- 3714.50, N = 51228393597643498081. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latencyjammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.20.45830.91661.37491.83322.2915SE +/- 0.016, N = 12SE +/- 0.007, N = 3SE +/- 0.007, N = 52.0370.6950.7151. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 50 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 50 - Mode: Read Writejammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.230060090012001500SE +/- 43.89, N = 12SE +/- 64.70, N = 12SE +/- 48.06, N = 121306117310971. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latencyjammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.21122334455SE +/- 1.43, N = 12SE +/- 2.16, N = 12SE +/- 1.63, N = 1238.8043.9646.351. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 500 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 500 - Mode: Read Onlyjammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.290K180K270K360K450KSE +/- 1083.38, N = 3SE +/- 1020.15, N = 3SE +/- 2979.95, N = 101167544033493776861. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latencyjammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.20.96371.92742.89113.85484.8185SE +/- 0.039, N = 3SE +/- 0.003, N = 3SE +/- 0.010, N = 104.2831.2401.3251. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 100 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 100 - Mode: Read Writejammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.230060090012001500SE +/- 49.47, N = 12SE +/- 49.49, N = 12SE +/- 39.91, N = 91316127011731. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latencyjammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.220406080100SE +/- 3.13, N = 12SE +/- 2.92, N = 12SE +/- 2.51, N = 977.3079.9685.911. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 250 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 250 - Mode: Read Writejammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.230060090012001500SE +/- 46.13, N = 9SE +/- 46.10, N = 12SE +/- 40.39, N = 121373132712781. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latencyjammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.24080120160200SE +/- 6.89, N = 9SE +/- 6.61, N = 12SE +/- 6.00, N = 12183.91190.91197.711. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 500 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 500 - Mode: Read Writejammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.230060090012001500SE +/- 50.20, N = 12SE +/- 38.05, N = 12SE +/- 47.45, N = 121337120612531. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

PostgreSQL

Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latencyjammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.290180270360450SE +/- 15.64, N = 12SE +/- 11.17, N = 12SE +/- 14.11, N = 12380.46418.55405.081. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

RocksDB

Test: Random Fill

OpenBenchmarking.orgOp/s, More Is BetterRocksDB 8.0Test: Random Filljammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.260K120K180K240K300KSE +/- 1638.61, N = 3SE +/- 1950.51, N = 15SE +/- 3073.14, N = 31901813019623010841. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

RocksDB

Test: Random Read

OpenBenchmarking.orgOp/s, More Is BetterRocksDB 8.0Test: Random Readjammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.220M40M60M80M100MSE +/- 33995.69, N = 3SE +/- 867711.58, N = 3SE +/- 479459.72, N = 32233466289901681904370131. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

RocksDB

Test: Update Random

OpenBenchmarking.orgOp/s, More Is BetterRocksDB 8.0Test: Update Randomjammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.260K120K180K240K300KSE +/- 1492.03, N = 15SE +/- 3791.43, N = 3SE +/- 3807.92, N = 31399142734802722731. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

RocksDB

Test: Sequential Fill

OpenBenchmarking.orgOp/s, More Is BetterRocksDB 8.0Test: Sequential Filljammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.270K140K210K280K350KSE +/- 8397.06, N = 12SE +/- 3333.78, N = 15SE +/- 4875.38, N = 152126283235473137681. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

RocksDB

Test: Random Fill Sync

OpenBenchmarking.orgOp/s, More Is BetterRocksDB 8.0Test: Random Fill Syncjammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.230060090012001500SE +/- 2.31, N = 3SE +/- 25.77, N = 12SE +/- 17.17, N = 3481158114961. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

RocksDB

Test: Read While Writing

OpenBenchmarking.orgOp/s, More Is BetterRocksDB 8.0Test: Read While Writingjammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.2300K600K900K1200K1500KSE +/- 3965.08, N = 5SE +/- 10796.41, N = 15SE +/- 12928.10, N = 3355565137370413702221. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

RocksDB

Test: Read Random Write Random

OpenBenchmarking.orgOp/s, More Is BetterRocksDB 8.0Test: Read Random Write Randomjammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.2200K400K600K800K1000KSE +/- 3024.16, N = 12SE +/- 1209.49, N = 3SE +/- 7678.08, N = 3422690107622210905271. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

Phoronix Test Suite v10.8.5