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&grw&sor.

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 - 10000rocksdb: Rand Fillrocksdb: Rand Readrocksdb: Update Randrocksdb: Seq Fillrocksdb: Rand Fill Syncrocksdb: Read While Writingrocksdb: Read Rand Write Randpgbench: 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 Latencymysqlslap: 1mysqlslap: 64mysqlslap: 128mysqlslap: 256mysqlslap: 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.2528273.1690751.434650.419018122334662139914212628481355565422690313880.0334782.0941465430.3411344520.7441228392.037130638.8011167544.283131677.2961373183.9111337380.4631032292149127127766058.91422637.01610766.630196289901681273480323547158113737041076222339780.0304582.1834987310.1005114170.1963597640.695117343.9564033491.240127079.9631327190.9101206418.554972305205173170426060.0244792.0901033323206164152769556.01429053.11604726.130108490437013272273313768149613702221090527361260.0284722.1205157840.0975054830.1983498080.715109746.3463776861.325117385.9121278197.7051253405.0781025316194171171OpenBenchmarking.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_ibpb_big-hv_milan-6.2jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpd-hv_milan_6.6160K320K480K640K800KSE +/- 6485.90, N = 3SE +/- 7253.73, N = 3SE +/- 2236.56, N = 3769556.0766058.9528273.1

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_ibpb_big-hv_milan-6.2jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpd-hv_milan_6.6300K600K900K1200K1500KSE +/- 15741.74, N = 5SE +/- 9456.18, N = 13SE +/- 3008.21, N = 31429053.11422637.0690751.4

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_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.2jammy-epyc_rome_ibpd-hv_milan_6.6300K600K900K1200K1500KSE +/- 9278.36, N = 3SE +/- 21316.26, N = 3SE +/- 7773.54, N = 151610766.61604726.134650.4

RocksDB

Test: Random Fill

OpenBenchmarking.orgOp/s, More Is BetterRocksDB 8.0Test: Random Filljammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.2jammy-epyc_rome_ibpd-hv_milan_6.660K120K180K240K300KSE +/- 1950.51, N = 15SE +/- 3073.14, N = 3SE +/- 1638.61, N = 33019623010841901811. (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_ibpb_big-hv_milan-6.2jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpd-hv_milan_6.620M40M60M80M100MSE +/- 479459.72, N = 3SE +/- 867711.58, N = 3SE +/- 33995.69, N = 39043701389901681223346621. (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_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.2jammy-epyc_rome_ibpd-hv_milan_6.660K120K180K240K300KSE +/- 3791.43, N = 3SE +/- 3807.92, N = 3SE +/- 1492.03, N = 152734802722731399141. (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_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.2jammy-epyc_rome_ibpd-hv_milan_6.670K140K210K280K350KSE +/- 3333.78, N = 15SE +/- 4875.38, N = 15SE +/- 8397.06, N = 123235473137682126281. (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_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.2jammy-epyc_rome_ibpd-hv_milan_6.630060090012001500SE +/- 25.77, N = 12SE +/- 17.17, N = 3SE +/- 2.31, N = 3158114964811. (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_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.2jammy-epyc_rome_ibpd-hv_milan_6.6300K600K900K1200K1500KSE +/- 10796.41, N = 15SE +/- 12928.10, N = 3SE +/- 3965.08, N = 5137370413702223555651. (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_ibpb_big-hv_milan-6.2jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpd-hv_milan_6.6200K400K600K800K1000KSE +/- 7678.08, N = 3SE +/- 1209.49, N = 3SE +/- 3024.16, N = 12109052710762224226901. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 1 - Mode: Read Onlyjammy-epyc_rome_ibpb_med-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.2jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpd-hv_milan_6.69K18K27K36K45KSE +/- 1111.41, N = 12SE +/- 1597.17, N = 12SE +/- 1332.41, N = 12SE +/- 2533.19, N = 9426063612633978313881. (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_ibpb_med-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.2jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpd-hv_milan_6.60.00740.01480.02220.02960.037SE +/- 0.001, N = 12SE +/- 0.001, N = 12SE +/- 0.001, N = 12SE +/- 0.002, N = 90.0240.0280.0300.0331. (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_ibpb_med-hv_milan_6.6jammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.2jammy-epyc_rome_ibpb_big-hv_milan_6.6100200300400500SE +/- 4.69, N = 3SE +/- 5.76, N = 12SE +/- 5.95, N = 12SE +/- 3.82, N = 124794784724581. (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_ibpb_med-hv_milan_6.6jammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.2jammy-epyc_rome_ibpb_big-hv_milan_6.60.49120.98241.47361.96482.456SE +/- 0.021, N = 3SE +/- 0.025, N = 12SE +/- 0.026, N = 12SE +/- 0.018, N = 122.0902.0942.1202.1831. (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_ibpb_big-hv_milan-6.2jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpd-hv_milan_6.6110K220K330K440K550KSE +/- 6410.49, N = 4SE +/- 2922.45, N = 3SE +/- 1152.35, N = 35157844987311465431. (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_ibpb_big-hv_milan-6.2jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpd-hv_milan_6.60.07670.15340.23010.30680.3835SE +/- 0.001, N = 4SE +/- 0.000, N = 3SE +/- 0.003, N = 30.0970.1000.3411. (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_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.2jammy-epyc_rome_ibpd-hv_milan_6.6110K220K330K440K550KSE +/- 4390.54, N = 3SE +/- 3994.01, N = 12SE +/- 1085.16, N = 125114175054831344521. (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_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.2jammy-epyc_rome_ibpd-hv_milan_6.60.16740.33480.50220.66960.837SE +/- 0.002, N = 3SE +/- 0.001, N = 12SE +/- 0.006, N = 120.1960.1980.7441. (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_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.2jammy-epyc_rome_ibpd-hv_milan_6.680K160K240K320K400KSE +/- 3692.72, N = 3SE +/- 3714.50, N = 5SE +/- 983.66, N = 123597643498081228391. (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_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.2jammy-epyc_rome_ibpd-hv_milan_6.60.45830.91661.37491.83322.2915SE +/- 0.007, N = 3SE +/- 0.007, N = 5SE +/- 0.016, N = 120.6950.7152.0371. (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_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.2jammy-epyc_rome_ibpd-hv_milan_6.690K180K270K360K450KSE +/- 1020.15, N = 3SE +/- 2979.95, N = 10SE +/- 1083.38, N = 34033493776861167541. (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_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.2jammy-epyc_rome_ibpd-hv_milan_6.60.96371.92742.89113.85484.8185SE +/- 0.003, N = 3SE +/- 0.010, N = 10SE +/- 0.039, N = 31.2401.3254.2831. (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.2jammy-epyc_rome_ibpb_big-hv_milan_6.630060090012001500SE +/- 50.20, N = 12SE +/- 47.45, N = 12SE +/- 38.05, N = 121337125312061. (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.2jammy-epyc_rome_ibpb_big-hv_milan_6.690180270360450SE +/- 15.64, N = 12SE +/- 14.11, N = 12SE +/- 11.17, N = 12380.46405.08418.551. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

MariaDB

Clients: 1

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.0.1Clients: 1jammy-epyc_rome_ibpb_med-hv_milan_6.6jammy-epyc_rome_ibpd-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.2jammy-epyc_rome_ibpb_big-hv_milan_6.62004006008001000SE +/- 11.97, N = 14SE +/- 10.53, N = 6SE +/- 7.44, N = 12SE +/- 12.73, N = 121033103210259721. (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_ibpb_med-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.2jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpd-hv_milan_6.670140210280350SE +/- 1.82, N = 3SE +/- 1.90, N = 3SE +/- 3.95, N = 3SE +/- 3.19, N = 93233163052921. (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_ibpb_med-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.2jammy-epyc_rome_ibpd-hv_milan_6.650100150200250SE +/- 0.67, N = 3SE +/- 2.23, N = 4SE +/- 0.81, N = 3SE +/- 0.93, N = 32062051941491. (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_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_big-hv_milan-6.2jammy-epyc_rome_ibpb_med-hv_milan_6.6jammy-epyc_rome_ibpd-hv_milan_6.64080120160200SE +/- 1.86, N = 3SE +/- 1.73, N = 5SE +/- 2.13, N = 9SE +/- 0.15, N = 31731711641271. (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_ibpb_big-hv_milan-6.2jammy-epyc_rome_ibpb_big-hv_milan_6.6jammy-epyc_rome_ibpb_med-hv_milan_6.6jammy-epyc_rome_ibpd-hv_milan_6.64080120160200SE +/- 1.10, N = 3SE +/- 1.36, N = 3SE +/- 2.49, N = 9SE +/- 1.61, N = 31711701521271. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

Phoronix Test Suite v10.8.5