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