fnox-labb-test

FNOX postgres SAN testing

HTML result view exported from: https://openbenchmarking.org/result/1601202-HA-1601190HA46&grs.

fnox-labb-testProcessorMotherboardMemoryDiskOSKernelCompilerFile-SystemScreen ResolutionSystem Layerlabbdb-oldsanbenchdb-V7000testdb-V7000Intel Xeon X5450 @ 2.99GHz (1 Core)Intel 440BX1024MB16GB Virtual diskCentOS Linux 73.10.0-229.14.1.el7.x86_64 (x86_64)GCC 4.8.5 20150623xfs1176x885VMwareIntel Xeon E5-2660 0 @ 2.20GHz (4 Cores)1 x 4096 MB DRAM21GB Virtual disk + 11GB 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=generic

fnox-labb-testpgbench: Buffer Test - Heavy Contention - Read Onlypgbench: Mostly RAM - Normal Load - Read Onlypgbench: Buffer Test - Normal Load - Read Onlypgbench: On-Disk - Heavy Contention - Read Onlypgbench: Buffer Test - Single Thread - Read Onlypgbench: Mostly RAM - Single Thread - Read Onlypgbench: Buffer Test - Heavy Contention - Read Writepgbench: Mostly RAM - Heavy Contention - Read Writepgbench: Mostly RAM - Heavy Contention - Read Onlypgbench: Buffer Test - Single Thread - Read Writepgbench: On-Disk - Heavy Contention - Read Writepgbench: Mostly RAM - Single Thread - Read Writepgbench: Buffer Test - Normal Load - Read Writepgbench: Mostly RAM - Normal Load - Read Writepgbench: On-Disk - Single Thread - Read Writepgbench: On-Disk - Single Thread - Read Onlypgbench: On-Disk - Normal Load - Read Writepgbench: On-Disk - Normal Load - Read Onlylabbdb-oldsanbenchdb-V7000testdb-V70009981.859896.2811474.54338.7711759.3510189.53142.25229.797032.37152.36142.49156.38200.54230.069.229.7434.3133.9740154.6033486.1837055.8854865.828548.617790.842699.572522.9136454.93484.891654.76416.612104.641262.64220.6210474.551465.8248288.0240294.9635384.2735713.4755215.498541.018013.172485.702229.6236654.56520.251439.71439.192310.082079.23271.4610383.211465.1547389.01OpenBenchmarking.org

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 Onlylabbdb-oldsanbenchdb-V7000testdb-V70009K18K27K36K45KSE +/- 114.21, N = 3SE +/- 401.61, N = 3SE +/- 184.89, N = 39981.8540154.6040294.961. (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 Onlylabbdb-oldsanbenchdb-V7000testdb-V70008K16K24K32K40KSE +/- 10.77, N = 3SE +/- 260.57, N = 3SE +/- 209.73, N = 39896.2833486.1835384.271. (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 Onlylabbdb-oldsanbenchdb-V7000testdb-V70008K16K24K32K40KSE +/- 185.45, N = 3SE +/- 66.36, N = 3SE +/- 255.05, N = 311474.5437055.8835713.471. (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 Onlylabbdb-oldsanbenchdb-V7000testdb-V700012K24K36K48K60KSE +/- 6.49, N = 3SE +/- 303.73, N = 3SE +/- 900.00, N = 3338.7754865.8255215.491. (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 Onlylabbdb-oldsanbenchdb-V7000testdb-V70003K6K9K12K15KSE +/- 121.23, N = 3SE +/- 88.17, N = 3SE +/- 22.21, N = 311759.358548.618541.011. (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 Onlylabbdb-oldsanbenchdb-V7000testdb-V70002K4K6K8K10KSE +/- 109.93, N = 3SE +/- 47.45, N = 3SE +/- 37.83, N = 310189.537790.848013.171. (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 Writelabbdb-oldsanbenchdb-V7000testdb-V70006001200180024003000SE +/- 19.33, N = 6SE +/- 48.95, N = 3SE +/- 134.98, N = 6142.252699.572485.701. (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 Writelabbdb-oldsanbenchdb-V7000testdb-V70005001000150020002500SE +/- 12.52, N = 6SE +/- 69.14, N = 6SE +/- 160.82, N = 6229.792522.912229.621. (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 Onlylabbdb-oldsanbenchdb-V7000testdb-V70008K16K24K32K40KSE +/- 256.22, N = 6SE +/- 183.81, N = 3SE +/- 543.55, N = 57032.3736454.9336654.561. (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 Writelabbdb-oldsanbenchdb-V7000testdb-V7000110220330440550SE +/- 5.13, N = 6SE +/- 4.06, N = 3SE +/- 10.07, N = 3152.36484.89520.251. (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 Writelabbdb-oldsanbenchdb-V7000testdb-V7000400800120016002000SE +/- 2.89, N = 3SE +/- 10.58, N = 3SE +/- 291.52, N = 6142.491654.761439.711. (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 Writelabbdb-oldsanbenchdb-V7000testdb-V7000100200300400500SE +/- 6.52, N = 6SE +/- 8.20, N = 3SE +/- 6.80, N = 5156.38416.61439.191. (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 Writelabbdb-oldsanbenchdb-V7000testdb-V70005001000150020002500SE +/- 7.50, N = 6SE +/- 60.99, N = 6SE +/- 73.54, N = 6200.542104.642310.081. (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 Writelabbdb-oldsanbenchdb-V7000testdb-V7000400800120016002000SE +/- 6.41, N = 6SE +/- 67.26, N = 6SE +/- 40.02, N = 3230.061262.642079.231. (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 Writelabbdb-oldsanbenchdb-V7000testdb-V700060120180240300SE +/- 0.84, N = 3SE +/- 69.87, N = 6SE +/- 54.32, N = 69.22220.62271.461. (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 Onlylabbdb-oldsanbenchdb-V7000testdb-V70002K4K6K8K10KSE +/- 0.57, N = 3SE +/- 202.39, N = 3SE +/- 62.29, N = 39.7410474.5510383.211. (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 Writelabbdb-oldsanbenchdb-V7000testdb-V700030060090012001500SE +/- 1.99, N = 3SE +/- 294.18, N = 6SE +/- 293.62, N = 634.311465.821465.151. (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 Onlylabbdb-oldsanbenchdb-V7000testdb-V700010K20K30K40K50KSE +/- 3.81, N = 3SE +/- 400.78, N = 3SE +/- 279.29, N = 333.9748288.0247389.011. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -pthread -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

Phoronix Test Suite v10.8.4