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