FNOX Postgres Disk Benchmarks Virtual and Physical Appliance Disk Performance Testing 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 V7000gen2-ssd-raid1: 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 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 physical-ibm840-fc: Processor: Intel Xeon E5-2630 v3 @ 3.20GHz (16 Cores), Motherboard: LENOVO 00YJ423, Chipset: Intel Xeon E7 v3/Xeon, Memory: 1 x 16384 MB 2133MHz Hynix, Disk: 959GB ServeRAID M5210 + 2 x 2199GB FlashSystem-9840, Graphics: Matrox s G200eR2, Network: Broadcom NetXtreme BCM5719 Gigabit PCIe 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 kvm-ibm840-nocache: Processor: 16 x Intel Core (Haswell) @ 2.40GHz (16 Cores), Motherboard: Red Hat KVM, Memory: 1 x 4096 MB RAM, Disk: 50GB, Audio: QEMU ID 22 OS: CentOS Linux 7, Kernel: 3.10.0-327.el7.x86_64 (x86_64), Compiler: GCC 4.8.5 20150623, File-System: xfs, Screen Resolution: 1024x768, System Layer: KVM kvm-ibm840-writeback: Processor: 16 x Intel Core (Haswell) @ 2.40GHz (16 Cores), Motherboard: Red Hat KVM, Memory: 1 x 4096 MB RAM, Disk: 50GB, Audio: QEMU ID 22 OS: CentOS Linux 7, Kernel: 3.10.0-327.el7.x86_64 (x86_64), Compiler: GCC 4.8.5 20150623, File-System: xfs, Screen Resolution: 1024x768, System Layer: KVM kvm-ibm840-writethrough: Processor: 16 x Intel Core (Haswell) @ 2.40GHz (16 Cores), Motherboard: Red Hat KVM, Memory: 1 x 4096 MB RAM, Disk: 50GB, Audio: QEMU ID 22 OS: CentOS Linux 7, Kernel: 3.10.0-327.el7.x86_64 (x86_64), Compiler: GCC 4.8.5 20150623, File-System: xfs, Screen Resolution: 1024x768, System Layer: KVM kvm-ibm840-directsync: Processor: 16 x Intel Core (Haswell) @ 2.40GHz (16 Cores), Motherboard: Red Hat KVM, Memory: 1 x 4096 MB RAM, Disk: 50GB, Audio: QEMU ID 22 OS: CentOS Linux 7, Kernel: 3.10.0-327.el7.x86_64 (x86_64), Compiler: GCC 4.8.5 20150623, File-System: xfs, Screen Resolution: 1024x768, System Layer: KVM vmware-ssd-raid1: Processor: 2 x Intel Xeon E5-2630 v3 @ 2.40GHz (16 Cores), Motherboard: Intel 440BX, Memory: 1 x 4096 MB DRAM, Disk: 21GB Virtual disk + 107GB Virtual disk OS: CentOS Linux 7, Kernel: 3.10.0-327.el7.x86_64 (x86_64), Compiler: GCC 4.8.5 20150623, File-System: xfs, Screen Resolution: 1672x1254, System Layer: VMware vmware-ibm840-fc: Processor: 2 x Intel Xeon E5-2630 v3 @ 2.40GHz (16 Cores), Motherboard: Intel 440BX, Memory: 1 x 4096 MB DRAM, Disk: 21GB Virtual disk + 107GB Virtual disk OS: CentOS Linux 7, Kernel: 3.10.0-327.el7.x86_64 (x86_64), Compiler: GCC 4.8.5 20150623, File-System: xfs, Screen Resolution: 1672x1254, System Layer: VMware PostgreSQL pgbench 9.4.3 Scaling: On-Disk - Test: Normal Load - Mode: Read Only TPS > Higher Is Better physical-ssd-raid1 ...... 39246.77 |================================== V7000gen2-ssd-raid1 ..... 49543.77 |=========================================== V7000-hdd-raid10 ........ 47878.77 |========================================== physical-ibm840-fc ...... 39362.15 |================================== kvm-ibm840-nocache ...... 23322.77 |==================== kvm-ibm840-writeback .... 34866.24 |============================== kvm-ibm840-writethrough . 34648.35 |============================== kvm-ibm840-directsync ... 23355.79 |==================== vmware-ssd-raid1 ........ 27212.39 |======================== vmware-ibm840-fc ........ 23293.62 |==================== PostgreSQL pgbench 9.4.3 Scaling: On-Disk - Test: Normal Load - Mode: Read Write TPS > Higher Is Better physical-ssd-raid1 ...... 6363.74 |========================== V7000gen2-ssd-raid1 ..... 682.00 |=== V7000-hdd-raid10 ........ 674.91 |=== physical-ibm840-fc ...... 10659.95 |=========================================== kvm-ibm840-nocache ...... 5725.57 |======================= kvm-ibm840-writeback .... 5017.90 |==================== kvm-ibm840-writethrough . 3720.57 |=============== kvm-ibm840-directsync ... 5685.81 |======================= vmware-ssd-raid1 ........ 4887.38 |==================== vmware-ibm840-fc ........ 7353.59 |============================== PostgreSQL pgbench 9.4.3 Scaling: On-Disk - Test: Single Thread - Mode: Read Only TPS > Higher Is Better physical-ssd-raid1 ...... 2205.51 |======== V7000gen2-ssd-raid1 ..... 11100.70 |========================================== V7000-hdd-raid10 ........ 11292.74 |=========================================== physical-ibm840-fc ...... 1936.80 |======= kvm-ibm840-nocache ...... 1248.78 |===== kvm-ibm840-writeback .... 1500.62 |====== kvm-ibm840-writethrough . 1487.66 |====== kvm-ibm840-directsync ... 1233.24 |===== vmware-ssd-raid1 ........ 2473.76 |========= vmware-ibm840-fc ........ 1896.23 |======= PostgreSQL pgbench 9.4.3 Scaling: On-Disk - Test: Single Thread - Mode: Read Write TPS > Higher Is Better physical-ssd-raid1 ...... 727.78 |======================================= V7000gen2-ssd-raid1 ..... 166.31 |========= V7000-hdd-raid10 ........ 152.92 |======== physical-ibm840-fc ...... 766.33 |========================================= kvm-ibm840-nocache ...... 353.74 |=================== kvm-ibm840-writeback .... 379.60 |==================== kvm-ibm840-writethrough . 366.96 |==================== kvm-ibm840-directsync ... 352.07 |=================== vmware-ssd-raid1 ........ 835.74 |============================================= vmware-ibm840-fc ........ 632.23 |================================== PostgreSQL pgbench 9.4.3 Scaling: On-Disk - Test: Heavy Contention - Mode: Read Only TPS > Higher Is Better physical-ssd-raid1 ...... 39514.47 |============================== V7000gen2-ssd-raid1 ..... 57205.19 |=========================================== V7000-hdd-raid10 ........ 56148.00 |========================================== physical-ibm840-fc ...... 39670.72 |============================== kvm-ibm840-nocache ...... 23325.51 |================== kvm-ibm840-writeback .... 34833.13 |========================== kvm-ibm840-writethrough . 35126.86 |========================== kvm-ibm840-directsync ... 23347.93 |================== vmware-ssd-raid1 ........ 27571.75 |===================== vmware-ibm840-fc ........ 23436.94 |================== PostgreSQL pgbench 9.4.3 Scaling: On-Disk - Test: Heavy Contention - Mode: Read Write TPS > Higher Is Better physical-ssd-raid1 ...... 6781.51 |========================= V7000gen2-ssd-raid1 ..... 668.67 |== V7000-hdd-raid10 ........ 682.23 |=== physical-ibm840-fc ...... 11537.85 |=========================================== kvm-ibm840-nocache ...... 6151.47 |======================= kvm-ibm840-writeback .... 5302.10 |==================== kvm-ibm840-writethrough . 3786.94 |============== kvm-ibm840-directsync ... 6033.66 |====================== vmware-ssd-raid1 ........ 4991.64 |=================== vmware-ibm840-fc ........ 7823.91 |=============================