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&grt&sro .
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 3A6000 E3-1245-1 E3-1245V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 500 1000 1500 2000 2500 SE +/- 13.05, N = 3 SE +/- 27.47, N = 12 SE +/- 11.16, N = 3 SE +/- 16.09, N = 12 2563 1652 1963 1126 -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 3A6000 E3-1245-1 E3-1245V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 10 20 30 40 50 SE +/- 0.10, N = 3 SE +/- 0.50, N = 12 SE +/- 0.15, N = 3 SE +/- 0.63, N = 12 19.51 30.35 25.47 44.51 -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 3A6000 E3-1245-1 E3-1245V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 500 1000 1500 2000 2500 SE +/- 7.56, N = 3 SE +/- 25.11, N = 12 SE +/- 5.96, N = 3 SE +/- 10.43, N = 12 2207 1500 1884 973 -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 3A6000 E3-1245-1 E3-1245V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 20 40 60 80 100 SE +/- 0.16, N = 3 SE +/- 1.10, N = 12 SE +/- 0.17, N = 3 SE +/- 1.14, N = 12 45.30 66.88 53.07 102.87 -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 3A6000 E3-1245-1 E3-1245V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 160 320 480 640 800 SE +/- 4.25, N = 3 SE +/- 22.47, N = 9 SE +/- 14.07, N = 9 SE +/- 5.27, N = 12 740 540 552 317 -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 3A6000 E3-1245-1 E3-1245V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 300 600 900 1200 1500 SE +/- 3.88, N = 3 SE +/- 42.42, N = 9 SE +/- 24.15, N = 9 SE +/- 26.38, N = 12 676.12 940.45 910.94 1582.80 -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 3A6000 E3-1245-1 E3-1245V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 60 120 180 240 300 SE +/- 7.49, N = 12 SE +/- 6.65, N = 12 SE +/- 4.79, N = 12 SE +/- 2.38, N = 12 291 253 238 143 -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 3A6000 E3-1245-1 E3-1245V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 1500 3000 4500 6000 7500 SE +/- 92.20, N = 12 SE +/- 110.48, N = 12 SE +/- 87.11, N = 12 SE +/- 120.27, N = 12 3463.69 3990.01 4222.49 6996.74 -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 3A6000 E3-1245-1 E3-1245V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 3K 6K 9K 12K 15K SE +/- 320.58, N = 12 SE +/- 229.00, N = 12 SE +/- 210.72, N = 12 SE +/- 111.17, N = 12 12674 15861 15554 2149 -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 3A6000 E3-1245-1 E3-1245V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 6 12 18 24 30 SE +/- 0.103, N = 12 SE +/- 0.047, N = 12 SE +/- 0.045, N = 12 SE +/- 1.248, N = 12 3.973 3.160 3.221 23.964 -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 3A6000 E3-1245-1 E3-1245V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 3K 6K 9K 12K 15K SE +/- 174.64, N = 12 SE +/- 132.02, N = 3 SE +/- 54.71, N = 3 SE +/- 99.04, N = 12 12373 12939 12366 2111 -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 3A6000 E3-1245-1 E3-1245V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 11 22 33 44 55 SE +/- 0.117, N = 12 SE +/- 0.079, N = 3 SE +/- 0.036, N = 3 SE +/- 2.157, N = 12 8.100 7.730 8.087 48.459 -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 3A6000 E3-1245-1 E3-1245V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 2K 4K 6K 8K 10K SE +/- 100.75, N = 12 SE +/- 44.24, N = 3 SE +/- 42.87, N = 3 SE +/- 47.42, N = 9 8349 8085 7817 1614 -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 3A6000 E3-1245-1 E3-1245V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 70 140 210 280 350 SE +/- 0.66, N = 12 SE +/- 0.34, N = 3 SE +/- 0.35, N = 3 SE +/- 8.85, N = 9 59.98 61.85 63.97 311.84 -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 3A6000 E3-1245-1 E3-1245V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 3K 6K 9K 12K 15K SE +/- 186.51, N = 9 SE +/- 37.38, N = 3 SE +/- 2.03, N = 3 SE +/- 21.53, N = 3 4502 13849 13530 1835 -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 3A6000 E3-1245-1 E3-1245V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 6 12 18 24 30 SE +/- 0.440, N = 9 SE +/- 0.010, N = 3 SE +/- 0.000, N = 3 SE +/- 0.320, N = 3 11.251 3.610 3.695 27.262 -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 3A6000 E3-1245-1 E3-1245V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 1200 2400 3600 4800 6000 SE +/- 68.62, N = 3 SE +/- 58.07, N = 5 SE +/- 52.39, N = 5 SE +/- 67.85, N = 9 5589 5305 5189 1809 -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 3A6000 E3-1245-1 E3-1245V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 120 240 360 480 600 SE +/- 2.22, N = 3 SE +/- 2.13, N = 5 SE +/- 2.00, N = 5 SE +/- 23.56, N = 9 178.98 188.58 192.81 559.87 -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 3A6000 E3-1245-1 E3-1245V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 3K 6K 9K 12K 15K SE +/- 122.45, N = 9 SE +/- 19.44, N = 3 SE +/- 23.12, N = 3 SE +/- 57.02, N = 6 4319 11691 11457 1685 -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 3A6000 E3-1245-1 E3-1245V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 13 26 39 52 65 SE +/- 0.567, N = 9 SE +/- 0.014, N = 3 SE +/- 0.018, N = 3 SE +/- 2.059, N = 6 23.281 8.553 8.728 59.711 -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 3A6000 E3-1245-1 E3-1245V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 2K 4K 6K 8K 10K SE +/- 38.26, N = 3 SE +/- 15.47, N = 3 SE +/- 1.23, N = 3 SE +/- 69.49, N = 9 4543 9397 9146 1699 -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 3A6000 E3-1245-1 E3-1245V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 60 120 180 240 300 SE +/- 0.92, N = 3 SE +/- 0.09, N = 3 SE +/- 0.01, N = 3 SE +/- 12.89, N = 9 110.08 53.21 54.67 298.44 -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 3A6000 E3-1245-1 E3-1245V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 2K 4K 6K 8K 10K SE +/- 31.03, N = 3 SE +/- 5.05, N = 3 SE +/- 18.47, N = 3 SE +/- 25.52, N = 3 5028 7880 7734 1774 -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 3A6000 E3-1245-1 E3-1245V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 120 240 360 480 600 SE +/- 1.23, N = 3 SE +/- 0.08, N = 3 SE +/- 0.31, N = 3 SE +/- 8.16, N = 3 198.90 126.91 129.31 564.03 -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