pgbench_more Intel Xeon E3-1245 v5 testing with a Colorful And Development C.B250M-D (5.12 BIOS) and Intel HD P530 on Ubuntu 22.04 via the Phoronix Test Suite. Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200: Processor: Intel Xeon E3-1225 V2 @ 2.50GHz (4 Cores), Motherboard: Gigabyte H61M-DS2 (F7 BIOS), Chipset: Intel Xeon E3-1200 v2/Ivy, Memory: 16GB, Disk: 256GB HYS256, Graphics: Gigabyte Intel Xeon E3-1200 v2/3rd Gen Core (1250MHz), Audio: Realtek ALC887-VD, Network: Realtek RTL8111/8168/8411 OS: Kylin v10, Kernel: 5.10.0-8-generic (x86_64), Display Server: X Server 1.20.9, OpenGL: 4.2 Mesa 20.2.6, Vulkan: 1.2.145, Compiler: GCC 9.3.0, File-System: ext4, Screen Resolution: 1920x1080 3A6000: Processor: Loongson-3A6000-HV @ 2.50GHz (4 Cores / 8 Threads), Motherboard: O.E.M (Loongson-UDK2018-V4.0.05569-stable202308 BIOS), Chipset: Loongson LLC Hyper Transport Bridge, Memory: 16GB, Disk: SSD 512GB, Graphics: llvmpipe, Audio: Loongson LLC Device 7a37, Network: Realtek RTL8111/8168/8411 OS: Loongnix 20, Kernel: 4.19.0-19-loongson-3 (loongarch64), Display Server: X Server 1.20.4, OpenGL: 3.3 Mesa 18.3.6 (LLVM 8.0 256 bits), Compiler: GCC 8.3.0, File-System: xfs, Screen Resolution: 1536x864 E3-1245V5: Processor: Intel Xeon E3-1245 v5 @ 3.90GHz (4 Cores / 8 Threads), Motherboard: Colorful And Development C.B250M-D (5.12 BIOS), Chipset: Intel Xeon E3-1200 v5/E3-1500 + B250, Memory: 16GB, Disk: 512GB Western Digital WD PC SN810 SDCPNRY-512G-1006, Graphics: Intel HD P530 (1150MHz), Audio: Realtek ALC662 rev3, Network: Realtek RTL8111/8168/8411 OS: Ubuntu 22.04, Kernel: 6.2.0-26-generic (x86_64), Desktop: GNOME Shell 42.9, Display Server: X Server 1.21.1.4, OpenGL: 4.5 Mesa 23.0.4-0ubuntu1~22.04.1 (LLVM 15.0.7 256 bits), Vulkan: 1.3.238, Compiler: GCC 11.4.0, File-System: ext4, Screen Resolution: 1280x720 E3-1245-1: Processor: Intel Xeon E3-1245 v5 @ 3.90GHz (4 Cores / 8 Threads), Motherboard: Colorful And Development C.B250M-D (5.12 BIOS), Chipset: Intel Xeon E3-1200 v5/E3-1500 + B250, Memory: 16GB, Disk: 512GB Western Digital WD PC SN810 SDCPNRY-512G-1006, Graphics: Intel HD P530 (1150MHz), Audio: Realtek ALC662 rev3, Network: Realtek RTL8111/8168/8411 OS: Ubuntu 22.04, Kernel: 6.2.0-26-generic (x86_64), Desktop: GNOME Shell 42.9, Display Server: X Server 1.21.1.4, OpenGL: 4.5 Mesa 23.0.4-0ubuntu1~22.04.1 (LLVM 15.0.7 256 bits), Vulkan: 1.3.238, Compiler: GCC 11.4.0, File-System: ext4, Screen Resolution: 1280x720 PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Write TPS > Higher Is Better Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 . 1126 |======== 3A6000 .............................................. 2563 |=================== E3-1245V5 ........................................... 1963 |=============== E3-1245-1 ........................................... 1652 |============ PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 . 44.51 |================== 3A6000 .............................................. 19.51 |======== E3-1245V5 ........................................... 25.47 |========== E3-1245-1 ........................................... 30.35 |============ PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Write TPS > Higher Is Better Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 . 973 |======== 3A6000 .............................................. 2207 |=================== E3-1245V5 ........................................... 1884 |================ E3-1245-1 ........................................... 1500 |============= PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 . 102.87 |================= 3A6000 .............................................. 45.30 |======= E3-1245V5 ........................................... 53.07 |========= E3-1245-1 ........................................... 66.88 |=========== PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Write TPS > Higher Is Better Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 . 317 |========= 3A6000 .............................................. 740 |==================== E3-1245V5 ........................................... 552 |=============== E3-1245-1 ........................................... 540 |=============== PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 . 1582.80 |================ 3A6000 .............................................. 676.12 |======= E3-1245V5 ........................................... 910.94 |========= E3-1245-1 ........................................... 940.45 |========== PostgreSQL 15 Scaling Factor: 1 - Clients: 1000 - Mode: Read Write TPS > Higher Is Better Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 . 143 |========== 3A6000 .............................................. 291 |==================== E3-1245V5 ........................................... 238 |================ E3-1245-1 ........................................... 253 |================= PostgreSQL 15 Scaling Factor: 1 - Clients: 1000 - Mode: Read Write - Average Latency ms < Lower Is Better Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 . 6996.74 |================ 3A6000 .............................................. 3463.69 |======== E3-1245V5 ........................................... 4222.49 |========== E3-1245-1 ........................................... 3990.01 |========= PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Write TPS > Higher Is Better Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 . 2149 |== 3A6000 .............................................. 12674 |============== E3-1245V5 ........................................... 15554 |================== E3-1245-1 ........................................... 15861 |================== PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 . 23.964 |================= 3A6000 .............................................. 3.973 |=== E3-1245V5 ........................................... 3.221 |== E3-1245-1 ........................................... 3.160 |== PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Write TPS > Higher Is Better Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 . 2111 |=== 3A6000 .............................................. 12373 |================= E3-1245V5 ........................................... 12366 |================= E3-1245-1 ........................................... 12939 |================== PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 . 48.459 |================= 3A6000 .............................................. 8.100 |=== E3-1245V5 ........................................... 8.087 |=== E3-1245-1 ........................................... 7.730 |=== PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Write TPS > Higher Is Better Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 . 1614 |==== 3A6000 .............................................. 8349 |=================== E3-1245V5 ........................................... 7817 |================== E3-1245-1 ........................................... 8085 |================== PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 . 311.84 |================= 3A6000 .............................................. 59.98 |=== E3-1245V5 ........................................... 63.97 |=== E3-1245-1 ........................................... 61.85 |=== PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write TPS > Higher Is Better Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 . 1835 |== 3A6000 .............................................. 4502 |====== E3-1245V5 ........................................... 13530 |================== E3-1245-1 ........................................... 13849 |================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 . 27.262 |================= 3A6000 .............................................. 11.251 |======= E3-1245V5 ........................................... 3.695 |== E3-1245-1 ........................................... 3.610 |== PostgreSQL 15 Scaling Factor: 100 - Clients: 1000 - Mode: Read Write TPS > Higher Is Better Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 . 1809 |====== 3A6000 .............................................. 5589 |=================== E3-1245V5 ........................................... 5189 |================== E3-1245-1 ........................................... 5305 |================== PostgreSQL 15 Scaling Factor: 100 - Clients: 1000 - Mode: Read Write - Average Latency ms < Lower Is Better Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 . 559.87 |================= 3A6000 .............................................. 178.98 |===== E3-1245V5 ........................................... 192.81 |====== E3-1245-1 ........................................... 188.58 |====== PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write TPS > Higher Is Better Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 . 1685 |=== 3A6000 .............................................. 4319 |======= E3-1245V5 ........................................... 11457 |================== E3-1245-1 ........................................... 11691 |================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 . 59.711 |================= 3A6000 .............................................. 23.281 |======= E3-1245V5 ........................................... 8.728 |== E3-1245-1 ........................................... 8.553 |== PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write TPS > Higher Is Better Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 . 1699 |=== 3A6000 .............................................. 4543 |========= E3-1245V5 ........................................... 9146 |================== E3-1245-1 ........................................... 9397 |=================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 . 298.44 |================= 3A6000 .............................................. 110.08 |====== E3-1245V5 ........................................... 54.67 |=== E3-1245-1 ........................................... 53.21 |=== PostgreSQL 15 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write TPS > Higher Is Better Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 . 1774 |==== 3A6000 .............................................. 5028 |============ E3-1245V5 ........................................... 7734 |=================== E3-1245-1 ........................................... 7880 |=================== PostgreSQL 15 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write - Average Latency ms < Lower Is Better Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 . 564.03 |================= 3A6000 .............................................. 198.90 |====== E3-1245V5 ........................................... 129.31 |==== E3-1245-1 ........................................... 126.91 |====