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.

pgbench-testProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelVulkanCompilerFile-SystemScreen ResolutionDisplay ServerDisplay DriverOpenCL2 x Intel Xeon E5-2665 0 - Matrox G200eR2 - Dell2 x Intel Xeon E5-2667 v2 - Matrox G200eR2 8GB - Dell2 x Intel Xeon E5-2665 0 @ 3.10GHz (16 Cores / 32 Threads)Dell 0C4Y3R (1.6.0 BIOS)Intel Xeon E5/Core64GB1999GB PERC H710P + 2GB Internal Dual SDMatrox G200eR2NVIDIA Device 228bDELL P2414H4 x Broadcom NetXtreme BCM5720 2-port PCIeUbuntu 20.045.4.0-171-generic (x86_64)1.1.182GCC 9.4.0ext41600x9002 x Intel Xeon E5-2667 v2 @ 4.00GHz (16 Cores / 32 Threads)Dell 0C4Y3R (2.9.0 BIOS)Intel Xeon E7 v2/Xeon224GBMatrox G200eR2 8GBX Server 1.20.13NVIDIAOpenCL 3.0 CUDA 11.8.881.3.205GCC 9.4.0 + CUDA 11.8OpenBenchmarking.orgKernel Details- Transparent Huge Pages: madviseCompiler 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: 0x42eSecurity 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-testpgbench: 1000 - 100 - Read Onlypgbench: 1000 - 100 - Read Only - Average Latencypgbench: 1000 - 100 - Read Writepgbench: 1000 - 100 - Read Write - Average Latency2 x Intel Xeon E5-2665 0 - Matrox G200eR2 - Dell2 x Intel Xeon E5-2667 v2 - Matrox G200eR2 8GB - Dell2991500.334844120.6693804020.263594168.326OpenBenchmarking.org

PostgreSQL

Scaling Factor: 1000 - Clients: 100 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 100 - Mode: Read Only2 x Intel Xeon E5-2665 0 - Matrox G200eR2 - Dell2 x Intel Xeon E5-2667 v2 - Matrox G200eR2 8GB - Dell80K160K240K320K400KSE +/- 127.56, N = 3SE +/- 413.73, N = 32991503804021. (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.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency2 x Intel Xeon E5-2665 0 - Matrox G200eR2 - Dell2 x Intel Xeon E5-2667 v2 - Matrox G200eR2 8GB - Dell0.07520.15040.22560.30080.376SE +/- 0.000, N = 3SE +/- 0.000, N = 30.3340.2631. (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.orgTPS, More Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 100 - Mode: Read Write2 x Intel Xeon E5-2665 0 - Matrox G200eR2 - Dell2 x Intel Xeon E5-2667 v2 - Matrox G200eR2 8GB - Dell2004006008001000SE +/- 40.22, N = 9SE +/- 4.88, N = 38445941. (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.orgms, Fewer Is BetterPostgreSQL 15Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency2 x Intel Xeon E5-2665 0 - Matrox G200eR2 - Dell2 x Intel Xeon E5-2667 v2 - Matrox G200eR2 8GB - Dell4080120160200SE +/- 5.60, N = 9SE +/- 1.39, N = 3120.67168.331. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

Phoronix Test Suite v10.8.4