pgbench-results

Intel Xeon E5-1630 v3 testing with a Dell 0K240Y (A19 BIOS) and AMD FirePro V4900 on ManjaroLinux 20.2.1 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 2103127-HA-2103125HA59
Jump To Table - Results

View

Do Not Show Noisy Results
Do Not Show Results With Incomplete Data
Do Not Show Results With Little Change/Spread
List Notable Results

Statistics

Show Overall Harmonic Mean(s)
Show Overall Geometric Mean
Show Wins / Losses Counts (Pie Chart)
Normalize Results
Remove Outliers Before Calculating Averages

Graph Settings

Force Line Graphs Where Applicable
Convert To Scalar Where Applicable
Disable Color Branding
Prefer Vertical Bar Graphs

Additional Graphs

Show Perf Per Core/Thread Calculation Graphs Where Applicable
Show Perf Per Clock Calculation Graphs Where Applicable

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Highlight
Result
Hide
Result
Result
Identifier
View Logs
Performance Per
Dollar
Date
Run
  Test
  Duration
Intel Xeon Silver 4210R - AMD Radeon PRO WX 3200 -
March 13 2021
  3 Minutes
Intel Xeon E5-1630 v3 - AMD FirePro V4900 - Dell
March 12 2021
  7 Minutes
Invert Hiding All Results Option
  5 Minutes
Only show results matching title/arguments (delimit multiple options with a comma):
Do not show results matching title/arguments (delimit multiple options with a comma):


pgbench-resultsProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDisplay ServerCompilerFile-SystemScreen ResolutionDesktopIntel Xeon Silver 4210R - AMD Radeon PRO WX 3200 -Intel Xeon E5-1630 v3 - AMD FirePro V4900 - DellIntel Xeon Silver 4210R @ 3.20GHz (10 Cores / 20 Threads)Dell 0804P1 (2.12.0 BIOS)Intel Sky Lake-E DMI3 Registers32GBPM981a NVMe Samsung 1024GB + 1000GB Western Digital WD10EZEX-75W + 16GB USB 2.0 FD + 0GB SD/MMC CRWAMD Radeon PRO WX 3200 (1295/1500MHz)Realtek ALC3234DELL P1913SIntel I219-LMArch Linux5.11.2-arch1-1 (x86_64)X Server 1.20.10GCC 10.2.0xfs1280x1024Intel Xeon E5-1630 v3 @ 3.80GHz (4 Cores / 8 Threads)Dell 0K240Y (A19 BIOS)Intel Xeon E7 v3/Xeon16GB256GB SAMSUNG SSD SM87AMD FirePro V4900Realtek ALC32202 x DELL P2414H + DELL U2412MIntel I217-LMManjaroLinux 20.2.15.4.100-1-MANJARO (x86_64)Cinnamon 4.8.6GCC 10.2.0 + Clang 11.1.0 + LLVM 11.1.0ext41920x1080OpenBenchmarking.orgKernel Details- Transparent Huge Pages: madviseCompiler Details- --disable-libssp --disable-libstdcxx-pch --disable-libunwind-exceptions --disable-werror --enable-__cxa_atexit --enable-cet=auto --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-default-ssp --enable-gnu-indirect-function --enable-gnu-unique-object --enable-install-libiberty --enable-languages=c,c++,ada,fortran,go,lto,objc,obj-c++,d --enable-lto --enable-multilib --enable-plugin --enable-shared --enable-threads=posix --mandir=/usr/share/man --with-isl --with-linker-hash-style=gnu Processor Details- Intel Xeon Silver 4210R - AMD Radeon PRO WX 3200 -: Scaling Governor: intel_pstate powersave - CPU Microcode: 0x5003006- Intel Xeon E5-1630 v3 - AMD FirePro V4900 - Dell: Scaling Governor: intel_pstate powersave - CPU Microcode: 0x44Security Details- Intel Xeon Silver 4210R - AMD Radeon PRO WX 3200 -: itlb_multihit: KVM: Mitigation of VMX disabled + l1tf: Not affected + mds: Not affected + meltdown: 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 Enhanced IBRS IBPB: conditional RSB filling + srbds: Not affected + tsx_async_abort: Mitigation of TSX disabled - Intel Xeon E5-1630 v3 - AMD FirePro V4900 - Dell: 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 + 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: conditional RSB filling + srbds: Not affected + tsx_async_abort: Not affected

PostgreSQL pgbench

This is a benchmark of PostgreSQL using pgbench for facilitating the database benchmarks. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 50 - Mode: Read WriteIntel Xeon Silver 4210R - AMD Radeon PRO WX 3200 -Intel Xeon E5-1630 v3 - AMD FirePro V4900 - Dell150300450600750SE +/- 2.19, N = 3SE +/- 3.87, N = 76944101. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 50 - Mode: Read WriteIntel Xeon Silver 4210R - AMD Radeon PRO WX 3200 -Intel Xeon E5-1630 v3 - AMD FirePro V4900 - Dell120240360480600Min: 690.39 / Avg: 693.91 / Max: 697.92Min: 387.61 / Avg: 410.37 / Max: 417.671. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average LatencyIntel Xeon Silver 4210R - AMD Radeon PRO WX 3200 -Intel Xeon E5-1630 v3 - AMD FirePro V4900 - Dell306090120150SE +/- 0.23, N = 3SE +/- 1.20, N = 772.09121.941. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average LatencyIntel Xeon Silver 4210R - AMD Radeon PRO WX 3200 -Intel Xeon E5-1630 v3 - AMD FirePro V4900 - Dell20406080100Min: 71.67 / Avg: 72.09 / Max: 72.45Min: 119.74 / Avg: 121.94 / Max: 129.031. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm