postgres-testing VMware testing on CentOS Linux 7 via the Phoronix Test Suite. postgres-prod-HP-noTHP-noOverC-dirty-512m: 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-dirty-512m-sched: 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 postgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig: 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-HP-noTHP-noOverC-dirty-512m ........... 97240 |================== postgres-prod-HP-noTHP-noOverC-dirty-1gb ............ 95353 |================== postgres-prod-HP-noTHP-noOverC-dirty-256m ........... 94733 |================= postgres-prod-HP-noTHP-noOverC-dirty-512m-sched ..... 97916 |================== postgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig . 97814 |================== PostgreSQL pgbench 10.3 Scaling: On-Disk - Test: Normal Load - Mode: Read Write TPS > Higher Is Better postgres-prod-HP-noTHP-noOverC-dirty-512m ........... 958 |==================== postgres-prod-HP-noTHP-noOverC-dirty-1gb ............ 963 |==================== postgres-prod-HP-noTHP-noOverC-dirty-256m ........... 957 |==================== postgres-prod-HP-noTHP-noOverC-dirty-512m-sched ..... 957 |==================== postgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig . 924 |=================== PostgreSQL pgbench 10.3 Scaling: On-Disk - Test: Single Thread - Mode: Read Only TPS > Higher Is Better postgres-prod-HP-noTHP-noOverC-dirty-512m ........... 10971 |================== postgres-prod-HP-noTHP-noOverC-dirty-1gb ............ 10997 |================== postgres-prod-HP-noTHP-noOverC-dirty-256m ........... 10819 |================= postgres-prod-HP-noTHP-noOverC-dirty-512m-sched ..... 11177 |================== postgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig . 11204 |================== PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Normal Load - Mode: Read Only TPS > Higher Is Better postgres-prod-HP-noTHP-noOverC-dirty-512m ........... 93955 |================= postgres-prod-HP-noTHP-noOverC-dirty-1gb ............ 95616 |================= postgres-prod-HP-noTHP-noOverC-dirty-256m ........... 93299 |================= postgres-prod-HP-noTHP-noOverC-dirty-512m-sched ..... 97426 |================== postgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig . 98743 |================== PostgreSQL pgbench 10.3 Scaling: On-Disk - Test: Single Thread - Mode: Read Write TPS > Higher Is Better postgres-prod-HP-noTHP-noOverC-dirty-512m ........... 103 |=================== postgres-prod-HP-noTHP-noOverC-dirty-1gb ............ 106 |=================== postgres-prod-HP-noTHP-noOverC-dirty-256m ........... 103 |=================== postgres-prod-HP-noTHP-noOverC-dirty-512m-sched ..... 109 |==================== postgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig . 109 |==================== PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Normal Load - Mode: Read Only TPS > Higher Is Better postgres-prod-HP-noTHP-noOverC-dirty-512m ........... 75088 |================= postgres-prod-HP-noTHP-noOverC-dirty-1gb ............ 74975 |================= postgres-prod-HP-noTHP-noOverC-dirty-256m ........... 75266 |================= postgres-prod-HP-noTHP-noOverC-dirty-512m-sched ..... 76571 |================== postgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig . 77907 |================== PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Normal Load - Mode: Read Write TPS > Higher Is Better postgres-prod-HP-noTHP-noOverC-dirty-512m ........... 2080 |================== postgres-prod-HP-noTHP-noOverC-dirty-1gb ............ 2079 |================== postgres-prod-HP-noTHP-noOverC-dirty-256m ........... 1998 |================== postgres-prod-HP-noTHP-noOverC-dirty-512m-sched ..... 2153 |=================== postgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig . 2066 |================== PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Normal Load - Mode: Read Write TPS > Higher Is Better postgres-prod-HP-noTHP-noOverC-dirty-512m ........... 5185 |================ postgres-prod-HP-noTHP-noOverC-dirty-1gb ............ 4598 |============== postgres-prod-HP-noTHP-noOverC-dirty-256m ........... 4711 |=============== postgres-prod-HP-noTHP-noOverC-dirty-512m-sched ..... 6061 |=================== postgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig . 5991 |=================== PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Single Thread - Mode: Read Only TPS > Higher Is Better postgres-prod-HP-noTHP-noOverC-dirty-512m ........... 10779 |================= postgres-prod-HP-noTHP-noOverC-dirty-1gb ............ 10894 |================= postgres-prod-HP-noTHP-noOverC-dirty-256m ........... 10791 |================= postgres-prod-HP-noTHP-noOverC-dirty-512m-sched ..... 11221 |================== postgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig . 11216 |================== PostgreSQL pgbench 10.3 Scaling: On-Disk - Test: Heavy Contention - Mode: Read Only TPS > Higher Is Better postgres-prod-HP-noTHP-noOverC-dirty-512m ........... 98760 |================ postgres-prod-HP-noTHP-noOverC-dirty-1gb ............ 98275 |================ postgres-prod-HP-noTHP-noOverC-dirty-256m ........... 99530 |================ postgres-prod-HP-noTHP-noOverC-dirty-512m-sched ..... 103320 |================= postgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig . 102024 |================= PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Single Thread - Mode: Read Only TPS > Higher Is Better postgres-prod-HP-noTHP-noOverC-dirty-512m ........... 8973 |================== postgres-prod-HP-noTHP-noOverC-dirty-1gb ............ 8931 |================== postgres-prod-HP-noTHP-noOverC-dirty-256m ........... 8921 |================== postgres-prod-HP-noTHP-noOverC-dirty-512m-sched ..... 9357 |=================== postgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig . 9279 |=================== PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Single Thread - Mode: Read Write TPS > Higher Is Better postgres-prod-HP-noTHP-noOverC-dirty-512m ........... 196 |================= postgres-prod-HP-noTHP-noOverC-dirty-1gb ............ 201 |================== postgres-prod-HP-noTHP-noOverC-dirty-256m ........... 214 |=================== postgres-prod-HP-noTHP-noOverC-dirty-512m-sched ..... 227 |==================== postgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig . 223 |==================== PostgreSQL pgbench 10.3 Scaling: On-Disk - Test: Heavy Contention - Mode: Read Write TPS > Higher Is Better postgres-prod-HP-noTHP-noOverC-dirty-512m ........... 963 |==================== postgres-prod-HP-noTHP-noOverC-dirty-1gb ............ 972 |==================== postgres-prod-HP-noTHP-noOverC-dirty-256m ........... 956 |==================== postgres-prod-HP-noTHP-noOverC-dirty-512m-sched ..... 979 |==================== postgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig . 946 |=================== PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Single Thread - Mode: Read Write TPS > Higher Is Better postgres-prod-HP-noTHP-noOverC-dirty-512m ........... 392 |=============== postgres-prod-HP-noTHP-noOverC-dirty-1gb ............ 433 |================= postgres-prod-HP-noTHP-noOverC-dirty-256m ........... 386 |=============== postgres-prod-HP-noTHP-noOverC-dirty-512m-sched ..... 524 |==================== postgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig . 463 |================== PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Only TPS > Higher Is Better postgres-prod-HP-noTHP-noOverC-dirty-512m ........... 97763 |================ postgres-prod-HP-noTHP-noOverC-dirty-1gb ............ 100031 |================ postgres-prod-HP-noTHP-noOverC-dirty-256m ........... 99521 |================ postgres-prod-HP-noTHP-noOverC-dirty-512m-sched ..... 103520 |================= postgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig . 101899 |================= PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Only TPS > Higher Is Better postgres-prod-HP-noTHP-noOverC-dirty-512m ........... 79511 |================= postgres-prod-HP-noTHP-noOverC-dirty-1gb ............ 80058 |================= postgres-prod-HP-noTHP-noOverC-dirty-256m ........... 80919 |================== postgres-prod-HP-noTHP-noOverC-dirty-512m-sched ..... 82857 |================== postgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig . 81293 |================== PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Write TPS > Higher Is Better postgres-prod-HP-noTHP-noOverC-dirty-512m ........... 2161 |=================== postgres-prod-HP-noTHP-noOverC-dirty-1gb ............ 2213 |=================== postgres-prod-HP-noTHP-noOverC-dirty-256m ........... 2202 |=================== postgres-prod-HP-noTHP-noOverC-dirty-512m-sched ..... 2206 |=================== postgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig . 2139 |================== PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Write TPS > Higher Is Better postgres-prod-HP-noTHP-noOverC-dirty-512m ........... 6853 |================ postgres-prod-HP-noTHP-noOverC-dirty-1gb ............ 7544 |================= postgres-prod-HP-noTHP-noOverC-dirty-256m ........... 6746 |================ postgres-prod-HP-noTHP-noOverC-dirty-512m-sched ..... 8266 |=================== postgres-prod-HP-noTHP-noOverC-dirty-512m-sched-mig . 6875 |================