pgbench ryzen AMD Ryzen 9 5900HX testing with a ASUS G513QY v1.0 (G513QY.318 BIOS) and ASUS AMD Cezanne 512MB on Ubuntu 22.10 via the Phoronix Test Suite. a: Processor: AMD Ryzen 9 5900HX @ 4.89GHz (8 Cores / 16 Threads), Motherboard: ASUS G513QY v1.0 (G513QY.318 BIOS), Chipset: AMD Renoir/Cezanne, Memory: 16GB, Disk: 512GB SAMSUNG MZVLQ512HBLU-00B00, Graphics: ASUS AMD Cezanne 512MB (2500/1000MHz), Audio: AMD Navi 21/23, Monitor: LQ156M1JW25, Network: Realtek RTL8111/8168/8411 + MEDIATEK MT7921 802.11ax PCI OS: Ubuntu 22.10, Kernel: 5.19.0-26-generic (x86_64), Desktop: GNOME Shell 43.0, Display Server: X Server 1.21.1.4 + Wayland, OpenGL: 4.6 Mesa 22.2.1 (LLVM 15.0.2 DRM 3.47), Vulkan: 1.3.224, Compiler: GCC 12.2.0, File-System: ext4, Screen Resolution: 1920x1080 b: Processor: AMD Ryzen 9 5900HX @ 4.89GHz (8 Cores / 16 Threads), Motherboard: ASUS G513QY v1.0 (G513QY.318 BIOS), Chipset: AMD Renoir/Cezanne, Memory: 16GB, Disk: 512GB SAMSUNG MZVLQ512HBLU-00B00, Graphics: ASUS AMD Cezanne 512MB (2500/1000MHz), Audio: AMD Navi 21/23, Monitor: LQ156M1JW25, Network: Realtek RTL8111/8168/8411 + MEDIATEK MT7921 802.11ax PCI OS: Ubuntu 22.10, Kernel: 5.19.0-26-generic (x86_64), Desktop: GNOME Shell 43.0, Display Server: X Server 1.21.1.4 + Wayland, OpenGL: 4.6 Mesa 22.2.1 (LLVM 15.0.2 DRM 3.47), Vulkan: 1.3.224, Compiler: GCC 12.2.0, File-System: ext4, Screen Resolution: 1920x1080 c: Processor: AMD Ryzen 9 5900HX @ 4.89GHz (8 Cores / 16 Threads), Motherboard: ASUS G513QY v1.0 (G513QY.318 BIOS), Chipset: AMD Renoir/Cezanne, Memory: 16GB, Disk: 512GB SAMSUNG MZVLQ512HBLU-00B00, Graphics: ASUS AMD Cezanne 512MB (2500/1000MHz), Audio: AMD Navi 21/23, Monitor: LQ156M1JW25, Network: Realtek RTL8111/8168/8411 + MEDIATEK MT7921 802.11ax PCI OS: Ubuntu 22.10, Kernel: 5.19.0-26-generic (x86_64), Desktop: GNOME Shell 43.0, Display Server: X Server 1.21.1.4 + Wayland, OpenGL: 4.6 Mesa 22.2.1 (LLVM 15.0.2 DRM 3.47), Vulkan: 1.3.224, Compiler: GCC 12.2.0, File-System: ext4, Screen Resolution: 1920x1080 PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Only TPS > Higher Is Better a . 70659 |==================================================================== b . 70084 |=================================================================== c . 64768 |============================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.014 |=============================================================== b . 0.014 |=============================================================== c . 0.015 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Write TPS > Higher Is Better a . 1815 |===================================================================== b . 1770 |=================================================================== c . 1502 |========================================================= PostgreSQL 15 Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better a . 0.551 |======================================================== b . 0.565 |========================================================== c . 0.666 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Only TPS > Higher Is Better a . 675432 |=================================================================== b . 631133 |=============================================================== c . 646672 |================================================================ PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.074 |================================================================ b . 0.079 |==================================================================== c . 0.077 |================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Only TPS > Higher Is Better a . 651264 |=================================================================== b . 641437 |================================================================== c . 637279 |================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.154 |=================================================================== b . 0.156 |==================================================================== c . 0.157 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 250 - Mode: Read Only TPS > Higher Is Better a . 630566 |=================================================================== b . 618466 |================================================================== c . 629730 |=================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.396 |=================================================================== b . 0.404 |==================================================================== c . 0.397 |=================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Write TPS > Higher Is Better a . 1336 |===================================================================== b . 1338 |===================================================================== c . 1314 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better a . 37.43 |=================================================================== b . 37.36 |=================================================================== c . 38.05 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Only TPS > Higher Is Better a . 543819 |================================================================== b . 551696 |=================================================================== c . 536421 |================================================================= PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.919 |=================================================================== b . 0.906 |================================================================== c . 0.932 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Only TPS > Higher Is Better a . 64570 |==================================================================== b . 63666 |=================================================================== c . 63897 |=================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.015 |================================================================ b . 0.016 |==================================================================== c . 0.016 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Write TPS > Higher Is Better a . 1234 |===================================================================== b . 1234 |===================================================================== c . 1233 |===================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better a . 81.05 |==================================================================== b . 81.07 |==================================================================== c . 81.07 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 250 - Mode: Read Write TPS > Higher Is Better a . 911 |====================================================================== b . 914 |====================================================================== c . 883 |==================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better a . 274.55 |================================================================= b . 273.51 |================================================================= c . 283.04 |=================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Write TPS > Higher Is Better a . 547 |=============================================================== b . 567 |================================================================= c . 611 |====================================================================== PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better a . 914.36 |=================================================================== b . 882.30 |================================================================= c . 817.97 |============================================================ PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Write TPS > Higher Is Better a . 1354 |==================================================================== b . 1371 |===================================================================== c . 1316 |================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better a . 0.739 |================================================================== b . 0.729 |================================================================= c . 0.760 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Only TPS > Higher Is Better a . 567389 |================================================================== b . 566343 |================================================================== c . 576618 |=================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.088 |==================================================================== b . 0.088 |==================================================================== c . 0.087 |=================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only TPS > Higher Is Better a . 11626 |================================================================= b . 12203 |==================================================================== c . 11795 |================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.086 |==================================================================== b . 0.082 |================================================================= c . 0.085 |=================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Only TPS > Higher Is Better a . 611856 |=================================================================== b . 593000 |================================================================= c . 595030 |================================================================= PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.163 |================================================================== b . 0.169 |==================================================================== c . 0.168 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 250 - Mode: Read Only TPS > Higher Is Better a . 576003 |=================================================================== b . 565703 |================================================================== c . 576388 |=================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.434 |=================================================================== b . 0.442 |==================================================================== c . 0.434 |=================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Write TPS > Higher Is Better a . 13843 |=================================================================== b . 14062 |==================================================================== c . 13064 |=============================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better a . 3.612 |================================================================ b . 3.556 |=============================================================== c . 3.827 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Only TPS > Higher Is Better a . 574095 |================================================================== b . 575202 |=================================================================== c . 579050 |=================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.871 |==================================================================== b . 0.869 |==================================================================== c . 0.863 |=================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write TPS > Higher Is Better a . 276 |==================================================== b . 365 |===================================================================== c . 369 |====================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better a . 3.623 |==================================================================== b . 2.738 |=================================================== c . 2.710 |=================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only TPS > Higher Is Better a . 100956 |================================================================== b . 102511 |=================================================================== c . 102700 |=================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better a . 0.495 |==================================================================== b . 0.488 |=================================================================== c . 0.487 |=================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Write TPS > Higher Is Better a . 4775 |==================================================================== b . 4871 |===================================================================== c . 4777 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better a . 20.94 |==================================================================== b . 20.53 |=================================================================== c . 20.93 |==================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 250 - Mode: Read Write TPS > Higher Is Better a . 5654 |================================================================= b . 5607 |================================================================= c . 5960 |===================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better a . 44.22 |=================================================================== b . 44.58 |==================================================================== c . 41.94 |================================================================ PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Write TPS > Higher Is Better a . 5846 |======================================================== b . 7196 |===================================================================== c . 6997 |=================================================================== PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better a . 85.53 |==================================================================== b . 69.48 |======================================================= c . 71.46 |========================================================= PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only TPS > Higher Is Better a . 97862 |================================================================ b . 101937 |=================================================================== c . 102440 |=================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better a . 1.022 |==================================================================== b . 0.981 |================================================================= c . 0.976 |================================================================= PostgreSQL 15 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only TPS > Higher Is Better a . 87976 |==================================================================== b . 84209 |================================================================= c . 85803 |================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better a . 2.842 |================================================================= b . 2.969 |==================================================================== c . 2.914 |=================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write TPS > Higher Is Better a . 2889 |===================================================================== b . 2594 |============================================================== c . 2591 |============================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better a . 17.31 |============================================================= b . 19.28 |==================================================================== c . 19.30 |==================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only TPS > Higher Is Better a . 80853 |==================================================================== b . 72844 |============================================================= c . 79364 |=================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better a . 6.184 |============================================================= b . 6.864 |==================================================================== c . 6.300 |============================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write TPS > Higher Is Better a . 3411 |===================================================================== b . 2936 |=========================================================== c . 2903 |=========================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better a . 29.31 |========================================================== b . 34.06 |=================================================================== c . 34.44 |==================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write TPS > Higher Is Better a . 3137 |===================================================================== b . 2572 |========================================================= c . 2599 |========================================================= PostgreSQL 15 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better a . 79.69 |======================================================== b . 97.22 |==================================================================== c . 96.19 |=================================================================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write TPS > Higher Is Better a . 3131 |===================================================================== b . 2899 |================================================================ c . 2740 |============================================================ PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better a . 159.68 |=========================================================== b . 172.48 |=============================================================== c . 182.46 |===================================================================