2 x Intel Xeon E5-2667 v2 testing with a Dell 0C4Y3R (2.9.0 BIOS) and Matrox G200eR2 8GB on Ubuntu 20.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 2402150-KORC-240212955 pgbench-test - Phoronix Test Suite pgbench-test 2 x Intel Xeon E5-2667 v2 testing with a Dell 0C4Y3R (2.9.0 BIOS) and Matrox G200eR2 8GB on Ubuntu 20.04 via the Phoronix Test Suite.
HTML result view exported from: https://openbenchmarking.org/result/2402150-KORC-240212955&rdt&grs .
pgbench-test Processor Motherboard Chipset Memory Disk Graphics Audio Monitor Network OS Kernel Vulkan Compiler File-System Screen Resolution Display Server Display Driver OpenCL 2 x Intel Xeon E5-2665 0 - Matrox G200eR2 - Dell 2 x Intel Xeon E5-2667 v2 - Matrox G200eR2 8GB - Dell 2 x Intel Xeon E5-2665 0 @ 3.10GHz (16 Cores / 32 Threads) Dell 0C4Y3R (1.6.0 BIOS) Intel Xeon E5/Core 64GB 1999GB PERC H710P + 2GB Internal Dual SD Matrox G200eR2 NVIDIA Device 228b DELL P2414H 4 x Broadcom NetXtreme BCM5720 2-port PCIe Ubuntu 20.04 5.4.0-171-generic (x86_64) 1.1.182 GCC 9.4.0 ext4 1600x900 2 x Intel Xeon E5-2667 v2 @ 4.00GHz (16 Cores / 32 Threads) Dell 0C4Y3R (2.9.0 BIOS) Intel Xeon E7 v2/Xeon 224GB Matrox G200eR2 8GB X Server 1.20.13 NVIDIA OpenCL 3.0 CUDA 11.8.88 1.3.205 GCC 9.4.0 + CUDA 11.8 OpenBenchmarking.org Kernel Details - Transparent Huge Pages: madvise Compiler Details - --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=/build/gcc-9-9QDOt0/gcc-9-9.4.0/debian/tmp-nvptx/usr,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 Processor Details - 2 x Intel Xeon E5-2665 0 - Matrox G200eR2 - Dell: Scaling Governor: intel_pstate powersave - CPU Microcode: 0x71a - 2 x Intel Xeon E5-2667 v2 - Matrox G200eR2 8GB - Dell: Scaling Governor: intel_pstate powersave - CPU Microcode: 0x42e Security Details - gather_data_sampling: Not affected + itlb_multihit: KVM: Mitigation of Split huge pages + 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: Unknown: No mitigations + retbleed: Not affected + 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 Retpolines IBPB: conditional IBRS_FW STIBP: conditional RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected
pgbench-test pgbench: 1000 - 100 - Read Only pgbench: 1000 - 100 - Read Only - Average Latency pgbench: 1000 - 100 - Read Write - Average Latency pgbench: 1000 - 100 - Read Write pgbench: 1000 - 100 - Read Only 2 x Intel Xeon E5-2665 0 - Matrox G200eR2 - Dell 2 x Intel Xeon E5-2667 v2 - Matrox G200eR2 8GB - Dell 299150 0.334 120.669 844 380402 0.263 168.326 594 OpenBenchmarking.org
PostgreSQL Scaling Factor: 1000 - Clients: 100 - Mode: Read Only OpenBenchmarking.org TPS, More Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only 2 x Intel Xeon E5-2665 0 - Matrox G200eR2 - Dell 2 x Intel Xeon E5-2667 v2 - Matrox G200eR2 8GB - Dell 80K 160K 240K 320K 400K SE +/- 127.56, N = 3 SE +/- 413.73, N = 3 299150 380402 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 15 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency 2 x Intel Xeon E5-2665 0 - Matrox G200eR2 - Dell 2 x Intel Xeon E5-2667 v2 - Matrox G200eR2 8GB - Dell 0.0752 0.1504 0.2256 0.3008 0.376 SE +/- 0.000, N = 3 SE +/- 0.000, N = 3 0.334 0.263 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 2 x Intel Xeon E5-2665 0 - Matrox G200eR2 - Dell 2 x Intel Xeon E5-2667 v2 - Matrox G200eR2 8GB - Dell 40 80 120 160 200 SE +/- 5.60, N = 9 SE +/- 1.39, N = 3 120.67 168.33 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 2 x Intel Xeon E5-2665 0 - Matrox G200eR2 - Dell 2 x Intel Xeon E5-2667 v2 - Matrox G200eR2 8GB - Dell 200 400 600 800 1000 SE +/- 40.22, N = 9 SE +/- 4.88, N = 3 844 594 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
Phoronix Test Suite v10.8.4