pgbench1 Intel Xeon E3-1225 V2 testing with a Gigabyte H61M-DS2 (F7 BIOS) and Gigabyte Intel Xeon E3-1200 v2/3rd Gen Core on Kylin v10 via the Phoronix Test Suite.
HTML result view exported from: https://openbenchmarking.org/result/2305206-NE-PGBENCH1673&gru .
pgbench1 Processor Motherboard Chipset Memory Disk Graphics Audio Network OS Kernel Display Server OpenGL Vulkan Compiler File-System Screen Resolution Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 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 OpenBenchmarking.org - Transparent Huge Pages: madvise - ZLOG_PROFILE_DEBUG=/var/log/xtx/zlog_debug.log - --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 - Scaling Governor: intel_cpufreq schedutil - CPU Microcode: 0x21 - 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
pgbench1 pgbench: 100 - 50 - Read Write pgbench: 100 - 50 - Read Write - Average Latency Intel Xeon E3-1225 V2 - Gigabyte Intel Xeon E3-1200 2853 18.187 OpenBenchmarking.org
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 600 1200 1800 2400 3000 SE +/- 177.25, N = 12 2853 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -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 4 8 12 16 20 SE +/- 0.99, N = 12 18.19 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
Phoronix Test Suite v10.8.5