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 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 |============================== 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 |================================ 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 |============================== 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 |============================== 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 |========================== 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 |============================== 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 |============================== 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 |======================== 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 |============================== 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 |============================== 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 |=============================== 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 |=========================== 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 |================================ 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 |=========================== 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 |============================ 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 |============================== 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 |============================== 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 |===============================