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.
Compare your own system(s) to this result file with the
Phoronix Test Suite by running the command:
phoronix-test-suite benchmark 2311246-NE-2311196NE87 pgbench_more - Phoronix Test Suite 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.
HTML result view exported from: https://openbenchmarking.org/result/2311246-NE-2311196NE87&rdt&grw .
pgbench_more Processor Motherboard Chipset Memory Disk Graphics Audio Network OS Kernel Display Server OpenGL Vulkan Compiler File-System Screen Resolution Desktop Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 3A6000 E3-1245V5 E3-1245-1 Intel Xeon E3-1225 V2 @ 2.50GHz (4 Cores) Gigabyte H61M-DS2 (F7 BIOS) Intel Xeon E3-1200 v2/Ivy 16GB 256GB HYS256 Gigabyte Intel Xeon E3-1200 v2/3rd Gen Core (1250MHz) Realtek ALC887-VD Realtek RTL8111/8168/8411 Kylin v10 5.10.0-8-generic (x86_64) X Server 1.20.9 4.2 Mesa 20.2.6 1.2.145 GCC 9.3.0 ext4 1920x1080 Loongson-3A6000-HV @ 2.50GHz (4 Cores / 8 Threads) O.E.M (Loongson-UDK2018-V4.0.05569-stable202308 BIOS) Loongson LLC Hyper Transport Bridge SSD 512GB llvmpipe Loongson LLC Device 7a37 Loongnix 20 4.19.0-19-loongson-3 (loongarch64) X Server 1.20.4 3.3 Mesa 18.3.6 (LLVM 8.0 256 bits) GCC 8.3.0 xfs 1536x864 Intel Xeon E3-1245 v5 @ 3.90GHz (4 Cores / 8 Threads) Colorful And Development C.B250M-D (5.12 BIOS) Intel Xeon E3-1200 v5/E3-1500 + B250 512GB Western Digital WD PC SN810 SDCPNRY-512G-1006 Intel HD P530 (1150MHz) Realtek ALC662 rev3 Ubuntu 22.04 6.2.0-26-generic (x86_64) GNOME Shell 42.9 X Server 1.21.1.4 4.5 Mesa 23.0.4-0ubuntu1~22.04.1 (LLVM 15.0.7 256 bits) 1.3.238 GCC 11.4.0 ext4 1280x720 OpenBenchmarking.org Kernel Details - Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200: Transparent Huge Pages: madvise - 3A6000: Transparent Huge Pages: always - E3-1245V5: Transparent Huge Pages: madvise - E3-1245-1: Transparent Huge Pages: madvise Environment Details - Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200: ZLOG_PROFILE_DEBUG=/var/log/xtx/zlog_debug.log Compiler Details - Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200: --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++,gm2 --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none,hsa --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib=auto --with-tune=generic --without-cuda-driver -v - 3A6000: --build=loongarch64-linux-gnu --disable-emultls --disable-host-shared --disable-libitm --disable-libquadmath --disable-libquadmath-support --disable-libsanitizer --disable-werror --enable-checking=release --enable-clocale=gnu --enable-gnu-unique-object --enable-languages=c,c++,fortran --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-nls --enable-plugin --enable-shared --enable-threads=posix --enable-tls --host=loongarch64-linux-gnu --program-prefix=loongarch64-linux-gnu- --target=loongarch64-linux-gnu --with-abi=lp64 --with-arch=loongarch64 --with-default-libstdcxx-abi=new --with-gcc-major-version-only -v - E3-1245V5: --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-bootstrap --enable-cet --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-link-serialization=2 --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-11-XeT9lY/gcc-11-11.4.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-11-XeT9lY/gcc-11-11.4.0/debian/tmp-gcn/usr --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-build-config=bootstrap-lto-lean --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib=auto --with-tune=generic --without-cuda-driver -v - E3-1245-1: --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-bootstrap --enable-cet --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-link-serialization=2 --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-11-XeT9lY/gcc-11-11.4.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-11-XeT9lY/gcc-11-11.4.0/debian/tmp-gcn/usr --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-build-config=bootstrap-lto-lean --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib=auto --with-tune=generic --without-cuda-driver -v Processor Details - Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200: Scaling Governor: intel_cpufreq schedutil - CPU Microcode: 0x21 - 3A6000: Scaling Governor: acpi-cpufreq performance - E3-1245V5: Scaling Governor: intel_pstate powersave (EPP: balance_performance) - CPU Microcode: 0xf0 - Thermald 2.4.9 - E3-1245-1: Scaling Governor: intel_pstate powersave (EPP: balance_performance) - CPU Microcode: 0xf0 - Thermald 2.4.9 Security Details - Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200: itlb_multihit: KVM: Mitigation of VMX unsupported + l1tf: Mitigation of PTE Inversion + mds: Mitigation of Clear buffers; SMT disabled + meltdown: Mitigation of PTI + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Full generic retpoline IBPB: conditional IBRS_FW STIBP: disabled RSB filling + srbds: Vulnerable: No microcode + tsx_async_abort: Not affected - E3-1245V5: itlb_multihit: KVM: Mitigation of VMX disabled + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT vulnerable + mds: Mitigation of Clear buffers; SMT vulnerable + meltdown: Mitigation of PTI + mmio_stale_data: Mitigation of Clear buffers; SMT vulnerable + retbleed: Mitigation of IBRS + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of IBRS IBPB: conditional STIBP: conditional RSB filling PBRSB-eIBRS: Not affected + srbds: Mitigation of Microcode + tsx_async_abort: Mitigation of TSX disabled - E3-1245-1: itlb_multihit: KVM: Mitigation of VMX disabled + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT vulnerable + mds: Mitigation of Clear buffers; SMT vulnerable + meltdown: Mitigation of PTI + mmio_stale_data: Mitigation of Clear buffers; SMT vulnerable + retbleed: Mitigation of IBRS + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of IBRS IBPB: conditional STIBP: conditional RSB filling PBRSB-eIBRS: Not affected + srbds: Mitigation of Microcode + tsx_async_abort: Mitigation of TSX disabled
pgbench_more pgbench: 1 - 50 - Read Write pgbench: 1 - 50 - Read Write - Average Latency pgbench: 1 - 100 - Read Write pgbench: 1 - 100 - Read Write - Average Latency pgbench: 1 - 500 - Read Write pgbench: 1 - 500 - Read Write - Average Latency pgbench: 1 - 1000 - Read Write pgbench: 1 - 1000 - Read Write - Average Latency pgbench: 100 - 50 - Read Write pgbench: 100 - 50 - Read Write - Average Latency pgbench: 100 - 100 - Read Write pgbench: 100 - 100 - Read Write - Average Latency pgbench: 100 - 500 - Read Write pgbench: 100 - 500 - Read Write - Average Latency pgbench: 1000 - 50 - Read Write pgbench: 1000 - 50 - Read Write - Average Latency pgbench: 100 - 1000 - Read Write pgbench: 100 - 1000 - Read Write - Average Latency pgbench: 1000 - 100 - Read Write pgbench: 1000 - 100 - Read Write - Average Latency pgbench: 1000 - 500 - Read Write pgbench: 1000 - 500 - Read Write - Average Latency pgbench: 1000 - 1000 - Read Write pgbench: 1000 - 1000 - Read Write - Average Latency Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 3A6000 E3-1245V5 E3-1245-1 1126 44.514 973 102.866 317 1582.795 143 6996.742 2149 23.964 2111 48.459 1614 311.842 1835 27.262 1809 559.874 1685 59.711 1699 298.436 1774 564.030 2563 19.513 2207 45.304 740 676.118 291 3463.691 12674 3.973 12373 8.100 8349 59.975 4502 11.251 5589 178.980 4319 23.281 4543 110.077 5028 198.902 1963 25.468 1884 53.068 552 910.938 238 4222.494 15554 3.221 12366 8.087 7817 63.966 13530 3.695 5189 192.810 11457 8.728 9146 54.667 7734 129.309 1652 30.352 1500 66.882 540 940.449 253 3990.009 15861 3.160 12939 7.730 8085 61.849 13849 3.610 5305 188.584 11691 8.553 9397 53.207 7880 126.905 OpenBenchmarking.org
PostgreSQL Scaling Factor: 1 - Clients: 50 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Write Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 3A6000 E3-1245V5 E3-1245-1 500 1000 1500 2000 2500 SE +/- 16.09, N = 12 SE +/- 13.05, N = 3 SE +/- 11.16, N = 3 SE +/- 27.47, N = 12 1126 2563 1963 1652 -lpthread -lrt -ldl -lpthread -lrt -ldl 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 3A6000 E3-1245V5 E3-1245-1 10 20 30 40 50 SE +/- 0.63, N = 12 SE +/- 0.10, N = 3 SE +/- 0.15, N = 3 SE +/- 0.50, N = 12 44.51 19.51 25.47 30.35 -lpthread -lrt -ldl -lpthread -lrt -ldl 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 100 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Write Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 3A6000 E3-1245V5 E3-1245-1 500 1000 1500 2000 2500 SE +/- 10.43, N = 12 SE +/- 7.56, N = 3 SE +/- 5.96, N = 3 SE +/- 25.11, N = 12 973 2207 1884 1500 -lpthread -lrt -ldl -lpthread -lrt -ldl 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 3A6000 E3-1245V5 E3-1245-1 20 40 60 80 100 SE +/- 1.14, N = 12 SE +/- 0.16, N = 3 SE +/- 0.17, N = 3 SE +/- 1.10, N = 12 102.87 45.30 53.07 66.88 -lpthread -lrt -ldl -lpthread -lrt -ldl 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 500 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Write Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 3A6000 E3-1245V5 E3-1245-1 160 320 480 640 800 SE +/- 5.27, N = 12 SE +/- 4.25, N = 3 SE +/- 14.07, N = 9 SE +/- 22.47, N = 9 317 740 552 540 -lpthread -lrt -ldl -lpthread -lrt -ldl 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 3A6000 E3-1245V5 E3-1245-1 300 600 900 1200 1500 SE +/- 26.38, N = 12 SE +/- 3.88, N = 3 SE +/- 24.15, N = 9 SE +/- 42.42, N = 9 1582.80 676.12 910.94 940.45 -lpthread -lrt -ldl -lpthread -lrt -ldl 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 1000 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 1000 - Mode: Read Write Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 3A6000 E3-1245V5 E3-1245-1 60 120 180 240 300 SE +/- 2.38, N = 12 SE +/- 7.49, N = 12 SE +/- 4.79, N = 12 SE +/- 6.65, N = 12 143 291 238 253 -lpthread -lrt -ldl -lpthread -lrt -ldl 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1 - Clients: 1000 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 1000 - Mode: Read Write - Average Latency Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 3A6000 E3-1245V5 E3-1245-1 1500 3000 4500 6000 7500 SE +/- 120.27, N = 12 SE +/- 92.20, N = 12 SE +/- 87.11, N = 12 SE +/- 110.48, N = 12 6996.74 3463.69 4222.49 3990.01 -lpthread -lrt -ldl -lpthread -lrt -ldl 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 50 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Write Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 3A6000 E3-1245V5 E3-1245-1 3K 6K 9K 12K 15K SE +/- 111.17, N = 12 SE +/- 320.58, N = 12 SE +/- 210.72, N = 12 SE +/- 229.00, N = 12 2149 12674 15554 15861 -lpthread -lrt -ldl -lpthread -lrt -ldl 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 3A6000 E3-1245V5 E3-1245-1 6 12 18 24 30 SE +/- 1.248, N = 12 SE +/- 0.103, N = 12 SE +/- 0.045, N = 12 SE +/- 0.047, N = 12 23.964 3.973 3.221 3.160 -lpthread -lrt -ldl 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 100 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Write Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 3A6000 E3-1245V5 E3-1245-1 3K 6K 9K 12K 15K SE +/- 99.04, N = 12 SE +/- 174.64, N = 12 SE +/- 54.71, N = 3 SE +/- 132.02, N = 3 2111 12373 12366 12939 -lpthread -lrt -ldl -lpthread -lrt -ldl 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 3A6000 E3-1245V5 E3-1245-1 11 22 33 44 55 SE +/- 2.157, N = 12 SE +/- 0.117, N = 12 SE +/- 0.036, N = 3 SE +/- 0.079, N = 3 48.459 8.100 8.087 7.730 -lpthread -lrt -ldl 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 500 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Write Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 3A6000 E3-1245V5 E3-1245-1 2K 4K 6K 8K 10K SE +/- 47.42, N = 9 SE +/- 100.75, N = 12 SE +/- 42.87, N = 3 SE +/- 44.24, N = 3 1614 8349 7817 8085 -lpthread -lrt -ldl -lpthread -lrt -ldl 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 3A6000 E3-1245V5 E3-1245-1 70 140 210 280 350 SE +/- 8.85, N = 9 SE +/- 0.66, N = 12 SE +/- 0.35, N = 3 SE +/- 0.34, N = 3 311.84 59.98 63.97 61.85 -lpthread -lrt -ldl -lpthread -lrt -ldl 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 50 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 3A6000 E3-1245V5 E3-1245-1 3K 6K 9K 12K 15K SE +/- 21.53, N = 3 SE +/- 186.51, N = 9 SE +/- 2.03, N = 3 SE +/- 37.38, N = 3 1835 4502 13530 13849 -lpthread -lrt -ldl 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 3A6000 E3-1245V5 E3-1245-1 6 12 18 24 30 SE +/- 0.320, N = 3 SE +/- 0.440, N = 9 SE +/- 0.000, N = 3 SE +/- 0.010, N = 3 27.262 11.251 3.695 3.610 -lpthread -lrt -ldl -lpthread -lrt -ldl 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 1000 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 1000 - Mode: Read Write Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 3A6000 E3-1245V5 E3-1245-1 1200 2400 3600 4800 6000 SE +/- 67.85, N = 9 SE +/- 68.62, N = 3 SE +/- 52.39, N = 5 SE +/- 58.07, N = 5 1809 5589 5189 5305 -lpthread -lrt -ldl -lpthread -lrt -ldl 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 100 - Clients: 1000 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 1000 - Mode: Read Write - Average Latency Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 3A6000 E3-1245V5 E3-1245-1 120 240 360 480 600 SE +/- 23.56, N = 9 SE +/- 2.22, N = 3 SE +/- 2.00, N = 5 SE +/- 2.13, N = 5 559.87 178.98 192.81 188.58 -lpthread -lrt -ldl -lpthread -lrt -ldl 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 100 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 3A6000 E3-1245V5 E3-1245-1 3K 6K 9K 12K 15K SE +/- 57.02, N = 6 SE +/- 122.45, N = 9 SE +/- 23.12, N = 3 SE +/- 19.44, N = 3 1685 4319 11457 11691 -lpthread -lrt -ldl 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 3A6000 E3-1245V5 E3-1245-1 13 26 39 52 65 SE +/- 2.059, N = 6 SE +/- 0.567, N = 9 SE +/- 0.018, N = 3 SE +/- 0.014, N = 3 59.711 23.281 8.728 8.553 -lpthread -lrt -ldl -lpthread -lrt -ldl 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 500 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 3A6000 E3-1245V5 E3-1245-1 2K 4K 6K 8K 10K SE +/- 69.49, N = 9 SE +/- 38.26, N = 3 SE +/- 1.23, N = 3 SE +/- 15.47, N = 3 1699 4543 9146 9397 -lpthread -lrt -ldl -lpthread -lrt -ldl 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average Latency Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 3A6000 E3-1245V5 E3-1245-1 60 120 180 240 300 SE +/- 12.89, N = 9 SE +/- 0.92, N = 3 SE +/- 0.01, N = 3 SE +/- 0.09, N = 3 298.44 110.08 54.67 53.21 -lpthread -lrt -ldl -lpthread -lrt -ldl 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 3A6000 E3-1245V5 E3-1245-1 2K 4K 6K 8K 10K SE +/- 25.52, N = 3 SE +/- 31.03, N = 3 SE +/- 18.47, N = 3 SE +/- 5.05, N = 3 1774 5028 7734 7880 -lpthread -lrt -ldl -lpthread -lrt -ldl 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write - Average Latency Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 3A6000 E3-1245V5 E3-1245-1 120 240 360 480 600 SE +/- 8.16, N = 3 SE +/- 1.23, N = 3 SE +/- 0.31, N = 3 SE +/- 0.08, N = 3 564.03 198.90 129.31 126.91 -lpthread -lrt -ldl -lpthread -lrt -ldl 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
Phoronix Test Suite v10.8.4