FNOX Postgres Disk Benchmarks

Virtual and Physical Appliance Disk Performance Testing

HTML result view exported from: https://openbenchmarking.org/result/1603028-HA-1602177HA08.

FNOX Postgres Disk BenchmarksProcessorMotherboardMemoryDiskOSKernelCompilerFile-SystemScreen ResolutionSystem Layerphysical-ssd-raid1V7000gen2-ssd-raid1V7000-hdd-raid10Intel 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)1176x885VMwareOpenBenchmarking.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-ssd-raid1: 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 Writephysical-ssd-raid1V7000gen2-ssd-raid1V7000-hdd-raid1039246.776363.742205.51727.7839514.476781.5149543.77682.0011100.70166.3157205.19668.6747878.77674.9111292.74152.9256148.00682.23OpenBenchmarking.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-ssd-raid1V7000gen2-ssd-raid1V7000-hdd-raid1011K22K33K44K55KSE +/- 51.10, N = 3SE +/- 200.90, N = 3SE +/- 444.74, N = 339246.7749543.7747878.771. (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-raid1014002800420056007000SE +/- 32.36, N = 3SE +/- 0.74, N = 3SE +/- 1.40, N = 36363.74682.00674.911. (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-raid102K4K6K8K10KSE +/- 19.85, N = 3SE +/- 101.26, N = 3SE +/- 25.42, N = 32205.5111100.7011292.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-raid10160320480640800SE +/- 20.63, N = 5SE +/- 0.56, N = 3SE +/- 0.99, N = 3727.78166.31152.921. (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-raid1012K24K36K48K60KSE +/- 153.86, N = 3SE +/- 328.98, N = 3SE +/- 609.68, N = 339514.4757205.1956148.001. (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-ssd-raid1V7000gen2-ssd-raid1V7000-hdd-raid1015003000450060007500SE +/- 78.82, N = 3SE +/- 1.75, N = 3SE +/- 1.44, N = 36781.51668.67682.231. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

Phoronix Test Suite v10.8.4