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 1603028-HA-1602177HA08
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
 
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):

physical-ssd-raid1

Processor: Intel Xeon E5-2630 v3 @ 3.20GHz (16 Cores), Motherboard: LENOVO 00YJ423, Memory: 1 x 16384 MB 2133MHz Hynix, Disk: 959GB ServeRAID M5210

OS: CentOS Linux 7, Kernel: 3.10.0-327.4.5.el7.x86_64 (x86_64), Compiler: GCC 4.8.5 20150623, File-System: xfs, Screen Resolution: 1024x768

Compiler Notes: --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 Notes: Scaling Governor: intel_pstate powersave

V7000gen2-ssd-raid1

Compiler Notes: --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

V7000-hdd-raid10

Processor: Intel Xeon E5-2660 0 @ 2.20GHz (4 Cores), Motherboard: Intel 440BX, Memory: 1 x 16384 MB DRAM, Disk: 21GB Virtual disk + 11GB Virtual disk

OS: CentOS Linux 7, Kernel: 3.10.0-229.el7.x86_64 (x86_64), Compiler: GCC 4.8.5 20150623, File-System: xfs, Screen Resolution: 1176x885, System Layer: VMware

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

physical-ssd-raid1V7000gen2-ssd-raid1V7000-hdd-raid10Result OverviewPhoronix Test Suite100%329%557%786%1014%PostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchOn-Disk - Normal Load - Read WriteOn-Disk - Single Thread - Read OnlyOn-Disk - Single Thread - Read WriteOn-Disk - Heavy Contention - Read WriteOn-Disk - Heavy Contention - Read OnlyOn-Disk - Normal Load - Read Only

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

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
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: On-Disk - Test: Normal Load - Mode: Read Onlyphysical-ssd-raid1V7000gen2-ssd-raid1V7000-hdd-raid109K18K27K36K45KMin: 39156.13 / Avg: 39246.77 / Max: 39332.97Min: 49172.03 / Avg: 49543.77 / Max: 49861.71Min: 47304.54 / Avg: 47878.77 / Max: 48754.181. (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-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
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: On-Disk - Test: Normal Load - Mode: Read Writephysical-ssd-raid1V7000gen2-ssd-raid1V7000-hdd-raid1011002200330044005500Min: 6310.42 / Avg: 6363.74 / Max: 6422.16Min: 680.68 / Avg: 682 / Max: 683.26Min: 672.36 / Avg: 674.91 / Max: 677.191. (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-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
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: On-Disk - Test: Single Thread - Mode: Read Onlyphysical-ssd-raid1V7000gen2-ssd-raid1V7000-hdd-raid102K4K6K8K10KMin: 2167.1 / Avg: 2205.51 / Max: 2233.4Min: 10909.87 / Avg: 11100.7 / Max: 11254.83Min: 11246.81 / Avg: 11292.74 / Max: 11334.571. (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-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
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: On-Disk - Test: Single Thread - Mode: Read Writephysical-ssd-raid1V7000gen2-ssd-raid1V7000-hdd-raid10130260390520650Min: 680.65 / Avg: 727.78 / Max: 789.2Min: 165.57 / Avg: 166.31 / Max: 167.41Min: 151.39 / Avg: 152.92 / Max: 154.781. (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-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
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: On-Disk - Test: Heavy Contention - Mode: Read Onlyphysical-ssd-raid1V7000gen2-ssd-raid1V7000-hdd-raid1010K20K30K40K50KMin: 39277.41 / Avg: 39514.47 / Max: 39802.92Min: 56689.71 / Avg: 57205.19 / Max: 57817.03Min: 55009.34 / Avg: 56148 / Max: 57095.081. (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-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
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 9.4.3Scaling: On-Disk - Test: Heavy Contention - Mode: Read Writephysical-ssd-raid1V7000gen2-ssd-raid1V7000-hdd-raid1012002400360048006000Min: 6623.93 / Avg: 6781.51 / Max: 6864.26Min: 665.99 / Avg: 668.67 / Max: 671.95Min: 679.39 / Avg: 682.23 / Max: 684.041. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

physical-ssd-raid1

Processor: Intel Xeon E5-2630 v3 @ 3.20GHz (16 Cores), Motherboard: LENOVO 00YJ423, Memory: 1 x 16384 MB 2133MHz Hynix, Disk: 959GB ServeRAID M5210

OS: CentOS Linux 7, Kernel: 3.10.0-327.4.5.el7.x86_64 (x86_64), Compiler: GCC 4.8.5 20150623, File-System: xfs, Screen Resolution: 1024x768

Compiler Notes: --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 Notes: Scaling Governor: intel_pstate powersave

Testing initiated at 16 February 2016 11:49 by user .

V7000gen2-ssd-raid1

Compiler Notes: --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

Testing initiated at 17 February 2016 10:24 by user .

V7000-hdd-raid10

Processor: Intel Xeon E5-2660 0 @ 2.20GHz (4 Cores), Motherboard: Intel 440BX, Memory: 1 x 16384 MB DRAM, Disk: 21GB Virtual disk + 11GB Virtual disk

OS: CentOS Linux 7, Kernel: 3.10.0-229.el7.x86_64 (x86_64), Compiler: GCC 4.8.5 20150623, File-System: xfs, Screen Resolution: 1176x885, System Layer: VMware

Compiler Notes: --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

Testing initiated at 1 March 2016 17:08 by user .