FNOX Postgres Disk Benchmarks

Virtual and Physical Appliance Disk Performance Testing

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 1603081-HA-1603085GA72
Jump To Table - Results

View

Do Not Show Noisy Results
Do Not Show Results With Incomplete Data
Do Not Show Results With Little Change/Spread
List Notable Results

Statistics

Show Overall Harmonic Mean(s)
Show Overall Geometric Mean
Show Wins / Losses Counts (Pie Chart)
Normalize Results
Remove Outliers Before Calculating Averages

Graph Settings

Force Line Graphs Where Applicable
Convert To Scalar Where Applicable
Prefer Vertical Bar Graphs

Additional Graphs

Show Perf Per Core/Thread Calculation Graphs Where Applicable
Show Perf Per Clock Calculation Graphs Where Applicable

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Highlight
Result
Hide
Result
Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
physical-ssd-raid1
February 16 2016
 
V7000gen2-ssd-raid1
February 17 2016
 
V7000-hdd-raid10
March 01 2016
 
physical-ibm840-fc
March 02 2016
 
kvm-ibm840-nocache
March 04 2016
 
kvm-ibm840-writeback
March 07 2016
 
kvm-ibm840-writethrough
March 07 2016
 
kvm-ibm840-directsync
March 07 2016
 
Invert Hiding All Results Option
 

Only show results where is faster than
Only show results matching title/arguments (delimit multiple options with a comma):
Do not show results matching title/arguments (delimit multiple options with a comma):


FNOX Postgres Disk BenchmarksProcessorMotherboardMemoryDiskChipsetGraphicsNetworkAudioOSKernelCompilerFile-SystemScreen ResolutionSystem Layerphysical-ssd-raid1V7000gen2-ssd-raid1V7000-hdd-raid10physical-ibm840-fckvm-ibm840-nocachekvm-ibm840-writebackkvm-ibm840-writethroughkvm-ibm840-directsyncIntel 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)KVMOpenBenchmarking.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

physical-ssd-raid1V7000gen2-ssd-raid1V7000-hdd-raid10physical-ibm840-fckvm-ibm840-nocachekvm-ibm840-writebackkvm-ibm840-writethroughkvm-ibm840-directsyncResult OverviewPhoronix Test Suite100%506%913%1319%1726%PostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchOn-Disk - Single Thread - Read OnlyOn-Disk - Single Thread - Read WriteOn-Disk - Heavy Contention - Read OnlyOn-Disk - Normal Load - Read OnlyOn-Disk - Heavy Contention - Read WriteOn-Disk - Normal Load - Read Write

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-raid10physical-ibm840-fckvm-ibm840-nocachekvm-ibm840-writebackkvm-ibm840-writethroughkvm-ibm840-directsync39246.776363.742205.51727.7839514.476781.5149543.77682.0011100.70166.3157205.19668.6747878.77674.9111292.74152.9256148.00682.2339362.1510659.951936.80766.3339670.7211537.8523322.775725.571248.78353.7423325.516151.4734866.245017.901500.62379.6034833.135302.1034648.353720.571487.66366.9635126.863786.9423355.795685.811233.24352.0723347.936033.66OpenBenchmarking.org

PostgreSQL pgbench

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-directsync11K22K33K44K55KSE +/- 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 = 339246.7749543.7747878.7739362.1523322.7734866.2434648.3523355.791. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
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-directsync9K18K27K36K45KMin: 39156.13 / Avg: 39246.77 / Max: 39332.97Min: 49172.03 / Avg: 49543.77 / Max: 49861.71Min: 47304.54 / Avg: 47878.77 / Max: 48754.18Min: 39336.1 / Avg: 39362.15 / Max: 39410.18Min: 23231.31 / Avg: 23322.77 / Max: 23399.19Min: 34663.76 / Avg: 34866.24 / Max: 35183.58Min: 34497.97 / Avg: 34648.35 / Max: 34743.13Min: 23316.07 / Avg: 23355.79 / Max: 23378.031. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

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-directsync2K4K6K8K10KSE +/- 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 = 36363.74682.00674.9110659.955725.575017.903720.575685.811. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
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-directsync2K4K6K8K10KMin: 6310.42 / Avg: 6363.74 / Max: 6422.16Min: 680.68 / Avg: 682 / Max: 683.26Min: 672.36 / Avg: 674.91 / Max: 677.19Min: 10634.19 / Avg: 10659.95 / Max: 10681.52Min: 5718.25 / Avg: 5725.57 / Max: 5734.77Min: 3378.11 / Avg: 5017.9 / Max: 5381.98Min: 3713.36 / Avg: 3720.57 / Max: 3732.57Min: 5662.76 / Avg: 5685.81 / Max: 5713.021. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

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-directsync2K4K6K8K10KSE +/- 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 = 32205.5111100.7011292.741936.801248.781500.621487.661233.241. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
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-directsync2K4K6K8K10KMin: 2167.1 / Avg: 2205.51 / Max: 2233.4Min: 10909.87 / Avg: 11100.7 / Max: 11254.83Min: 11246.81 / Avg: 11292.74 / Max: 11334.57Min: 1919.79 / Avg: 1936.8 / Max: 1958.1Min: 1179.85 / Avg: 1248.78 / Max: 1328.75Min: 1413.42 / Avg: 1500.62 / Max: 1552.89Min: 1441.04 / Avg: 1487.66 / Max: 1529.69Min: 1209.22 / Avg: 1233.24 / Max: 1261.381. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

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-directsync170340510680850SE +/- 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 = 6727.78166.31152.92766.33353.74379.60366.96352.071. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
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-directsync130260390520650Min: 680.65 / Avg: 727.78 / Max: 789.2Min: 165.57 / Avg: 166.31 / Max: 167.41Min: 151.39 / Avg: 152.92 / Max: 154.78Min: 757.49 / Avg: 766.33 / Max: 772.88Min: 320.63 / Avg: 353.74 / Max: 403.43Min: 345.78 / Avg: 379.6 / Max: 406.65Min: 329.78 / Avg: 366.96 / Max: 390.98Min: 332.03 / Avg: 352.07 / Max: 382.141. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

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-directsync12K24K36K48K60KSE +/- 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 = 339514.4757205.1956148.0039670.7223325.5134833.1335126.8623347.931. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
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-directsync10K20K30K40K50KMin: 39277.41 / Avg: 39514.47 / Max: 39802.92Min: 56689.71 / Avg: 57205.19 / Max: 57817.03Min: 55009.34 / Avg: 56148 / Max: 57095.08Min: 39653.4 / Avg: 39670.72 / Max: 39685.38Min: 23297.53 / Avg: 23325.51 / Max: 23361.12Min: 34747.43 / Avg: 34833.13 / Max: 34986Min: 35106.94 / Avg: 35126.86 / Max: 35138.1Min: 23335.62 / Avg: 23347.93 / Max: 23364.451. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

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-directsync2K4K6K8K10KSE +/- 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 = 36781.51668.67682.2311537.856151.475302.103786.946033.661. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
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-directsync2K4K6K8K10KMin: 6623.93 / Avg: 6781.51 / Max: 6864.26Min: 665.99 / Avg: 668.67 / Max: 671.95Min: 679.39 / Avg: 682.23 / Max: 684.04Min: 11236.83 / Avg: 11537.85 / Max: 11689.09Min: 6001.16 / Avg: 6151.47 / Max: 6233.62Min: 5274.76 / Avg: 5302.1 / Max: 5328.38Min: 3760.13 / Avg: 3786.94 / Max: 3807.2Min: 6028.94 / Avg: 6033.66 / Max: 6040.381. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm