FNOX Postgres Disk Benchmarks

Virtual and Physical Appliance Disk Performance Testing

HTML result view exported from: https://openbenchmarking.org/result/1604154-GA-1603093HA25.

FNOX Postgres Disk BenchmarksProcessorMotherboardChipsetMemoryDiskGraphicsNetworkAudioOSKernelCompilerFile-SystemScreen ResolutionSystem Layerphysical-ibm840-fckvm-ibm840-nocachevmware-ibm840-fcV7000-hdd-raid10vmware-ibm840-prodopenstack-alt2Intel 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 PCIeCentOS Linux 73.10.0-327.4.5.el7.x86_64 (x86_64)GCC 4.8.5 20150623xfs1024x76816 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-2660 0 @ 2.20GHz (4 Cores)21GB Virtual disk + 11GB Virtual disk3.10.0-229.el7.x86_64 (x86_64)1176x8854 x Intel Xeon E312xx (Sandy Bridge) @ 2.00GHz (4 Cores)Fedora OpenStack Nova1 x 4096 MB RAM50GB3.10.0-327.13.1.el7.x86_64 (x86_64)1024x768KVMOpenBenchmarking.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=generic Processor Details- physical-ibm840-fc: Scaling Governor: intel_pstate powersave

FNOX Postgres Disk Benchmarkspgbench: On-Disk - Normal Load - Read Onlypgbench: On-Disk - Normal Load - Read Writepgbench: On-Disk - Single Thread - Read Onlypgbench: On-Disk - Single Thread - Read Writepgbench: On-Disk - Heavy Contention - Read Onlypgbench: On-Disk - Heavy Contention - Read Writepgbench: Mostly RAM - Normal Load - Read Onlypgbench: Buffer Test - Normal Load - Read Onlypgbench: Mostly RAM - Normal Load - Read Writepgbench: Buffer Test - Normal Load - Read Writepgbench: Mostly RAM - Single Thread - Read Onlypgbench: Buffer Test - Single Thread - Read Onlypgbench: Mostly RAM - Single Thread - Read Writepgbench: Buffer Test - Single Thread - Read Writepgbench: Mostly RAM - Heavy Contention - Read Onlypgbench: Buffer Test - Heavy Contention - Read Onlypgbench: Mostly RAM - Heavy Contention - Read Writepgbench: Buffer Test - Heavy Contention - Read Writephysical-ibm840-fckvm-ibm840-nocachevmware-ibm840-fcV7000-hdd-raid10vmware-ibm840-prodopenstack-alt239362.1510659.951936.80766.3339670.7211537.8523322.775725.571248.78353.7423325.516151.4723293.627353.591896.23632.2323436.947823.9148160.041745.5310606.66331.8056228.661727.2035727.6637315.462038.832196.018071.958315.78431.16505.5636810.7040410.352725.442456.3148884.821980.5311028.84439.0553864.981667.6836764.4638691.484351.404788.618474.108600.96718.44855.3036851.5440873.614620.004423.952809.901192.81952.41334.492565.451518.7025553.4028571.802129.502191.167754.958221.23522.33630.5621623.8622557.492524.822277.25OpenBenchmarking.org

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-ibm840-fckvm-ibm840-nocachevmware-ibm840-fcV7000-hdd-raid10vmware-ibm840-prodopenstack-alt210K20K30K40K50KSE +/- 24.05, N = 3SE +/- 49.04, N = 3SE +/- 51.99, N = 3SE +/- 138.17, N = 3SE +/- 282.64, N = 3SE +/- 47.74, N = 339362.1523322.7723293.6248160.0448884.822809.901. (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-ibm840-fckvm-ibm840-nocachevmware-ibm840-fcV7000-hdd-raid10vmware-ibm840-prodopenstack-alt22K4K6K8K10KSE +/- 13.82, N = 3SE +/- 4.86, N = 3SE +/- 8.93, N = 3SE +/- 30.98, N = 3SE +/- 4.53, N = 3SE +/- 10.00, N = 310659.955725.577353.591745.531980.531192.811. (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-ibm840-fckvm-ibm840-nocachevmware-ibm840-fcV7000-hdd-raid10vmware-ibm840-prodopenstack-alt22K4K6K8K10KSE +/- 11.26, N = 3SE +/- 22.45, N = 6SE +/- 29.47, N = 3SE +/- 38.82, N = 3SE +/- 136.06, N = 3SE +/- 10.23, N = 31936.801248.781896.2310606.6611028.84952.411. (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-ibm840-fckvm-ibm840-nocachevmware-ibm840-fcV7000-hdd-raid10vmware-ibm840-prodopenstack-alt2170340510680850SE +/- 4.59, N = 3SE +/- 11.24, N = 6SE +/- 11.03, N = 3SE +/- 4.21, N = 3SE +/- 0.59, N = 3SE +/- 4.06, N = 3766.33353.74632.23331.80439.05334.491. (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-ibm840-fckvm-ibm840-nocachevmware-ibm840-fcV7000-hdd-raid10vmware-ibm840-prodopenstack-alt212K24K36K48K60KSE +/- 9.33, N = 3SE +/- 18.75, N = 3SE +/- 35.69, N = 3SE +/- 149.79, N = 3SE +/- 1383.47, N = 6SE +/- 69.41, N = 639670.7223325.5123436.9456228.6653864.982565.451. (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 Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: On-Disk - Test: Heavy Contention - Mode: Read Writephysical-ibm840-fckvm-ibm840-nocachevmware-ibm840-fcV7000-hdd-raid10vmware-ibm840-prodopenstack-alt22K4K6K8K10KSE +/- 150.51, N = 3SE +/- 75.27, N = 3SE +/- 92.03, N = 3SE +/- 35.59, N = 6SE +/- 11.38, N = 3SE +/- 21.00, N = 311537.856151.477823.911727.201667.681518.701. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Mostly RAM - Test: Normal Load - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: Mostly RAM - Test: Normal Load - Mode: Read OnlyV7000-hdd-raid10vmware-ibm840-prodopenstack-alt28K16K24K32K40KSE +/- 129.53, N = 3SE +/- 192.74, N = 3SE +/- 333.03, N = 335727.6636764.4625553.401. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Buffer Test - Test: Normal Load - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: Buffer Test - Test: Normal Load - Mode: Read OnlyV7000-hdd-raid10vmware-ibm840-prodopenstack-alt28K16K24K32K40KSE +/- 15.62, N = 3SE +/- 149.58, N = 3SE +/- 127.74, N = 337315.4638691.4828571.801. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Mostly RAM - Test: Normal Load - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: Mostly RAM - Test: Normal Load - Mode: Read WriteV7000-hdd-raid10vmware-ibm840-prodopenstack-alt29001800270036004500SE +/- 32.92, N = 3SE +/- 20.55, N = 3SE +/- 9.34, N = 32038.834351.402129.501. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Buffer Test - Test: Normal Load - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: Buffer Test - Test: Normal Load - Mode: Read WriteV7000-hdd-raid10vmware-ibm840-prodopenstack-alt210002000300040005000SE +/- 53.86, N = 6SE +/- 3.28, N = 3SE +/- 47.85, N = 62196.014788.612191.161. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Mostly RAM - Test: Single Thread - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: Mostly RAM - Test: Single Thread - Mode: Read OnlyV7000-hdd-raid10vmware-ibm840-prodopenstack-alt22K4K6K8K10KSE +/- 24.28, N = 3SE +/- 30.91, N = 3SE +/- 48.22, N = 38071.958474.107754.951. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Buffer Test - Test: Single Thread - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: Buffer Test - Test: Single Thread - Mode: Read OnlyV7000-hdd-raid10vmware-ibm840-prodopenstack-alt22K4K6K8K10KSE +/- 103.74, N = 3SE +/- 154.24, N = 3SE +/- 62.63, N = 38315.788600.968221.231. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Mostly RAM - Test: Single Thread - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: Mostly RAM - Test: Single Thread - Mode: Read WriteV7000-hdd-raid10vmware-ibm840-prodopenstack-alt2150300450600750SE +/- 4.42, N = 3SE +/- 3.13, N = 3SE +/- 4.20, N = 3431.16718.44522.331. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Buffer Test - Test: Single Thread - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: Buffer Test - Test: Single Thread - Mode: Read WriteV7000-hdd-raid10vmware-ibm840-prodopenstack-alt22004006008001000SE +/- 5.82, N = 3SE +/- 2.19, N = 3SE +/- 5.13, N = 3505.56855.30630.561. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read OnlyV7000-hdd-raid10vmware-ibm840-prodopenstack-alt28K16K24K32K40KSE +/- 560.34, N = 6SE +/- 370.33, N = 3SE +/- 44.84, N = 336810.7036851.5421623.861. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: Buffer Test - Test: Heavy Contention - Mode: Read OnlyV7000-hdd-raid10vmware-ibm840-prodopenstack-alt29K18K27K36K45KSE +/- 284.97, N = 3SE +/- 222.62, N = 3SE +/- 360.02, N = 340410.3540873.6122557.491. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read WriteV7000-hdd-raid10vmware-ibm840-prodopenstack-alt210002000300040005000SE +/- 43.28, N = 6SE +/- 38.65, N = 3SE +/- 37.51, N = 62725.444620.002524.821. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: Buffer Test - Test: Heavy Contention - Mode: Read WriteV7000-hdd-raid10vmware-ibm840-prodopenstack-alt29001800270036004500SE +/- 37.56, N = 6SE +/- 12.82, N = 3SE +/- 35.10, N = 32456.314423.952277.251. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

Phoronix Test Suite v10.8.4