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