Compare your own system(s) to this result file with the
Phoronix Test Suite by running the command:
phoronix-test-suite benchmark 2311200-NE-2311196NE94 pgbench_more - Phoronix Test Suite pgbench_more E3-1245V5-1
HTML result view exported from: https://openbenchmarking.org/result/2311200-NE-2311196NE94&grs&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-1345V5 E3-1245V5-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.50GHz (4 Cores / 8 Threads) Colorful And Development C.B250M-D (5.12 BIOS) Intel Xeon E3-1200 v5/E3-1500 + B250 ZGJOLONG 990 PLUS 512GB llvmpipe (1150MHz) Realtek ALC662 rev3 Ubuntu 22.04 6.2.0-36-generic (x86_64) GNOME Shell 42.5 X Server 1.21.1.3 4.5 Mesa 22.2.5 (LLVM 15.0.6 256 bits) 1.3.224 GCC 11.4.0 ext4 1280x720 Intel Xeon E3-1245 v5 @ 3.90GHz (4 Cores / 8 Threads) OpenBenchmarking.org Kernel Details - Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200: Transparent Huge Pages: madvise - 3A6000: Transparent Huge Pages: always - E3-1345V5: Transparent Huge Pages: madvise - E3-1245V5-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-1345V5: --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-1245V5-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-1345V5: Scaling Governor: intel_pstate performance (EPP: performance) - CPU Microcode: 0xf0 - Thermald 2.4.9 - E3-1245V5-1: Scaling Governor: intel_pstate performance (EPP: 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-1345V5: gather_data_sampling: Not affected + 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_rstack_overflow: Not affected + 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-1245V5-1: gather_data_sampling: Not affected + 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_rstack_overflow: Not affected + 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 - Average Latency pgbench: 1 - 100 - Read Write pgbench: 1000 - 1000 - Read Write - Average Latency pgbench: 1000 - 1000 - Read Write pgbench: 1000 - 500 - Read Write - Average Latency pgbench: 1000 - 500 - Read Write pgbench: 1000 - 100 - Read Write - Average Latency pgbench: 1000 - 100 - Read Write pgbench: 100 - 1000 - Read Write - Average Latency pgbench: 100 - 1000 - Read Write pgbench: 1000 - 50 - Read Write - Average Latency pgbench: 1000 - 50 - Read Write pgbench: 100 - 500 - Read Write - Average Latency pgbench: 100 - 500 - Read Write pgbench: 100 - 100 - Read Write - Average Latency pgbench: 100 - 100 - Read Write pgbench: 100 - 50 - Read Write - Average Latency pgbench: 100 - 50 - Read Write pgbench: 1 - 1000 - Read Write - Average Latency pgbench: 1 - 1000 - Read Write pgbench: 1 - 500 - Read Write - Average Latency pgbench: 1 - 500 - Read Write Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 3A6000 E3-1345V5 E3-1245V5-1 1126 44.514 102.866 973 564.030 1774 298.436 1699 59.711 1685 559.874 1809 27.262 1835 311.842 1614 48.459 2111 23.964 2149 6996.742 143 1582.795 317 2563 19.513 45.304 2207 198.902 5028 110.077 4543 23.281 4319 178.980 5589 11.251 4502 59.975 8349 8.100 12373 3.973 12674 3463.691 291 676.118 740 893 56.006 115.171 868 375.805 1370 62.877 1627 269.220 3736 21.398 2352 81.785 6116 18.200 5518 11.368 4691 4281.716 235 1078.455 468 850 58.818 119.751 835 697.038 1462 440.231 1159 83.615 1221 550.056 1866 37.849 1367 89.581 5588 19.256 5193 11.765 4359 4252.832 236 1052.504 475 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-1245V5-1 E3-1345V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 500 1000 1500 2000 2500 SE +/- 13.05, N = 3 SE +/- 0.59, N = 3 SE +/- 1.66, N = 3 SE +/- 16.09, N = 12 2563 850 893 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-1245V5-1 E3-1345V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 13 26 39 52 65 SE +/- 0.10, N = 3 SE +/- 0.04, N = 3 SE +/- 0.10, N = 3 SE +/- 0.63, N = 12 19.51 58.82 56.01 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 - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency 3A6000 E3-1245V5-1 E3-1345V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 30 60 90 120 150 SE +/- 0.16, N = 3 SE +/- 0.13, N = 3 SE +/- 1.03, N = 3 SE +/- 1.14, N = 12 45.30 119.75 115.17 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: 100 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 100 - Mode: Read Write 3A6000 E3-1245V5-1 E3-1345V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 500 1000 1500 2000 2500 SE +/- 7.56, N = 3 SE +/- 0.92, N = 3 SE +/- 7.76, N = 3 SE +/- 10.43, N = 12 2207 835 868 973 -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-1245V5-1 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 150 300 450 600 750 SE +/- 1.23, N = 3 SE +/- 44.95, N = 6 SE +/- 8.16, N = 3 198.90 697.04 564.03 -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-1245V5-1 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 1100 2200 3300 4400 5500 SE +/- 31.03, N = 3 SE +/- 84.27, N = 6 SE +/- 25.52, N = 3 5028 1462 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: 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-1245V5-1 E3-1345V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 100 200 300 400 500 SE +/- 0.92, N = 3 SE +/- 22.32, N = 9 SE +/- 21.80, N = 9 SE +/- 12.89, N = 9 110.08 440.23 375.81 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: 500 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 500 - Mode: Read Write 3A6000 E3-1245V5-1 E3-1345V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 1000 2000 3000 4000 5000 SE +/- 38.26, N = 3 SE +/- 59.06, N = 9 SE +/- 86.51, N = 9 SE +/- 69.49, N = 9 4543 1159 1370 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: 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-1245V5-1 E3-1345V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 20 40 60 80 100 SE +/- 0.57, N = 9 SE +/- 4.60, N = 9 SE +/- 3.51, N = 9 SE +/- 2.06, N = 6 23.28 83.62 62.88 59.71 -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-1245V5-1 E3-1345V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 900 1800 2700 3600 4500 SE +/- 122.45, N = 9 SE +/- 58.95, N = 9 SE +/- 83.95, N = 9 SE +/- 57.02, N = 6 4319 1221 1627 1685 -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-1245V5-1 E3-1345V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 120 240 360 480 600 SE +/- 2.22, N = 3 SE +/- 31.61, N = 9 SE +/- 6.12, N = 12 SE +/- 23.56, N = 9 178.98 550.06 269.22 559.87 -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-1245V5-1 E3-1345V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 1200 2400 3600 4800 6000 SE +/- 68.62, N = 3 SE +/- 104.35, N = 9 SE +/- 85.84, N = 12 SE +/- 67.85, N = 9 5589 1866 3736 1809 -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 - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency 3A6000 E3-1245V5-1 E3-1345V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 9 18 27 36 45 SE +/- 0.44, N = 9 SE +/- 2.52, N = 9 SE +/- 0.64, N = 9 SE +/- 0.32, N = 3 11.25 37.85 21.40 27.26 -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-1245V5-1 E3-1345V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 1000 2000 3000 4000 5000 SE +/- 186.51, N = 9 SE +/- 88.68, N = 9 SE +/- 66.00, N = 9 SE +/- 21.53, N = 3 4502 1367 2352 1835 -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-1245V5-1 E3-1345V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 70 140 210 280 350 SE +/- 0.66, N = 12 SE +/- 0.94, N = 12 SE +/- 1.16, N = 3 SE +/- 8.85, N = 9 59.98 89.58 81.79 311.84 -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 OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 100 - Clients: 500 - Mode: Read Write 3A6000 E3-1245V5-1 E3-1345V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 2K 4K 6K 8K 10K SE +/- 100.75, N = 12 SE +/- 59.18, N = 12 SE +/- 87.80, N = 3 SE +/- 47.42, N = 9 8349 5588 6116 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: 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-1245V5-1 E3-1345V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 11 22 33 44 55 SE +/- 0.117, N = 12 SE +/- 0.059, N = 3 SE +/- 0.332, N = 12 SE +/- 2.157, N = 12 8.100 19.256 18.200 48.459 -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-1245V5-1 E3-1345V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 3K 6K 9K 12K 15K SE +/- 174.64, N = 12 SE +/- 15.78, N = 3 SE +/- 118.22, N = 12 SE +/- 99.04, N = 12 12373 5193 5518 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: 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-1245V5-1 E3-1345V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 6 12 18 24 30 SE +/- 0.103, N = 12 SE +/- 0.483, N = 12 SE +/- 0.640, N = 12 SE +/- 1.248, N = 12 3.973 11.765 11.368 23.964 -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-1245V5-1 E3-1345V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 3K 6K 9K 12K 15K SE +/- 320.58, N = 12 SE +/- 244.73, N = 12 SE +/- 484.56, N = 12 SE +/- 111.17, N = 12 12674 4359 4691 2149 -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-1245V5-1 E3-1345V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 1500 3000 4500 6000 7500 SE +/- 92.20, N = 12 SE +/- 68.31, N = 12 SE +/- 101.90, N = 12 SE +/- 120.27, N = 12 3463.69 4252.83 4281.72 6996.74 -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-1245V5-1 E3-1345V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 60 120 180 240 300 SE +/- 7.49, N = 12 SE +/- 3.86, N = 12 SE +/- 5.90, N = 12 SE +/- 2.38, N = 12 291 236 235 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: 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-1245V5-1 E3-1345V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 300 600 900 1200 1500 SE +/- 3.88, N = 3 SE +/- 11.16, N = 3 SE +/- 39.09, N = 9 SE +/- 26.38, N = 12 676.12 1052.50 1078.46 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: 500 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1 - Clients: 500 - Mode: Read Write 3A6000 E3-1245V5-1 E3-1345V5 Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 160 320 480 640 800 SE +/- 4.25, N = 3 SE +/- 5.09, N = 3 SE +/- 15.62, N = 9 SE +/- 5.27, N = 12 740 475 468 317 -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