postgres-testing VMware testing on CentOS Linux 7 via the Phoronix Test Suite. postgres-current: Processor: Common KVM (8 Cores), Motherboard: QEMU Standard PC (i440FX + PIIX 1996) (rel-1.11.0-0-g63451fca13-prebuilt.qemu-project.org BIOS), Memory: 1 x 16384 MB RAM QEMU, Disk: 21GB QEMU HDD + 27GB QEMU HDD, Graphics: bochsdrmfb OS: CentOS Linux 7, Kernel: 3.10.0-957.21.2.el7.x86_64 (x86_64), Compiler: GCC 4.8.5 20150623, File-System: xfs, Screen Resolution: 1024x768, System Layer: KVM postgres-hugepages: Processor: Common KVM (8 Cores), Motherboard: QEMU Standard PC (i440FX + PIIX 1996) (rel-1.11.0-0-g63451fca13-prebuilt.qemu-project.org BIOS), Memory: 1 x 16384 MB RAM QEMU, Disk: 21GB QEMU HDD + 27GB QEMU HDD, Graphics: bochsdrmfb OS: CentOS Linux 7, Kernel: 3.10.0-957.21.2.el7.x86_64 (x86_64), Compiler: GCC 4.8.5 20150623, File-System: xfs, Screen Resolution: 1024x768, System Layer: KVM postgres-hugepages-noTHP-noCommit: Processor: Common KVM (8 Cores), Motherboard: QEMU Standard PC (i440FX + PIIX 1996) (rel-1.11.0-0-g63451fca13-prebuilt.qemu-project.org BIOS), Memory: 1 x 16384 MB RAM QEMU, Disk: 21GB QEMU HDD + 27GB QEMU HDD, Graphics: bochsdrmfb OS: CentOS Linux 7, Kernel: 3.10.0-957.21.2.el7.x86_64 (x86_64), Compiler: GCC 4.8.5 20150623, File-System: xfs, Screen Resolution: 1024x768, System Layer: KVM postgres-hugepages-noTHP-noCommit-dirty: Processor: Common KVM (8 Cores), Motherboard: QEMU Standard PC (i440FX + PIIX 1996) (rel-1.11.0-0-g63451fca13-prebuilt.qemu-project.org BIOS), Memory: 1 x 16384 MB RAM QEMU, Disk: 21GB QEMU HDD + 27GB QEMU HDD, Graphics: bochsdrmfb OS: CentOS Linux 7, Kernel: 3.10.0-957.21.2.el7.x86_64 (x86_64), Compiler: GCC 4.8.5 20150623, File-System: xfs, Screen Resolution: 1024x768, System Layer: KVM postgres-prod-current: Processor: 4 x Intel Xeon E5-2697 v4 (8 Cores), Motherboard: Intel 440BX (6.00 BIOS), Chipset: Intel 440BX/ZX/DX, Memory: 1 x 16384 MB DRAM, Disk: 16GB Virtual disk + 54GB Virtual disk + 11GB Virtual disk, Graphics: VMware SVGA II, Network: VMware VMXNET3 OS: CentOS Linux 7, Kernel: 3.10.0-957.21.3.el7.x86_64 (x86_64), Compiler: GCC 4.8.5 20150623, File-System: xfs, Screen Resolution: 1176x885, System Layer: VMware postgres-prod-HP-noTHP-noOverC-dirty: Processor: 4 x Intel Xeon E5-2697 v4 (8 Cores), Motherboard: Intel 440BX (6.00 BIOS), Chipset: Intel 440BX/ZX/DX, Memory: 1 x 16384 MB DRAM, Disk: 16GB Virtual disk + 54GB Virtual disk + 11GB Virtual disk, Graphics: VMware SVGA II, Network: VMware VMXNET3 OS: CentOS Linux 7, Kernel: 3.10.0-957.21.3.el7.x86_64 (x86_64), Compiler: GCC 4.8.5 20150623, File-System: xfs, Screen Resolution: 1176x885, System Layer: VMware postgres-prod-HP-noTHP-noOverC-dirty-1gb: Processor: 4 x Intel Xeon E5-2697 v4 (8 Cores), Motherboard: Intel 440BX (6.00 BIOS), Chipset: Intel 440BX/ZX/DX, Memory: 1 x 16384 MB DRAM, Disk: 16GB Virtual disk + 54GB Virtual disk + 11GB Virtual disk, Graphics: VMware SVGA II, Network: VMware VMXNET3 OS: CentOS Linux 7, Kernel: 3.10.0-957.21.3.el7.x86_64 (x86_64), Compiler: GCC 4.8.5 20150623, File-System: xfs, Screen Resolution: 1176x885, System Layer: VMware PostgreSQL pgbench 10.3 Scaling: On-Disk - Test: Normal Load - Mode: Read Only TPS > Higher Is Better postgres-current ......................... 64052 |=================== postgres-hugepages ....................... 65105 |=================== postgres-hugepages-noTHP-noCommit ........ 65928 |==================== postgres-hugepages-noTHP-noCommit-dirty .. 65349 |=================== postgres-prod-current .................... 94739 |============================ postgres-prod-HP-noTHP-noOverC-dirty ..... 97240 |============================= postgres-prod-HP-noTHP-noOverC-dirty-1gb . 95353 |============================ PostgreSQL pgbench 10.3 Scaling: On-Disk - Test: Normal Load - Mode: Read Write TPS > Higher Is Better postgres-current ......................... 798 |========================= postgres-hugepages ....................... 811 |========================== postgres-hugepages-noTHP-noCommit ........ 809 |========================== postgres-hugepages-noTHP-noCommit-dirty .. 800 |========================== postgres-prod-current .................... 971 |=============================== postgres-prod-HP-noTHP-noOverC-dirty ..... 958 |=============================== postgres-prod-HP-noTHP-noOverC-dirty-1gb . 963 |=============================== PostgreSQL pgbench 10.3 Scaling: On-Disk - Test: Single Thread - Mode: Read Only TPS > Higher Is Better postgres-current ......................... 7182 |=================== postgres-hugepages ....................... 6956 |================== postgres-hugepages-noTHP-noCommit ........ 7366 |=================== postgres-hugepages-noTHP-noCommit-dirty .. 7420 |==================== postgres-prod-current .................... 10900 |============================= postgres-prod-HP-noTHP-noOverC-dirty ..... 10971 |============================= postgres-prod-HP-noTHP-noOverC-dirty-1gb . 10997 |============================= PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Normal Load - Mode: Read Only TPS > Higher Is Better postgres-current ......................... 64696 |==================== postgres-hugepages ....................... 66100 |==================== postgres-hugepages-noTHP-noCommit ........ 64558 |==================== postgres-hugepages-noTHP-noCommit-dirty .. 66189 |==================== postgres-prod-current .................... 94835 |============================= postgres-prod-HP-noTHP-noOverC-dirty ..... 93955 |============================ postgres-prod-HP-noTHP-noOverC-dirty-1gb . 95616 |============================= PostgreSQL pgbench 10.3 Scaling: On-Disk - Test: Single Thread - Mode: Read Write TPS > Higher Is Better postgres-current ......................... 97.20 |======================== postgres-hugepages ....................... 98.28 |======================== postgres-hugepages-noTHP-noCommit ........ 98.23 |======================== postgres-hugepages-noTHP-noCommit-dirty .. 97.12 |======================== postgres-prod-current .................... 113.19 |============================ postgres-prod-HP-noTHP-noOverC-dirty ..... 102.98 |========================= postgres-prod-HP-noTHP-noOverC-dirty-1gb . 106.39 |========================== PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Normal Load - Mode: Read Only TPS > Higher Is Better postgres-current ......................... 49979 |=================== postgres-hugepages ....................... 55115 |===================== postgres-hugepages-noTHP-noCommit ........ 55029 |===================== postgres-hugepages-noTHP-noCommit-dirty .. 55165 |===================== postgres-prod-current .................... 70514 |=========================== postgres-prod-HP-noTHP-noOverC-dirty ..... 75088 |============================= postgres-prod-HP-noTHP-noOverC-dirty-1gb . 74975 |============================= PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Normal Load - Mode: Read Write TPS > Higher Is Better postgres-current ......................... 1867 |========================== postgres-hugepages ....................... 1892 |=========================== postgres-hugepages-noTHP-noCommit ........ 1883 |=========================== postgres-hugepages-noTHP-noCommit-dirty .. 1874 |=========================== postgres-prod-current .................... 2118 |============================== postgres-prod-HP-noTHP-noOverC-dirty ..... 2080 |============================= postgres-prod-HP-noTHP-noOverC-dirty-1gb . 2079 |============================= PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Normal Load - Mode: Read Write TPS > Higher Is Better postgres-current ......................... 5817 |=========================== postgres-hugepages ....................... 5977 |=========================== postgres-hugepages-noTHP-noCommit ........ 5979 |=========================== postgres-hugepages-noTHP-noCommit-dirty .. 6564 |============================== postgres-prod-current .................... 5658 |========================== postgres-prod-HP-noTHP-noOverC-dirty ..... 5185 |======================== postgres-prod-HP-noTHP-noOverC-dirty-1gb . 4598 |===================== PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Single Thread - Mode: Read Only TPS > Higher Is Better postgres-current ......................... 7386 |==================== postgres-hugepages ....................... 6962 |=================== postgres-hugepages-noTHP-noCommit ........ 7378 |==================== postgres-hugepages-noTHP-noCommit-dirty .. 7559 |==================== postgres-prod-current .................... 10851 |============================= postgres-prod-HP-noTHP-noOverC-dirty ..... 10779 |============================= postgres-prod-HP-noTHP-noOverC-dirty-1gb . 10894 |============================= PostgreSQL pgbench 10.3 Scaling: On-Disk - Test: Heavy Contention - Mode: Read Only TPS > Higher Is Better postgres-current ......................... 68014 |==================== postgres-hugepages ....................... 69944 |==================== postgres-hugepages-noTHP-noCommit ........ 69550 |==================== postgres-hugepages-noTHP-noCommit-dirty .. 68713 |==================== postgres-prod-current .................... 99885 |============================= postgres-prod-HP-noTHP-noOverC-dirty ..... 98760 |============================= postgres-prod-HP-noTHP-noOverC-dirty-1gb . 98275 |============================= PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Single Thread - Mode: Read Only TPS > Higher Is Better postgres-current ......................... 6053 |==================== postgres-hugepages ....................... 6442 |====================== postgres-hugepages-noTHP-noCommit ........ 6505 |====================== postgres-hugepages-noTHP-noCommit-dirty .. 6421 |===================== postgres-prod-current .................... 8915 |============================== postgres-prod-HP-noTHP-noOverC-dirty ..... 8973 |============================== postgres-prod-HP-noTHP-noOverC-dirty-1gb . 8931 |============================== PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Single Thread - Mode: Read Write TPS > Higher Is Better postgres-current ......................... 201 |=========================== postgres-hugepages ....................... 203 |=========================== postgres-hugepages-noTHP-noCommit ........ 203 |=========================== postgres-hugepages-noTHP-noCommit-dirty .. 202 |=========================== postgres-prod-current .................... 232 |=============================== postgres-prod-HP-noTHP-noOverC-dirty ..... 196 |========================== postgres-prod-HP-noTHP-noOverC-dirty-1gb . 201 |=========================== PostgreSQL pgbench 10.3 Scaling: On-Disk - Test: Heavy Contention - Mode: Read Write TPS > Higher Is Better postgres-current ......................... 797 |========================= postgres-hugepages ....................... 814 |========================== postgres-hugepages-noTHP-noCommit ........ 818 |========================== postgres-hugepages-noTHP-noCommit-dirty .. 811 |========================== postgres-prod-current .................... 966 |=============================== postgres-prod-HP-noTHP-noOverC-dirty ..... 963 |=============================== postgres-prod-HP-noTHP-noOverC-dirty-1gb . 972 |=============================== PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Single Thread - Mode: Read Write TPS > Higher Is Better postgres-current ......................... 404 |=========================== postgres-hugepages ....................... 420 |============================ postgres-hugepages-noTHP-noCommit ........ 413 |============================ postgres-hugepages-noTHP-noCommit-dirty .. 457 |=============================== postgres-prod-current .................... 432 |============================= postgres-prod-HP-noTHP-noOverC-dirty ..... 392 |=========================== postgres-prod-HP-noTHP-noOverC-dirty-1gb . 433 |============================= PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Only TPS > Higher Is Better postgres-current ......................... 69094 |=================== postgres-hugepages ....................... 69866 |=================== postgres-hugepages-noTHP-noCommit ........ 70376 |==================== postgres-hugepages-noTHP-noCommit-dirty .. 70991 |==================== postgres-prod-current .................... 100587 |============================ postgres-prod-HP-noTHP-noOverC-dirty ..... 97763 |=========================== postgres-prod-HP-noTHP-noOverC-dirty-1gb . 100031 |============================ PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Only TPS > Higher Is Better postgres-current ......................... 50680 |================== postgres-hugepages ....................... 58217 |===================== postgres-hugepages-noTHP-noCommit ........ 59392 |====================== postgres-hugepages-noTHP-noCommit-dirty .. 58258 |===================== postgres-prod-current .................... 74040 |=========================== postgres-prod-HP-noTHP-noOverC-dirty ..... 79511 |============================= postgres-prod-HP-noTHP-noOverC-dirty-1gb . 80058 |============================= PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Write TPS > Higher Is Better postgres-current ......................... 1796 |======================== postgres-hugepages ....................... 1803 |======================== postgres-hugepages-noTHP-noCommit ........ 1804 |======================== postgres-hugepages-noTHP-noCommit-dirty .. 1831 |========================= postgres-prod-current .................... 2218 |============================== postgres-prod-HP-noTHP-noOverC-dirty ..... 2161 |============================= postgres-prod-HP-noTHP-noOverC-dirty-1gb . 2213 |============================== PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Write TPS > Higher Is Better postgres-current ......................... 5952 |======================== postgres-hugepages ....................... 6213 |========================= postgres-hugepages-noTHP-noCommit ........ 6210 |========================= postgres-hugepages-noTHP-noCommit-dirty .. 6947 |============================ postgres-prod-current .................... 6773 |=========================== postgres-prod-HP-noTHP-noOverC-dirty ..... 6853 |=========================== postgres-prod-HP-noTHP-noOverC-dirty-1gb . 7544 |==============================