pgbench-5900hx AMD Ryzen 9 5900HX testing with a ASUS G513QY v1.0 (G513QY.311 BIOS) and ASUS AMD Cezanne 512MB on Ubuntu 21.10 via the Phoronix Test Suite. 1: Processor: AMD Ryzen 9 5900HX @ 3.30GHz (8 Cores / 16 Threads), Motherboard: ASUS G513QY v1.0 (G513QY.311 BIOS), Chipset: AMD Renoir/Cezanne, Memory: 16GB, Disk: 512GB SAMSUNG MZVLQ512HBLU-00B00, Graphics: ASUS AMD Cezanne 512MB (2600/1000MHz), Audio: AMD Navi 21 HDMI Audio, Monitor: LQ156M1JW25, Network: Realtek RTL8111/8168/8411 + MEDIATEK Device 7961 OS: Ubuntu 21.10, Kernel: 5.15.0-rc1-phx (x86_64) 20210913, Desktop: GNOME Shell 40.2, Display Server: X Server 1.20.11 + Wayland, OpenGL: 4.6 Mesa 21.2.1 (LLVM 12.0.1), Vulkan: 1.2.182, Compiler: GCC 11.2.0, File-System: ext4, Screen Resolution: 1920x1080 1a: Processor: AMD Ryzen 9 5900HX @ 3.30GHz (8 Cores / 16 Threads), Motherboard: ASUS G513QY v1.0 (G513QY.311 BIOS), Chipset: AMD Renoir/Cezanne, Memory: 16GB, Disk: 512GB SAMSUNG MZVLQ512HBLU-00B00, Graphics: ASUS AMD Cezanne 512MB (2600/1000MHz), Audio: AMD Navi 21 HDMI Audio, Monitor: LQ156M1JW25, Network: Realtek RTL8111/8168/8411 + MEDIATEK Device 7961 OS: Ubuntu 21.10, Kernel: 5.15.0-rc1-phx (x86_64) 20210913, Desktop: GNOME Shell 40.2, Display Server: X Server 1.20.11 + Wayland, OpenGL: 4.6 Mesa 21.2.1 (LLVM 12.0.1), Vulkan: 1.2.182, Compiler: GCC 11.2.0, File-System: ext4, Screen Resolution: 1920x1080 1b: Processor: AMD Ryzen 9 5900HX @ 3.30GHz (8 Cores / 16 Threads), Motherboard: ASUS G513QY v1.0 (G513QY.311 BIOS), Chipset: AMD Renoir/Cezanne, Memory: 16GB, Disk: 512GB SAMSUNG MZVLQ512HBLU-00B00, Graphics: ASUS AMD Cezanne 512MB (2600/1000MHz), Audio: AMD Navi 21 HDMI Audio, Monitor: LQ156M1JW25, Network: Realtek RTL8111/8168/8411 + MEDIATEK Device 7961 OS: Ubuntu 21.10, Kernel: 5.15.0-rc1-phx (x86_64) 20210913, Desktop: GNOME Shell 40.2, Display Server: X Server 1.20.11 + Wayland, OpenGL: 4.6 Mesa 21.2.1 (LLVM 12.0.1), Vulkan: 1.2.182, Compiler: GCC 11.2.0, File-System: ext4, Screen Resolution: 1920x1080 2: Processor: AMD Ryzen 9 5900HX @ 3.30GHz (8 Cores / 16 Threads), Motherboard: ASUS G513QY v1.0 (G513QY.311 BIOS), Chipset: AMD Renoir/Cezanne, Memory: 16GB, Disk: 512GB SAMSUNG MZVLQ512HBLU-00B00, Graphics: ASUS AMD Cezanne 512MB (2600/1000MHz), Audio: AMD Navi 21 HDMI Audio, Monitor: LQ156M1JW25, Network: Realtek RTL8111/8168/8411 + MEDIATEK Device 7961 OS: Ubuntu 21.10, Kernel: 5.15.0-rc1-phx (x86_64) 20210913, Desktop: GNOME Shell 40.2, Display Server: X Server 1.20.11 + Wayland, OpenGL: 4.6 Mesa 21.2.1 (LLVM 12.0.1), Vulkan: 1.2.182, Compiler: GCC 11.2.0, File-System: ext4, Screen Resolution: 1920x1080 3: Processor: AMD Ryzen 9 5900HX @ 3.30GHz (8 Cores / 16 Threads), Motherboard: ASUS G513QY v1.0 (G513QY.311 BIOS), Chipset: AMD Renoir/Cezanne, Memory: 16GB, Disk: 512GB SAMSUNG MZVLQ512HBLU-00B00, Graphics: ASUS AMD Cezanne 512MB (2600/1000MHz), Audio: AMD Navi 21 HDMI Audio, Monitor: LQ156M1JW25, Network: Realtek RTL8111/8168/8411 + MEDIATEK Device 7961 OS: Ubuntu 21.10, Kernel: 5.15.0-rc1-phx (x86_64) 20210913, Desktop: GNOME Shell 40.2, Display Server: X Server 1.20.11 + Wayland, OpenGL: 4.6 Mesa 21.2.1 (LLVM 12.0.1), Vulkan: 1.2.182, Compiler: GCC 11.2.0, File-System: ext4, Screen Resolution: 1920x1080 PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Only TPS > Higher Is Better 1 .. 34122 |================================================================== 1a . 34309 |=================================================================== 3 .. 34544 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better 1 .. 0.029 |=================================================================== 1a . 0.029 |=================================================================== 3 .. 0.029 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Write TPS > Higher Is Better 1a . 1366 |==================================================================== 1b . 515 |========================== 3 .. 1344 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better 1a . 0.732 |========================= 1b . 1.942 |=================================================================== 3 .. 0.744 |========================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Only TPS > Higher Is Better 1a . 320042 |================================================================= 1b . 321924 |================================================================= 2 .. 326456 |================================================================== 3 .. 325633 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better 1a . 0.156 |=================================================================== 1b . 0.155 |=================================================================== 2 .. 0.153 |================================================================== 3 .. 0.154 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Only TPS > Higher Is Better 1a . 303541 |================================================================= 1b . 305828 |================================================================== 2 .. 306186 |================================================================== 3 .. 307442 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better 1a . 0.329 |=================================================================== 1b . 0.327 |=================================================================== 2 .. 0.327 |=================================================================== 3 .. 0.325 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Only TPS > Higher Is Better 1a . 225079 |================================================================== 1b . 222730 |================================================================= 2 .. 224921 |================================================================== 3 .. 225250 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better 1a . 1.111 |================================================================== 1b . 1.122 |=================================================================== 2 .. 1.112 |================================================================== 3 .. 1.110 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Write TPS > Higher Is Better 1a . 1212 |==================================================================== 1b . 1172 |================================================================== 2 .. 1164 |================================================================= 3 .. 1205 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better 1a . 41.26 |================================================================ 1b . 42.67 |=================================================================== 2 .. 42.95 |=================================================================== 3 .. 41.48 |================================================================= PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 500 - Mode: Read Only TPS > Higher Is Better 1a . 195448 |================================================================== 3 .. 191460 |================================================================= PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better 1a . 2.558 |================================================================== 3 .. 2.612 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Only TPS > Higher Is Better 1a . 30552 |================================================================= 1b . 31040 |================================================================== 3 .. 31481 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better 1a . 0.033 |=================================================================== 1b . 0.032 |================================================================= 3 .. 0.032 |================================================================= PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Write TPS > Higher Is Better 1a . 1164 |==================================================================== 1b . 1153 |=================================================================== 2 .. 1152 |=================================================================== 3 .. 1153 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better 1a . 85.93 |================================================================== 1b . 86.70 |=================================================================== 2 .. 86.84 |=================================================================== 3 .. 86.70 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Write TPS > Higher Is Better 1a . 903 |================================================================= 1b . 936 |=================================================================== 2 .. 957 |===================================================================== 3 .. 963 |===================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better 1a . 276.80 |================================================================== 1b . 267.07 |================================================================ 2 .. 261.36 |============================================================== 3 .. 259.64 |============================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 500 - Mode: Read Write TPS > Higher Is Better 1a . 609 |=========================================================== 3 .. 718 |===================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better 1a . 820.95 |================================================================== 3 .. 696.15 |======================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Write TPS > Higher Is Better 1a . 1071 |==================================================================== 1b . 1058 |=================================================================== 3 .. 1075 |==================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better 1a . 0.933 |================================================================== 1b . 0.945 |=================================================================== 3 .. 0.930 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Only TPS > Higher Is Better 1a . 304993 |================================================================== 1b . 302337 |================================================================= 2 .. 304880 |================================================================== 3 .. 303240 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better 1a . 0.164 |=================================================================== 1b . 0.165 |=================================================================== 2 .. 0.164 |=================================================================== 3 .. 0.165 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only TPS > Higher Is Better 1a . 5564 |=================================================================== 1b . 5625 |==================================================================== 3 .. 5282 |================================================================ PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better 1a . 0.180 |================================================================ 1b . 0.178 |=============================================================== 3 .. 0.189 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Only TPS > Higher Is Better 1a . 293130 |================================================================= 1b . 295665 |================================================================== 2 .. 294045 |================================================================== 3 .. 289073 |================================================================= PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better 1a . 0.341 |================================================================== 1b . 0.338 |================================================================= 2 .. 0.340 |================================================================== 3 .. 0.346 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 250 - Mode: Read Only TPS > Higher Is Better 1a . 212988 |================================================================= 1b . 209865 |================================================================ 2 .. 216100 |================================================================== 3 .. 212991 |================================================================= PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better 1a . 1.174 |================================================================== 1b . 1.191 |=================================================================== 2 .. 1.157 |================================================================= 3 .. 1.174 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Write TPS > Higher Is Better 1a . 15400 |=================================================================== 1b . 14768 |================================================================ 2 .. 15092 |================================================================== 3 .. 15222 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better 1a . 3.247 |================================================================ 1b . 3.386 |=================================================================== 2 .. 3.313 |================================================================== 3 .. 3.285 |================================================================= PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 500 - Mode: Read Only TPS > Higher Is Better 1a . 177450 |================================================================== 3 .. 173552 |================================================================= PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better 1a . 2.818 |================================================================== 3 .. 2.881 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write TPS > Higher Is Better 1a . 268 |===================================================================== 1b . 224 |========================================================== 3 .. 229 |=========================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better 1a . 3.729 |======================================================== 1b . 4.470 |=================================================================== 3 .. 4.370 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only TPS > Higher Is Better 1a . 71322 |================================================================== 1b . 72712 |=================================================================== 2 .. 68378 |=============================================================== 3 .. 72037 |================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better 1a . 0.701 |================================================================ 1b . 0.688 |=============================================================== 2 .. 0.731 |=================================================================== 3 .. 0.694 |================================================================ PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Write TPS > Higher Is Better 1b . 8869 |=============================================================== 2 .. 9648 |==================================================================== 3 .. 8840 |============================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better 1b . 11.28 |=================================================================== 2 .. 10.36 |============================================================= 3 .. 11.31 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 250 - Mode: Read Write TPS > Higher Is Better 1b . 10063 |=================================================================== 2 .. 8967 |============================================================ 3 .. 8480 |======================================================== PostgreSQL pgbench 14.0 Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better 1b . 24.84 |======================================================== 2 .. 27.88 |=============================================================== 3 .. 29.48 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only TPS > Higher Is Better 1b . 71564 |=================================================================== 2 .. 66833 |============================================================== 3 .. 71648 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better 1b . 1.397 |=============================================================== 2 .. 1.496 |=================================================================== 3 .. 1.396 |=============================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only TPS > Higher Is Better 1b . 64652 |=============================================================== 2 .. 66516 |================================================================= 3 .. 68986 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better 1b . 3.867 |=================================================================== 2 .. 3.759 |================================================================= 3 .. 3.624 |=============================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write TPS > Higher Is Better 1b . 3166 |==================================================================== 2 .. 3005 |================================================================= 3 .. 2795 |============================================================ PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better 1b . 15.79 |=========================================================== 2 .. 16.64 |============================================================== 3 .. 17.89 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write TPS > Higher Is Better 1b . 3497 |================================================================== 2 .. 3605 |==================================================================== 3 .. 3335 |=============================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better 1b . 28.60 |================================================================ 2 .. 27.74 |============================================================== 3 .. 29.99 |=================================================================== PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write TPS > Higher Is Better 1b . 3192 |================================================================= 2 .. 3344 |==================================================================== 3 .. 2948 |============================================================ PostgreSQL pgbench 14.0 Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better 1b . 78.32 |============================================================== 2 .. 74.77 |=========================================================== 3 .. 84.79 |===================================================================