postgres-testing VMware testing on CentOS Linux 7 via the Phoronix Test Suite. 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 postgres-prod-HP-noTHP-noOverC-dirty-256m: 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-noDirty: 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-noMiti: 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 + 64GB 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-prod-current ....................... 94739 |========================= postgres-prod-HP-noTHP-noOverC-dirty ........ 97240 |========================= postgres-prod-HP-noTHP-noOverC-dirty-1gb .... 95353 |========================= postgres-prod-HP-noTHP-noOverC-dirty-256m ... 94733 |========================= postgres-prod-HP-noTHP-noOverC-noDirty ...... 93576 |======================== postgres-prod-HP-noTHP-noOverC-dirty-noMiti . 99431 |========================== PostgreSQL pgbench 10.3 Scaling: On-Disk - Test: Normal Load - Mode: Read Write TPS > Higher Is Better postgres-prod-current ....................... 971 |============================ postgres-prod-HP-noTHP-noOverC-dirty ........ 958 |============================ postgres-prod-HP-noTHP-noOverC-dirty-1gb .... 963 |============================ postgres-prod-HP-noTHP-noOverC-dirty-256m ... 957 |============================ postgres-prod-HP-noTHP-noOverC-noDirty ...... 955 |============================ postgres-prod-HP-noTHP-noOverC-dirty-noMiti . 965 |============================ PostgreSQL pgbench 10.3 Scaling: On-Disk - Test: Single Thread - Mode: Read Only TPS > Higher Is Better postgres-prod-current ....................... 10900 |========================= postgres-prod-HP-noTHP-noOverC-dirty ........ 10971 |========================= postgres-prod-HP-noTHP-noOverC-dirty-1gb .... 10997 |========================= postgres-prod-HP-noTHP-noOverC-dirty-256m ... 10819 |========================= postgres-prod-HP-noTHP-noOverC-noDirty ...... 10736 |========================= postgres-prod-HP-noTHP-noOverC-dirty-noMiti . 11271 |========================== PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Normal Load - Mode: Read Only TPS > Higher Is Better postgres-prod-current ....................... 94835 |========================= postgres-prod-HP-noTHP-noOverC-dirty ........ 93955 |========================= postgres-prod-HP-noTHP-noOverC-dirty-1gb .... 95616 |========================== postgres-prod-HP-noTHP-noOverC-dirty-256m ... 93299 |========================= postgres-prod-HP-noTHP-noOverC-noDirty ...... 95226 |========================= postgres-prod-HP-noTHP-noOverC-dirty-noMiti . 97224 |========================== PostgreSQL pgbench 10.3 Scaling: On-Disk - Test: Single Thread - Mode: Read Write TPS > Higher Is Better postgres-prod-current ....................... 113 |============================ postgres-prod-HP-noTHP-noOverC-dirty ........ 103 |========================== postgres-prod-HP-noTHP-noOverC-dirty-1gb .... 106 |========================== postgres-prod-HP-noTHP-noOverC-dirty-256m ... 103 |========================== postgres-prod-HP-noTHP-noOverC-noDirty ...... 111 |============================ postgres-prod-HP-noTHP-noOverC-dirty-noMiti . 101 |========================= PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Normal Load - Mode: Read Only TPS > Higher Is Better postgres-prod-current ....................... 70514 |======================== postgres-prod-HP-noTHP-noOverC-dirty ........ 75088 |========================== postgres-prod-HP-noTHP-noOverC-dirty-1gb .... 74975 |========================= postgres-prod-HP-noTHP-noOverC-dirty-256m ... 75266 |========================== postgres-prod-HP-noTHP-noOverC-noDirty ...... 75474 |========================== postgres-prod-HP-noTHP-noOverC-dirty-noMiti . 76556 |========================== PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Normal Load - Mode: Read Write TPS > Higher Is Better postgres-prod-current ....................... 2118 |=========================== postgres-prod-HP-noTHP-noOverC-dirty ........ 2080 |========================== postgres-prod-HP-noTHP-noOverC-dirty-1gb .... 2079 |========================== postgres-prod-HP-noTHP-noOverC-dirty-256m ... 1998 |========================= postgres-prod-HP-noTHP-noOverC-noDirty ...... 2129 |=========================== postgres-prod-HP-noTHP-noOverC-dirty-noMiti . 2052 |========================== PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Normal Load - Mode: Read Write TPS > Higher Is Better postgres-prod-current ....................... 5658 |======================== postgres-prod-HP-noTHP-noOverC-dirty ........ 5185 |====================== postgres-prod-HP-noTHP-noOverC-dirty-1gb .... 4598 |==================== postgres-prod-HP-noTHP-noOverC-dirty-256m ... 4711 |==================== postgres-prod-HP-noTHP-noOverC-noDirty ...... 6339 |=========================== postgres-prod-HP-noTHP-noOverC-dirty-noMiti . 4863 |===================== PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Single Thread - Mode: Read Only TPS > Higher Is Better postgres-prod-current ....................... 10851 |========================= postgres-prod-HP-noTHP-noOverC-dirty ........ 10779 |========================= postgres-prod-HP-noTHP-noOverC-dirty-1gb .... 10894 |========================== postgres-prod-HP-noTHP-noOverC-dirty-256m ... 10791 |========================= postgres-prod-HP-noTHP-noOverC-noDirty ...... 11036 |========================== postgres-prod-HP-noTHP-noOverC-dirty-noMiti . 11092 |========================== PostgreSQL pgbench 10.3 Scaling: On-Disk - Test: Heavy Contention - Mode: Read Only TPS > Higher Is Better postgres-prod-current ....................... 99885 |======================== postgres-prod-HP-noTHP-noOverC-dirty ........ 98760 |======================== postgres-prod-HP-noTHP-noOverC-dirty-1gb .... 98275 |======================== postgres-prod-HP-noTHP-noOverC-dirty-256m ... 99530 |======================== postgres-prod-HP-noTHP-noOverC-noDirty ...... 100119 |======================== postgres-prod-HP-noTHP-noOverC-dirty-noMiti . 102492 |========================= PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Single Thread - Mode: Read Only TPS > Higher Is Better postgres-prod-current ....................... 8915 |========================== postgres-prod-HP-noTHP-noOverC-dirty ........ 8973 |========================== postgres-prod-HP-noTHP-noOverC-dirty-1gb .... 8931 |========================== postgres-prod-HP-noTHP-noOverC-dirty-256m ... 8921 |========================== postgres-prod-HP-noTHP-noOverC-noDirty ...... 8972 |========================== postgres-prod-HP-noTHP-noOverC-dirty-noMiti . 9200 |=========================== PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Single Thread - Mode: Read Write TPS > Higher Is Better postgres-prod-current ....................... 232 |============================ postgres-prod-HP-noTHP-noOverC-dirty ........ 196 |======================== postgres-prod-HP-noTHP-noOverC-dirty-1gb .... 201 |======================== postgres-prod-HP-noTHP-noOverC-dirty-256m ... 214 |========================== postgres-prod-HP-noTHP-noOverC-noDirty ...... 227 |=========================== postgres-prod-HP-noTHP-noOverC-dirty-noMiti . 214 |========================== PostgreSQL pgbench 10.3 Scaling: On-Disk - Test: Heavy Contention - Mode: Read Write TPS > Higher Is Better postgres-prod-current ....................... 966 |============================ postgres-prod-HP-noTHP-noOverC-dirty ........ 963 |============================ postgres-prod-HP-noTHP-noOverC-dirty-1gb .... 972 |============================ postgres-prod-HP-noTHP-noOverC-dirty-256m ... 956 |============================ postgres-prod-HP-noTHP-noOverC-noDirty ...... 961 |============================ postgres-prod-HP-noTHP-noOverC-dirty-noMiti . 955 |============================ PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Single Thread - Mode: Read Write TPS > Higher Is Better postgres-prod-current ....................... 432 |======================= postgres-prod-HP-noTHP-noOverC-dirty ........ 392 |===================== postgres-prod-HP-noTHP-noOverC-dirty-1gb .... 433 |======================= postgres-prod-HP-noTHP-noOverC-dirty-256m ... 386 |===================== postgres-prod-HP-noTHP-noOverC-noDirty ...... 525 |============================ postgres-prod-HP-noTHP-noOverC-dirty-noMiti . 425 |======================= PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Only TPS > Higher Is Better postgres-prod-current ....................... 100587 |========================= postgres-prod-HP-noTHP-noOverC-dirty ........ 97763 |======================== postgres-prod-HP-noTHP-noOverC-dirty-1gb .... 100031 |========================= postgres-prod-HP-noTHP-noOverC-dirty-256m ... 99521 |========================= postgres-prod-HP-noTHP-noOverC-noDirty ...... 99366 |========================= postgres-prod-HP-noTHP-noOverC-dirty-noMiti . 100740 |========================= PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Only TPS > Higher Is Better postgres-prod-current ....................... 74040 |======================== postgres-prod-HP-noTHP-noOverC-dirty ........ 79511 |========================== postgres-prod-HP-noTHP-noOverC-dirty-1gb .... 80058 |========================== postgres-prod-HP-noTHP-noOverC-dirty-256m ... 80919 |========================== postgres-prod-HP-noTHP-noOverC-noDirty ...... 80127 |========================== postgres-prod-HP-noTHP-noOverC-dirty-noMiti . 79978 |========================== PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Write TPS > Higher Is Better postgres-prod-current ....................... 2218 |=========================== postgres-prod-HP-noTHP-noOverC-dirty ........ 2161 |========================== postgres-prod-HP-noTHP-noOverC-dirty-1gb .... 2213 |========================== postgres-prod-HP-noTHP-noOverC-dirty-256m ... 2202 |========================== postgres-prod-HP-noTHP-noOverC-noDirty ...... 2258 |=========================== postgres-prod-HP-noTHP-noOverC-dirty-noMiti . 2205 |========================== PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Write TPS > Higher Is Better postgres-prod-current ....................... 6773 |======================= postgres-prod-HP-noTHP-noOverC-dirty ........ 6853 |======================= postgres-prod-HP-noTHP-noOverC-dirty-1gb .... 7544 |========================== postgres-prod-HP-noTHP-noOverC-dirty-256m ... 6746 |======================= postgres-prod-HP-noTHP-noOverC-noDirty ...... 7881 |=========================== postgres-prod-HP-noTHP-noOverC-dirty-noMiti . 7113 |========================