FNOX Postgres Disk Benchmarks

Virtual and Physical Appliance Disk Performance Testing

HTML result view exported from: https://openbenchmarking.org/result/1603112-GA-1603099GA27&rdt&grs.

FNOX Postgres Disk BenchmarksProcessorMotherboardMemoryDiskChipsetGraphicsNetworkAudioOSKernelCompilerFile-SystemScreen ResolutionSystem Layerphysical-ssd-raid1V7000gen2-ssd-raid1V7000-hdd-raid10physical-ibm840-fckvm-ibm840-nocachekvm-ibm840-writebackkvm-ibm840-writethroughkvm-ibm840-directsyncvmware-ssd-raid1vmware-ibm840-fcvmware-alt1-goldIntel Xeon E5-2630 v3 @ 3.20GHz (16 Cores)LENOVO 00YJ4231 x 16384 MB 2133MHz Hynix959GB ServeRAID M5210CentOS Linux 73.10.0-327.4.5.el7.x86_64 (x86_64)GCC 4.8.5 20150623xfs1024x768Intel Xeon E5-2660 0 @ 2.20GHz (4 Cores)Intel 440BX1 x 16384 MB DRAM21GB Virtual disk + 11GB Virtual disk3.10.0-229.el7.x86_64 (x86_64)1176x885VMwareIntel Xeon E5-2630 v3 @ 3.20GHz (16 Cores)LENOVO 00YJ423Intel Xeon E7 v3/Xeon1 x 16384 MB 2133MHz Hynix959GB ServeRAID M5210 + 2 x 2199GB FlashSystem-9840Matrox s G200eR2Broadcom NetXtreme BCM5719 Gigabit PCIe3.10.0-327.4.5.el7.x86_64 (x86_64)1024x76816 x Intel Core (Haswell) @ 2.40GHz (16 Cores)Red Hat KVM1 x 4096 MB RAM50GBQEMU ID 223.10.0-327.el7.x86_64 (x86_64)KVM2 x Intel Xeon E5-2630 v3 @ 2.40GHz (16 Cores)Intel 440BX1 x 4096 MB DRAM21GB Virtual disk + 107GB Virtual disk1672x1254VMwareIntel Xeon E5-2683 v3 @ 2.00GHz (4 Cores)54GB Virtual disk3.10.0-229.el7.x86_64 (x86_64)OpenBenchmarking.orgCompiler Details- --build=x86_64-redhat-linux --disable-libgcj --disable-libunwind-exceptions --enable-__cxa_atexit --enable-bootstrap --enable-checking=release --enable-gnu-indirect-function --enable-gnu-unique-object --enable-initfini-array --enable-languages=c,c++,objc,obj-c++,java,fortran,ada,go,lto --enable-plugin --enable-shared --enable-threads=posix --mandir=/usr/share/man --with-arch_32=x86-64 --with-linker-hash-style=gnu --with-tune=genericProcessor Details- physical-ssd-raid1, physical-ibm840-fc: Scaling Governor: intel_pstate powersave

FNOX Postgres Disk Benchmarkspgbench: On-Disk - Heavy Contention - Read Writepgbench: On-Disk - Normal Load - Read Onlypgbench: On-Disk - Single Thread - Read Onlypgbench: On-Disk - Heavy Contention - Read Onlypgbench: On-Disk - Normal Load - Read Writepgbench: On-Disk - Single Thread - Read Writephysical-ssd-raid1V7000gen2-ssd-raid1V7000-hdd-raid10physical-ibm840-fckvm-ibm840-nocachekvm-ibm840-writebackkvm-ibm840-writethroughkvm-ibm840-directsyncvmware-ssd-raid1vmware-ibm840-fcvmware-alt1-gold6781.5139246.772205.5139514.476363.74727.78668.6749543.7711100.7057205.19682.00166.31682.2347878.7711292.7456148.00674.91152.9211537.8539362.151936.8039670.7210659.95766.336151.4723322.771248.7823325.515725.57353.745302.1034866.241500.6234833.135017.90379.603786.9434648.351487.6635126.863720.57366.966033.6623355.791233.2423347.935685.81352.074991.6427212.392473.7627571.754887.38835.747823.9123293.621896.2323436.947353.59632.23234.061634.9044.61230.95688.7430.19OpenBenchmarking.org

PostgreSQL pgbench

Scaling: On-Disk - Test: Heavy Contention - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: On-Disk - Test: Heavy Contention - Mode: Read Writephysical-ssd-raid1V7000gen2-ssd-raid1V7000-hdd-raid10physical-ibm840-fckvm-ibm840-nocachekvm-ibm840-writebackkvm-ibm840-writethroughkvm-ibm840-directsyncvmware-ssd-raid1vmware-ibm840-fcvmware-alt1-gold2K4K6K8K10KSE +/- 78.82, N = 3SE +/- 1.75, N = 3SE +/- 1.44, N = 3SE +/- 150.51, N = 3SE +/- 75.27, N = 3SE +/- 15.49, N = 3SE +/- 13.98, N = 3SE +/- 3.45, N = 3SE +/- 8.03, N = 3SE +/- 92.03, N = 3SE +/- 4.82, N = 66781.51668.67682.2311537.856151.475302.103786.946033.664991.647823.91234.061. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: On-Disk - Test: Normal Load - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: On-Disk - Test: Normal Load - Mode: Read Onlyphysical-ssd-raid1V7000gen2-ssd-raid1V7000-hdd-raid10physical-ibm840-fckvm-ibm840-nocachekvm-ibm840-writebackkvm-ibm840-writethroughkvm-ibm840-directsyncvmware-ssd-raid1vmware-ibm840-fcvmware-alt1-gold11K22K33K44K55KSE +/- 51.10, N = 3SE +/- 200.90, N = 3SE +/- 444.74, N = 3SE +/- 24.05, N = 3SE +/- 49.04, N = 3SE +/- 160.67, N = 3SE +/- 76.03, N = 3SE +/- 19.91, N = 3SE +/- 315.87, N = 3SE +/- 51.99, N = 3SE +/- 208.65, N = 639246.7749543.7747878.7739362.1523322.7734866.2434648.3523355.7927212.3923293.621634.901. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: On-Disk - Test: Single Thread - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: On-Disk - Test: Single Thread - Mode: Read Onlyphysical-ssd-raid1V7000gen2-ssd-raid1V7000-hdd-raid10physical-ibm840-fckvm-ibm840-nocachekvm-ibm840-writebackkvm-ibm840-writethroughkvm-ibm840-directsyncvmware-ssd-raid1vmware-ibm840-fcvmware-alt1-gold2K4K6K8K10KSE +/- 19.85, N = 3SE +/- 101.26, N = 3SE +/- 25.42, N = 3SE +/- 11.26, N = 3SE +/- 22.45, N = 6SE +/- 22.81, N = 6SE +/- 25.69, N = 3SE +/- 15.20, N = 3SE +/- 2.98, N = 3SE +/- 29.47, N = 3SE +/- 2.96, N = 62205.5111100.7011292.741936.801248.781500.621487.661233.242473.761896.2344.611. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: On-Disk - Test: Heavy Contention - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: On-Disk - Test: Heavy Contention - Mode: Read Onlyphysical-ssd-raid1V7000gen2-ssd-raid1V7000-hdd-raid10physical-ibm840-fckvm-ibm840-nocachekvm-ibm840-writebackkvm-ibm840-writethroughkvm-ibm840-directsyncvmware-ssd-raid1vmware-ibm840-fcvmware-alt1-gold12K24K36K48K60KSE +/- 153.86, N = 3SE +/- 328.98, N = 3SE +/- 609.68, N = 3SE +/- 9.33, N = 3SE +/- 18.75, N = 3SE +/- 76.62, N = 3SE +/- 9.99, N = 3SE +/- 8.59, N = 3SE +/- 138.28, N = 3SE +/- 35.69, N = 3SE +/- 44.26, N = 639514.4757205.1956148.0039670.7223325.5134833.1335126.8623347.9327571.7523436.94230.951. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: On-Disk - Test: Normal Load - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: On-Disk - Test: Normal Load - Mode: Read Writephysical-ssd-raid1V7000gen2-ssd-raid1V7000-hdd-raid10physical-ibm840-fckvm-ibm840-nocachekvm-ibm840-writebackkvm-ibm840-writethroughkvm-ibm840-directsyncvmware-ssd-raid1vmware-ibm840-fcvmware-alt1-gold2K4K6K8K10KSE +/- 32.36, N = 3SE +/- 0.74, N = 3SE +/- 1.40, N = 3SE +/- 13.82, N = 3SE +/- 4.86, N = 3SE +/- 328.27, N = 6SE +/- 6.04, N = 3SE +/- 14.65, N = 3SE +/- 19.10, N = 3SE +/- 8.93, N = 3SE +/- 130.38, N = 66363.74682.00674.9110659.955725.575017.903720.575685.814887.387353.59688.741. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: On-Disk - Test: Single Thread - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: On-Disk - Test: Single Thread - Mode: Read Writephysical-ssd-raid1V7000gen2-ssd-raid1V7000-hdd-raid10physical-ibm840-fckvm-ibm840-nocachekvm-ibm840-writebackkvm-ibm840-writethroughkvm-ibm840-directsyncvmware-ssd-raid1vmware-ibm840-fcvmware-alt1-gold2004006008001000SE +/- 20.63, N = 5SE +/- 0.56, N = 3SE +/- 0.99, N = 3SE +/- 4.59, N = 3SE +/- 11.24, N = 6SE +/- 10.24, N = 6SE +/- 9.10, N = 6SE +/- 8.83, N = 6SE +/- 16.06, N = 3SE +/- 11.03, N = 3SE +/- 1.66, N = 6727.78166.31152.92766.33353.74379.60366.96352.07835.74632.2330.191. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

Phoronix Test Suite v10.8.4