pgbench pro AMD Ryzen 7 PRO 7840U testing with a LENOVO 21K5001JUS (R2FET31W 1.11 BIOS) and AMD Phoenix1 4GB on Ubuntu 23.10 via the Phoronix Test Suite. a: Processor: AMD Ryzen 7 PRO 7840U @ 5.13GHz (8 Cores / 16 Threads), Motherboard: LENOVO 21K5001JUS (R2FET31W 1.11 BIOS), Chipset: AMD Device 14e8, Memory: 60GB, Disk: 1024GB Kioxia KXG8AZNV1T02 LA, Graphics: AMD Phoenix1 4GB (2700/800MHz), Audio: AMD Rembrandt Radeon HD Audio, Network: Realtek RTL8111/8168/8411 + Qualcomm QCNFA765 OS: Ubuntu 23.10, Kernel: 6.5.1-060501-generic (x86_64), Desktop: GNOME Shell, Display Server: X Server + Wayland, OpenGL: 4.6 Mesa 23.1.7-1ubuntu1 (LLVM 15.0.7 DRM 3.54), Compiler: GCC 13.2.0, File-System: ext4, Screen Resolution: 2880x1800 b: Processor: AMD Ryzen 7 PRO 7840U @ 5.13GHz (8 Cores / 16 Threads), Motherboard: LENOVO 21K5001JUS (R2FET31W 1.11 BIOS), Chipset: AMD Device 14e8, Memory: 60GB, Disk: 1024GB Kioxia KXG8AZNV1T02 LA, Graphics: AMD Phoenix1 4GB (2700/800MHz), Audio: AMD Rembrandt Radeon HD Audio, Network: Realtek RTL8111/8168/8411 + Qualcomm QCNFA765 OS: Ubuntu 23.10, Kernel: 6.5.1-060501-generic (x86_64), Desktop: GNOME Shell, Display Server: X Server + Wayland, OpenGL: 4.6 Mesa 23.1.7-1ubuntu1 (LLVM 15.0.7 DRM 3.54), Compiler: GCC 13.2.0, File-System: ext4, Screen Resolution: 2880x1800 c: Processor: AMD Ryzen 7 PRO 7840U @ 5.13GHz (8 Cores / 16 Threads), Motherboard: LENOVO 21K5001JUS (R2FET31W 1.11 BIOS), Chipset: AMD Device 14e8, Memory: 60GB, Disk: 1024GB Kioxia KXG8AZNV1T02 LA, Graphics: AMD Phoenix1 4GB (2700/800MHz), Audio: AMD Rembrandt Radeon HD Audio, Network: Realtek RTL8111/8168/8411 + Qualcomm QCNFA765 OS: Ubuntu 23.10, Kernel: 6.5.1-060501-generic (x86_64), Desktop: GNOME Shell, Display Server: X Server + Wayland, OpenGL: 4.6 Mesa 23.1.7-1ubuntu1 (LLVM 15.0.7 DRM 3.54), Compiler: GCC 13.2.0, File-System: ext4, Screen Resolution: 2880x1800 PostgreSQL 16 Scaling Factor: 1 - Clients: 50 - Mode: Read Only TPS > Higher Is Better a . 552132 |=================================================================== b . 554420 |=================================================================== c . 550160 |================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.091 |==================================================================== b . 0.090 |=================================================================== c . 0.091 |==================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 100 - Mode: Read Only TPS > Higher Is Better a . 547988 |=================================================================== b . 541908 |================================================================== c . 542426 |================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.182 |=================================================================== b . 0.185 |==================================================================== c . 0.184 |==================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 250 - Mode: Read Only TPS > Higher Is Better a . 527816 |=================================================================== b . 530453 |=================================================================== c . 518321 |================================================================= PostgreSQL 16 Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.474 |=================================================================== b . 0.471 |================================================================== c . 0.482 |==================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 50 - Mode: Read Write TPS > Higher Is Better a . 2659 |===================================================================== b . 2643 |===================================================================== c . 2659 |===================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better a . 18.81 |==================================================================== b . 18.92 |==================================================================== c . 18.81 |==================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 500 - Mode: Read Only TPS > Higher Is Better a . 495625 |================================================================= b . 509979 |=================================================================== c . 511103 |=================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better a . 1.009 |==================================================================== b . 0.980 |================================================================== c . 0.978 |================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 800 - Mode: Read Only TPS > Higher Is Better a . 463149 |=================================================================== b . 446851 |================================================================= c . 455374 |================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 800 - Mode: Read Only - Average Latency ms < Lower Is Better a . 1.727 |================================================================== b . 1.790 |==================================================================== c . 1.757 |=================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 100 - Mode: Read Write TPS > Higher Is Better a . 2526 |===================================================================== b . 2524 |===================================================================== c . 2500 |==================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better a . 39.59 |=================================================================== b . 39.62 |=================================================================== c . 40.01 |==================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 1000 - Mode: Read Only TPS > Higher Is Better a . 449418 |=================================================================== b . 438732 |================================================================= c . 433240 |================================================================= PostgreSQL 16 Scaling Factor: 1 - Clients: 1000 - Mode: Read Only - Average Latency ms < Lower Is Better a . 2.225 |================================================================== b . 2.279 |=================================================================== c . 2.308 |==================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 250 - Mode: Read Write TPS > Higher Is Better a . 2164 |===================================================================== b . 2121 |==================================================================== c . 2134 |==================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better a . 115.55 |================================================================== b . 117.88 |=================================================================== c . 117.13 |=================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 500 - Mode: Read Write TPS > Higher Is Better a . 1527 |=================================================================== b . 1559 |===================================================================== c . 1561 |===================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better a . 327.46 |=================================================================== b . 320.65 |================================================================== c . 320.35 |================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 800 - Mode: Read Write TPS > Higher Is Better a . 1042 |===================================================================== b . 915 |============================================================= c . 904 |============================================================ PostgreSQL 16 Scaling Factor: 1 - Clients: 800 - Mode: Read Write - Average Latency ms < Lower Is Better a . 767.82 |========================================================== b . 874.15 |================================================================== c . 885.31 |=================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 50 - Mode: Read Only TPS > Higher Is Better a . 495575 |================================================================== b . 501275 |=================================================================== c . 498274 |=================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.101 |==================================================================== b . 0.100 |=================================================================== c . 0.100 |=================================================================== PostgreSQL 16 Scaling Factor: 1 - Clients: 1000 - Mode: Read Write TPS > Higher Is Better a . 835 |====================================================================== b . 788 |================================================================== c . 764 |================================================================ PostgreSQL 16 Scaling Factor: 1 - Clients: 1000 - Mode: Read Write - Average Latency ms < Lower Is Better a . 1198.17 |============================================================ b . 1268.51 |================================================================ c . 1309.48 |================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Only TPS > Higher Is Better a . 505281 |=================================================================== b . 502379 |=================================================================== c . 505621 |=================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.198 |==================================================================== b . 0.199 |==================================================================== c . 0.198 |==================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 250 - Mode: Read Only TPS > Higher Is Better a . 489281 |=================================================================== b . 479888 |================================================================== c . 482237 |================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.511 |=================================================================== b . 0.521 |==================================================================== c . 0.518 |==================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 50 - Mode: Read Write TPS > Higher Is Better a . 31791 |==================================================================== b . 31986 |==================================================================== c . 31701 |=================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better a . 1.573 |==================================================================== b . 1.563 |=================================================================== c . 1.577 |==================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 500 - Mode: Read Only TPS > Higher Is Better a . 426381 |================================================================== b . 430644 |=================================================================== c . 428224 |=================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better a . 1.173 |==================================================================== b . 1.161 |=================================================================== c . 1.168 |==================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 800 - Mode: Read Only TPS > Higher Is Better a . 370955 |========================================================= b . 390054 |============================================================ c . 434836 |=================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 800 - Mode: Read Only - Average Latency ms < Lower Is Better a . 2.157 |==================================================================== b . 2.051 |================================================================= c . 1.840 |========================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Write TPS > Higher Is Better a . 39277 |==================================================================== b . 39225 |==================================================================== c . 38965 |=================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better a . 2.546 |=================================================================== b . 2.549 |==================================================================== c . 2.566 |==================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 1000 - Mode: Read Only TPS > Higher Is Better a . 348036 |=================================================================== b . 344834 |================================================================== c . 203191 |======================================= PostgreSQL 16 Scaling Factor: 100 - Clients: 1000 - Mode: Read Only - Average Latency ms < Lower Is Better a . 2.873 |======================================== b . 2.900 |======================================== c . 4.921 |==================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 250 - Mode: Read Write TPS > Higher Is Better a . 32150 |=================================================================== b . 32337 |=================================================================== c . 32722 |==================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better a . 7.776 |==================================================================== b . 7.731 |==================================================================== c . 7.640 |=================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 500 - Mode: Read Write TPS > Higher Is Better a . 24499 |==================================================================== b . 24562 |==================================================================== c . 24465 |==================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better a . 20.41 |==================================================================== b . 20.36 |==================================================================== c . 20.44 |==================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 800 - Mode: Read Write TPS > Higher Is Better a . 19593 |================================================================== b . 19738 |=================================================================== c . 20176 |==================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 800 - Mode: Read Write - Average Latency ms < Lower Is Better a . 40.83 |==================================================================== b . 40.53 |==================================================================== c . 39.65 |================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 1000 - Mode: Read Write TPS > Higher Is Better a . 17497 |================================================================== b . 17432 |================================================================== c . 18090 |==================================================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 1000 - Mode: Read Write - Average Latency ms < Lower Is Better a . 57.15 |==================================================================== b . 57.37 |==================================================================== c . 55.28 |==================================================================