20240702pgbench 2 x Intel Xeon 6740E testing with a Quanta Cloud QuantaGrid D55Q-2U S7Q-MB-MPS-MDP (2A07.QCT001 BIOS) and ASPEED on CentOS Stream 9 via the Phoronix Test Suite. run0: Processor: 2 x Intel Xeon 6740E @ 3.20GHz (192 Cores), Motherboard: Quanta Cloud QuantaGrid D55Q-2U S7Q-MB-MPS-MDP (2A07.QCT001 BIOS), Chipset: Intel Ice Lake IEH, Memory: 1008GB, Disk: 3841GB SAMSUNG MZQL23T8HCLS-00A07, Graphics: ASPEED, Network: 2 x Broadcom BCM57416 NetXtreme-E Dual-Media 10G RDMA + 2 x Mellanox MT2892 OS: CentOS Stream 9, Kernel: 6.6.0-srf.bkc.6.6.22.2.21.x86_64 (x86_64), Compiler: GCC 11.4.1 20231218, File-System: ext4, Screen Resolution: 1920x1200 run1: Processor: 2 x Intel Xeon 6740E @ 3.20GHz (192 Cores), Motherboard: Quanta Cloud QuantaGrid D55Q-2U S7Q-MB-MPS-MDP (2A07.QCT001 BIOS), Chipset: Intel Ice Lake IEH, Memory: 1008GB, Disk: 3841GB SAMSUNG MZQL23T8HCLS-00A07, Graphics: ASPEED, Network: 2 x Broadcom BCM57416 NetXtreme-E Dual-Media 10G RDMA + 2 x Mellanox MT2892 OS: CentOS Stream 9, Kernel: 6.6.0-srf.bkc.6.6.22.2.21.x86_64 (x86_64), Compiler: GCC 11.4.1 20231218, File-System: ext4, Screen Resolution: 1920x1200 PostgreSQL 16 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better run1 . 15.80 |================================================================= PostgreSQL 16 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write TPS > Higher Is Better run1 . 31648 |================================================================= PostgreSQL 16 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better run1 . 7.025 |================================================================= PostgreSQL 16 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write TPS > Higher Is Better run1 . 35591 |================================================================= PostgreSQL 16 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only - Average Latency ms < Lower Is Better run1 . 1.100 |================================================================= PostgreSQL 16 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only TPS > Higher Is Better run1 . 910263 |================================================================ PostgreSQL 16 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better run1 . 2.397 |================================================================= PostgreSQL 16 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write TPS > Higher Is Better run1 . 41735 |================================================================= PostgreSQL 16 Scaling Factor: 100 - Clients: 1000 - Mode: Read Write - Average Latency ms < Lower Is Better run1 . 18.41 |================================================================= PostgreSQL 16 Scaling Factor: 100 - Clients: 1000 - Mode: Read Write TPS > Higher Is Better run1 . 54310 |================================================================= PostgreSQL 16 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better run1 . 0.486 |================================================================= PostgreSQL 16 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only TPS > Higher Is Better run1 . 1031135 |=============================================================== PostgreSQL 16 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better run1 . 0.223 |================================================================= PostgreSQL 16 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only TPS > Higher Is Better run1 . 1119934 |=============================================================== PostgreSQL 16 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better run1 . 0.083 |================================================================= PostgreSQL 16 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only TPS > Higher Is Better run1 . 1200595 |=============================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better run1 . 12.36 |================================================================= PostgreSQL 16 Scaling Factor: 100 - Clients: 500 - Mode: Read Write TPS > Higher Is Better run1 . 40532 |================================================================= PostgreSQL 16 Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better run1 . 5.873 |================================================================= PostgreSQL 16 Scaling Factor: 100 - Clients: 250 - Mode: Read Write TPS > Higher Is Better run1 . 42568 |================================================================= PostgreSQL 16 Scaling Factor: 100 - Clients: 1000 - Mode: Read Only - Average Latency ms < Lower Is Better run1 . 0.725 |================================================================= PostgreSQL 16 Scaling Factor: 100 - Clients: 1000 - Mode: Read Only TPS > Higher Is Better run1 . 1379142 |=============================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better run1 . 2.117 |================================================================= PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Write TPS > Higher Is Better run1 . 47252 |================================================================= PostgreSQL 16 Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better run1 . 0.368 |================================================================= PostgreSQL 16 Scaling Factor: 100 - Clients: 500 - Mode: Read Only TPS > Higher Is Better run1 . 1359048 |=============================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better run1 . 0.179 |================================================================= PostgreSQL 16 Scaling Factor: 100 - Clients: 250 - Mode: Read Only TPS > Higher Is Better run1 . 1395827 |=============================================================== PostgreSQL 16 Scaling Factor: 10000 - Clients: 100 - Mode: Read Write TPS > Higher Is Better PostgreSQL 16 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write TPS > Higher Is Better PostgreSQL 16 Scaling Factor: 10000 - Clients: 500 - Mode: Read Only TPS > Higher Is Better PostgreSQL 16 Scaling Factor: 10000 - Clients: 250 - Mode: Read Only TPS > Higher Is Better PostgreSQL 16 Scaling Factor: 10000 - Clients: 100 - Mode: Read Only TPS > Higher Is Better PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better run1 . 0.101 |================================================================= PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Only TPS > Higher Is Better run1 . 1102286 |===============================================================