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 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 |============================ 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 |=============================== 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 |============================= 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 |============================= PostgreSQL pgbench 10.3 Scaling: On-Disk - Test: Single Thread - Mode: Read Write TPS > Higher Is Better postgres-prod-current .................... 113.19 |============================ postgres-prod-HP-noTHP-noOverC-dirty ..... 102.98 |========================= postgres-prod-HP-noTHP-noOverC-dirty-1gb . 106.39 |========================== 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 |============================= 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 |============================= 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 |======================== 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 |============================= 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 |============================= 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 |============================== 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 |=========================== 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 |=============================== 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 |=============================== 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 |============================ 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 |============================= 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 |============================== 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 |==============================