nvme_ext4_pgbench

Intel Core i5-8400 testing with a ASRock B360M Pro4 (P1.10 BIOS) and Intel UHD 630 CFL GT2 on Arch rolling via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2107279-IB-2107277IB58&grr&sro&rro.

nvme_ext4_pgbenchProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay ServerOpenGLCompilerFile-SystemScreen Resolutionnvme_ext4_pgbenchnvme-pgbench-ext4-btrfszfsIntel Core i5-8400 @ 4.00GHz (6 Cores)ASRock B360M Pro4 (P1.10 BIOS)Intel Cannon Lake PCH24GB1000GB Western Digital WDS100T3X0C-00SJG0 + 500GB CT500MX500SSD1 + 62GB UltraIntel UHD 630 CFL GT2 (1050MHz)Realtek ALC892HP w2207Intel I219-VArch rolling5.13.4-arch2-1 (x86_64)Sway 1.6.1X Server 1.20.9 + Wayland4.6 Mesa 21.1.5GCC 11.1.0 + Clang 12.0.1ext44240x1440btrfs5.13.5-arch1-1 (x86_64)zfsOpenBenchmarking.orgKernel Details- Transparent Huge Pages: madviseCompiler Details- --disable-libssp --disable-libstdcxx-pch --disable-libunwind-exceptions --disable-werror --enable-__cxa_atexit --enable-cet=auto --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-default-ssp --enable-gnu-indirect-function --enable-gnu-unique-object --enable-install-libiberty --enable-languages=c,c++,ada,fortran,go,lto,objc,obj-c++,d --enable-lto --enable-multilib --enable-plugin --enable-shared --enable-threads=posix --mandir=/usr/share/man --with-isl --with-linker-hash-style=gnu Processor Details- Scaling Governor: intel_pstate powersave - CPU Microcode: 0x84Security Details- itlb_multihit: KVM: Mitigation of VMX disabled + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT disabled + mds: Vulnerable: Clear buffers attempted no microcode; SMT disabled + meltdown: Mitigation of PTI + spec_store_bypass: Vulnerable + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Full generic retpoline IBPB: conditional IBRS_FW STIBP: disabled RSB filling + srbds: Vulnerable: No microcode + tsx_async_abort: Not affected

nvme_ext4_pgbenchpgbench: 1000 - 1 - Read Write - Average Latencypgbench: 1000 - 1 - Read Writepgbench: 1 - 100 - Read Write - Average Latencypgbench: 1 - 100 - Read Writepgbench: 1 - 1 - Read Write - Average Latencypgbench: 1 - 1 - Read Writepgbench: 1 - 1 - Read Only - Average Latencypgbench: 1 - 1 - Read Onlypgbench: 1000 - 100 - Read Write - Average Latencypgbench: 1000 - 100 - Read Writepgbench: 1000 - 1 - Read Only - Average Latencypgbench: 1000 - 1 - Read Onlypgbench: 1000 - 100 - Read Only - Average Latencypgbench: 1000 - 100 - Read Onlypgbench: 1 - 100 - Read Only - Average Latencypgbench: 1 - 100 - Read Onlynvme_ext4_pgbenchnvme-pgbench-ext4-btrfszfs0.708141352.81218940.64815440.041246999.031110740.045219731.055947550.9391064472.231448172.9365801.8535410.0382654814.19970430.045221541.050952270.8261210931.14588057.55917370.97410270.0422396417.34557650.14668533.378296080.943106060OpenBenchmarking.org

PostgreSQL pgbench

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latencyzfsnvme_ext4_pgbenchnvme-pgbench-ext4-btrfs0.5021.0041.5062.0082.51SE +/- 0.031, N = 12SE +/- 0.004, N = 3SE +/- 0.025, N = 31.1450.7082.2311. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 1 - Mode: Read Writezfsnvme_ext4_pgbenchnvme-pgbench-ext4-btrfs30060090012001500SE +/- 23.02, N = 12SE +/- 8.66, N = 3SE +/- 5.05, N = 388014134481. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latencyzfsnvme_ext4_pgbenchnvme-pgbench-ext4-btrfs4080120160200SE +/- 0.15, N = 3SE +/- 0.30, N = 3SE +/- 2.19, N = 1557.5652.81172.941. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 100 - Mode: Read Writezfsnvme_ext4_pgbenchnvme-pgbench-ext4-btrfs400800120016002000SE +/- 4.52, N = 3SE +/- 10.89, N = 3SE +/- 7.69, N = 15173718945801. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latencyzfsnvme_ext4_pgbenchnvme-pgbench-ext4-btrfs0.41690.83381.25071.66762.0845SE +/- 0.011, N = 4SE +/- 0.000, N = 3SE +/- 0.021, N = 140.9740.6481.8531. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 1 - Mode: Read Writezfsnvme_ext4_pgbenchnvme-pgbench-ext4-btrfs30060090012001500SE +/- 11.66, N = 4SE +/- 1.02, N = 3SE +/- 6.13, N = 14102715445411. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latencyzfsnvme_ext4_pgbenchnvme-pgbench-ext4-btrfs0.00950.0190.02850.0380.0475SE +/- 0.000, N = 3SE +/- 0.000, N = 15SE +/- 0.000, N = 30.0420.0410.0381. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 1 - Mode: Read Onlyzfsnvme_ext4_pgbenchnvme-pgbench-ext4-btrfs6K12K18K24K30KSE +/- 113.65, N = 3SE +/- 186.70, N = 15SE +/- 55.43, N = 32396424699265481. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latencyzfsnvme_ext4_pgbenchnvme-pgbench-ext4-btrfs48121620SE +/- 0.017, N = 3SE +/- 0.054, N = 3SE +/- 0.044, N = 317.3459.03114.1991. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 100 - Mode: Read Writezfsnvme_ext4_pgbenchnvme-pgbench-ext4-btrfs2K4K6K8K10KSE +/- 5.74, N = 3SE +/- 66.67, N = 3SE +/- 21.80, N = 357651107470431. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latencyzfsnvme_ext4_pgbenchnvme-pgbench-ext4-btrfs0.03290.06580.09870.13160.1645SE +/- 0.002, N = 3SE +/- 0.000, N = 3SE +/- 0.000, N = 30.1460.0450.0451. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 1 - Mode: Read Onlyzfsnvme_ext4_pgbenchnvme-pgbench-ext4-btrfs5K10K15K20K25KSE +/- 79.57, N = 3SE +/- 141.35, N = 3SE +/- 128.98, N = 3685321973221541. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latencyzfsnvme_ext4_pgbenchnvme-pgbench-ext4-btrfs0.76011.52022.28033.04043.8005SE +/- 0.013, N = 3SE +/- 0.001, N = 3SE +/- 0.002, N = 33.3781.0551.0501. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 100 - Mode: Read Onlyzfsnvme_ext4_pgbenchnvme-pgbench-ext4-btrfs20K40K60K80K100KSE +/- 110.02, N = 3SE +/- 87.00, N = 3SE +/- 220.93, N = 32960894755952271. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latencyzfsnvme_ext4_pgbenchnvme-pgbench-ext4-btrfs0.21220.42440.63660.84881.061SE +/- 0.012, N = 3SE +/- 0.006, N = 3SE +/- 0.007, N = 30.9430.9390.8261. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 100 - Mode: Read Onlyzfsnvme_ext4_pgbenchnvme-pgbench-ext4-btrfs30K60K90K120K150KSE +/- 1333.67, N = 3SE +/- 697.10, N = 3SE +/- 1073.76, N = 31060601064471210931. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

Phoronix Test Suite v10.8.5