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 postgres-prod-HP-noTHP-noOverC-noDirty: 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 |=========================== postgres-prod-HP-noTHP-noOverC-noDirty .... 93576 |=========================== 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 |============================== postgres-prod-HP-noTHP-noOverC-noDirty .... 955 |============================== 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 |============================ postgres-prod-HP-noTHP-noOverC-noDirty .... 10736 |=========================== 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 |=========================== postgres-prod-HP-noTHP-noOverC-noDirty .... 95226 |============================ 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 |=========================== postgres-prod-HP-noTHP-noOverC-noDirty .... 111 |============================= 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 |============================ postgres-prod-HP-noTHP-noOverC-noDirty .... 75474 |============================ 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 |=========================== postgres-prod-HP-noTHP-noOverC-noDirty .... 2129 |============================= 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 |====================== postgres-prod-HP-noTHP-noOverC-noDirty .... 6339 |============================= 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 |=========================== postgres-prod-HP-noTHP-noOverC-noDirty .... 11036 |============================ 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 |=========================== postgres-prod-HP-noTHP-noOverC-noDirty .... 100119 |=========================== 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 |============================= postgres-prod-HP-noTHP-noOverC-noDirty .... 8972 |============================= 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 |============================ postgres-prod-HP-noTHP-noOverC-noDirty .... 227 |============================= 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 |============================== postgres-prod-HP-noTHP-noOverC-noDirty .... 961 |============================== 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 |====================== postgres-prod-HP-noTHP-noOverC-noDirty .... 525 |============================== 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 |=========================== postgres-prod-HP-noTHP-noOverC-noDirty .... 99366 |=========================== 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 |============================ postgres-prod-HP-noTHP-noOverC-noDirty .... 80127 |============================ 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 |============================ postgres-prod-HP-noTHP-noOverC-noDirty .... 2258 |============================= 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 |========================= postgres-prod-HP-noTHP-noOverC-noDirty .... 7881 |=============================