pgbench hp dev one AMD Ryzen 7 PRO 5850U testing with a HP 8A78 (F.04 BIOS) and AMD Cezanne 512MB on Pop 22.04 via the Phoronix Test Suite. a: Processor: AMD Ryzen 7 PRO 5850U @ 4.51GHz (8 Cores / 16 Threads), Motherboard: HP 8A78 (F.04 BIOS), Chipset: AMD Renoir/Cezanne, Memory: 16GB, Disk: 1024GB SK hynix PC711 HFS001TDE9X073N, Graphics: AMD Cezanne 512MB (2000/400MHz), Audio: AMD Renoir Radeon HD Audio, Network: Realtek RTL8822CE 802.11ac PCIe OS: Pop 22.04, Kernel: 5.19.0-76051900-generic (x86_64), Desktop: GNOME Shell 42.3.1, Display Server: X Server 1.21.1.3, OpenGL: 4.6 Mesa 22.0.5 (LLVM 13.0.1 DRM 3.47), Vulkan: 1.3.204, Compiler: GCC 11.2.0, File-System: ext4, Screen Resolution: 1920x1080 b: Processor: AMD Ryzen 7 PRO 5850U @ 4.51GHz (8 Cores / 16 Threads), Motherboard: HP 8A78 (F.04 BIOS), Chipset: AMD Renoir/Cezanne, Memory: 16GB, Disk: 1024GB SK hynix PC711 HFS001TDE9X073N, Graphics: AMD Cezanne 512MB (2000/400MHz), Audio: AMD Renoir Radeon HD Audio, Network: Realtek RTL8822CE 802.11ac PCIe OS: Pop 22.04, Kernel: 5.19.0-76051900-generic (x86_64), Desktop: GNOME Shell 42.3.1, Display Server: X Server 1.21.1.3, OpenGL: 4.6 Mesa 22.0.5 (LLVM 13.0.1 DRM 3.47), Vulkan: 1.3.204, Compiler: GCC 11.2.0, File-System: ext4, Screen Resolution: 1920x1080 c: Processor: AMD Ryzen 7 PRO 5850U @ 4.51GHz (8 Cores / 16 Threads), Motherboard: HP 8A78 (F.04 BIOS), Chipset: AMD Renoir/Cezanne, Memory: 16GB, Disk: 1024GB SK hynix PC711 HFS001TDE9X073N, Graphics: AMD Cezanne 512MB (2000/400MHz), Audio: AMD Renoir Radeon HD Audio, Network: Realtek RTL8822CE 802.11ac PCIe OS: Pop 22.04, Kernel: 5.19.0-76051900-generic (x86_64), Desktop: GNOME Shell 42.3.1, Display Server: X Server 1.21.1.3, OpenGL: 4.6 Mesa 22.0.5 (LLVM 13.0.1 DRM 3.47), Vulkan: 1.3.204, Compiler: GCC 11.2.0, File-System: ext4, Screen Resolution: 1920x1080 PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write TPS > Higher Is Better a . 2188 |===================================================================== b . 572 |================== c . 505 |================ PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better a . 0.457 |================ b . 1.748 |============================================================ c . 1.979 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better a . 0.389 |====================== b . 0.390 |====================== c . 1.218 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Write TPS > Higher Is Better a . 2569 |===================================================================== b . 2565 |===================================================================== c . 821 |====================== PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Write TPS > Higher Is Better a . 28594 |==================================================================== b . 25941 |============================================================== c . 9611 |======================= PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better a . 1.749 |======================= b . 1.927 |========================= c . 5.202 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better a . 3.304 |============================ b . 3.242 |=========================== c . 8.149 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Write TPS > Higher Is Better a . 30265 |=================================================================== b . 30844 |==================================================================== c . 12272 |=========================== PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better a . 41.61 |============================= b . 41.90 |============================= c . 98.75 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Write TPS > Higher Is Better a . 2403 |===================================================================== b . 2387 |===================================================================== c . 1013 |============================= PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better a . 18.45 |============================= b . 18.51 |============================== c . 42.55 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Write TPS > Higher Is Better a . 2710 |===================================================================== b . 2701 |===================================================================== c . 1175 |============================== PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Write TPS > Higher Is Better a . 2743 |===================================================================== b . 2525 |================================================================ c . 1198 |============================== PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better a . 0.365 |============================== b . 0.396 |================================ c . 0.835 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 250 - Mode: Read Write TPS > Higher Is Better a . 24193 |================================================================== b . 24766 |==================================================================== c . 14998 |========================================= PostgreSQL 15 Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better a . 10.33 |========================================== b . 10.09 |========================================= c . 16.67 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 250 - Mode: Read Write TPS > Higher Is Better a . 1397 |============================================================== b . 1556 |===================================================================== c . 1001 |============================================ PostgreSQL 15 Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better a . 178.94 |================================================ b . 160.69 |=========================================== c . 249.67 |=================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write TPS > Higher Is Better a . 12209 |==================================================================== b . 9698 |====================================================== c . 8359 |=============================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better a . 4.095 |=============================================== b . 5.156 |=========================================================== c . 5.981 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better a . 774.63 |========================================================= b . 904.46 |=================================================================== c . 677.38 |================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Write TPS > Higher Is Better a . 645 |============================================================= b . 553 |==================================================== c . 738 |====================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better a . 26.61 |===================================================== b . 26.73 |====================================================== c . 33.93 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Write TPS > Higher Is Better a . 18792 |==================================================================== b . 18704 |==================================================================== c . 14737 |===================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.277 |======================================================= b . 0.341 |==================================================================== c . 0.294 |=========================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only TPS > Higher Is Better a . 180415 |=================================================================== b . 146682 |====================================================== c . 170053 |=============================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better a . 6.329 |======================================================== b . 6.601 |========================================================== c . 7.740 |==================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write TPS > Higher Is Better a . 15801 |==================================================================== b . 15150 |================================================================= c . 12921 |======================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write TPS > Higher Is Better a . 16345 |================================================================= b . 16996 |==================================================================== c . 14634 |=========================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better a . 15.30 |============================================================= b . 14.71 |=========================================================== c . 17.08 |==================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.074 |=========================================================== b . 0.078 |============================================================== c . 0.085 |==================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only TPS > Higher Is Better a . 13549 |==================================================================== b . 12785 |================================================================ c . 11809 |=========================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.015 |==================================================================== b . 0.014 |=============================================================== c . 0.014 |=============================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Only TPS > Higher Is Better a . 68319 |================================================================ b . 72788 |==================================================================== c . 71653 |=================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.573 |================================================================= b . 0.569 |================================================================ c . 0.604 |==================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only TPS > Higher Is Better a . 174537 |=================================================================== b . 175729 |=================================================================== c . 165594 |=============================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better a . 4.188 |================================================================ b . 4.297 |================================================================== c . 4.434 |==================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only TPS > Higher Is Better a . 119382 |=================================================================== b . 116355 |================================================================= c . 112774 |=============================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better a . 34.32 |================================================================ b . 34.78 |================================================================= c . 36.22 |==================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write TPS > Higher Is Better a . 14567 |==================================================================== b . 14375 |=================================================================== c . 13804 |================================================================ PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.239 |==================================================================== b . 0.236 |=================================================================== c . 0.228 |================================================================= PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Only TPS > Higher Is Better a . 419023 |================================================================ b . 423099 |================================================================= c . 439084 |=================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only TPS > Higher Is Better a . 146001 |=================================================================== b . 140732 |================================================================= c . 142207 |================================================================= PostgreSQL 15 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better a . 1.712 |================================================================== b . 1.776 |==================================================================== c . 1.758 |=================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 250 - Mode: Read Only TPS > Higher Is Better a . 344431 |=================================================================== b . 341186 |================================================================== c . 334241 |================================================================= PostgreSQL 15 Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.726 |================================================================== b . 0.733 |=================================================================== c . 0.748 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Only TPS > Higher Is Better a . 293789 |=================================================================== b . 289396 |================================================================== c . 286512 |================================================================= PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better a . 1.702 |================================================================== b . 1.728 |=================================================================== c . 1.745 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Only TPS > Higher Is Better a . 60168 |==================================================================== b . 60363 |==================================================================== c . 59026 |================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.659 |=================================================================== b . 0.670 |==================================================================== c . 0.672 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.254 |=================================================================== b . 0.256 |=================================================================== c . 0.259 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Only TPS > Higher Is Better a . 393983 |=================================================================== b . 391257 |=================================================================== c . 386396 |================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 250 - Mode: Read Only TPS > Higher Is Better a . 379264 |=================================================================== b . 373327 |================================================================== c . 372118 |================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.109 |=================================================================== b . 0.111 |==================================================================== c . 0.110 |=================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Only TPS > Higher Is Better a . 457888 |=================================================================== b . 450486 |================================================================== c . 455785 |=================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better a . 1.949 |=================================================================== b . 1.935 |=================================================================== c . 1.964 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Only TPS > Higher Is Better a . 256602 |=================================================================== b . 258374 |=================================================================== c . 254592 |================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.121 |==================================================================== b . 0.120 |=================================================================== c . 0.121 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Only TPS > Higher Is Better a . 413991 |=================================================================== b . 417073 |=================================================================== c . 414639 |=================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.017 |==================================================================== b . 0.017 |==================================================================== c . 0.017 |====================================================================