Pgbench Linux 5.11

2 x AMD EPYC 7742 64-Core testing with a AMD DAYTONA_X (RDY1006G BIOS) and llvmpipe 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 2101093-HA-PGBENCHLI35
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
Prefer Vertical Bar Graphs

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
5 Jan
January 08 2021
  13 Hours, 25 Minutes
Master + Revert
January 08 2021
  13 Hours, 12 Minutes
Invert Hiding All Results Option
  13 Hours, 18 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 Linux 5.11OpenBenchmarking.orgPhoronix Test Suite2 x AMD EPYC 7742 64-Core @ 2.25GHz (128 Cores / 256 Threads)AMD DAYTONA_X (RDY1006G BIOS)AMD Starship/Matisse504GB2 x 3841GB Micron_9300_MTFDHAL3T8TDPllvmpipeVE2282 x Mellanox MT27710Ubuntu 20.045.11.0-051100rc2daily20210105-generic (x86_64) 202101045.11.0-rc2-phx (x86_64) 20210108GNOME Shell 3.36.4X Server 1.20.8modesetting 1.20.83.3 Mesa 20.0.8 (LLVM 10.0.0 128 bits)GCC 9.3.0ext41920x1080ProcessorMotherboardChipsetMemoryDiskGraphicsMonitorNetworkOSKernelsDesktopDisplay ServerDisplay DriverOpenGLCompilerFile-SystemScreen ResolutionPgbench Linux 5.11 BenchmarksSystem Logs- --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: acpi-cpufreq ondemand (Boost: Enabled) - CPU Microcode: 0x8301034 - itlb_multihit: Not affected + 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 Full AMD retpoline IBPB: conditional IBRS_FW STIBP: conditional RSB filling + srbds: Not affected + tsx_async_abort: Not affected

5 Jan vs. Master + Revert ComparisonPhoronix Test SuiteBaseline+11.5%+11.5%+23%+23%+34.5%+34.5%46%35.3%35%34.9%34.4%25.8%16.6%15.5%7.6%6.2%1000 - 250 - Read Write1000 - 100 - Read Write - Average Latency100 - 250 - Read Write - Average Latency100 - 250 - Read Write1000 - 250 - Read Write - Average Latency1000 - 100 - Read Write100 - 100 - Read Write - Average Latency100 - 100 - Read Write10000 - 250 - Read Write - Average Latency10000 - 250 - Read Write10000 - 100 - Read Write3.7%10000 - 100 - Read Write - Average Latency2.2%PostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbench5 JanMaster + Revert

Pgbench Linux 5.11pgbench: 100 - 100 - Read Writepgbench: 100 - 100 - Read Write - Average Latencypgbench: 100 - 250 - Read Writepgbench: 100 - 250 - Read Write - Average Latencypgbench: 1000 - 100 - Read Writepgbench: 1000 - 100 - Read Write - Average Latencypgbench: 1000 - 250 - Read Writepgbench: 1000 - 250 - Read Write - Average Latencypgbench: 10000 - 100 - Read Writepgbench: 10000 - 100 - Read Write - Average Latencypgbench: 10000 - 250 - Read Writepgbench: 10000 - 250 - Read Write - Average Latency5 JanMaster + Revert453562.231323847.760198475.9381179022.729947210.963821431.374523751.914436875.749249664.3901720816.917913111.205872329.169OpenBenchmarking.org

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: 100 - Clients: 100 - Mode: Read Write5 JanMaster + Revert11K22K33K44K55KSE +/- 1100.42, N = 15SE +/- 90.25, N = 345356523751. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 100 - Mode: Read Write5 JanMaster + Revert9K18K27K36K45KMin: 33741.93 / Avg: 45356 / Max: 51871.26Min: 52195.75 / Avg: 52374.66 / Max: 52484.761. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency5 JanMaster + Revert0.5021.0041.5062.0082.51SE +/- 0.065, N = 15SE +/- 0.004, N = 32.2311.9141. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency5 JanMaster + Revert246810Min: 1.93 / Avg: 2.23 / Max: 2.97Min: 1.91 / Avg: 1.91 / Max: 1.921. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 250 - Mode: Read Write5 JanMaster + Revert9K18K27K36K45KSE +/- 336.79, N = 3SE +/- 64.47, N = 332384436871. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 250 - Mode: Read Write5 JanMaster + Revert8K16K24K32K40KMin: 31720.05 / Avg: 32383.51 / Max: 32815.97Min: 43576.17 / Avg: 43687.14 / Max: 43799.51. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency5 JanMaster + Revert246810SE +/- 0.082, N = 3SE +/- 0.010, N = 37.7605.7491. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency5 JanMaster + Revert3691215Min: 7.65 / Avg: 7.76 / Max: 7.92Min: 5.73 / Avg: 5.75 / Max: 5.761. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 100 - Mode: Read Write5 JanMaster + Revert5K10K15K20K25KSE +/- 2544.72, N = 9SE +/- 2147.35, N = 1219847249661. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 100 - Mode: Read Write5 JanMaster + Revert4K8K12K16K20KMin: 9428.6 / Avg: 19846.7 / Max: 30511.92Min: 13722.72 / Avg: 24966.23 / Max: 35212.451. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency5 JanMaster + Revert1.33612.67224.00835.34446.6805SE +/- 0.899, N = 9SE +/- 0.414, N = 125.9384.3901. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency5 JanMaster + Revert246810Min: 3.28 / Avg: 5.94 / Max: 10.63Min: 2.85 / Avg: 4.39 / Max: 7.31. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 250 - Mode: Read Write5 JanMaster + Revert4K8K12K16K20KSE +/- 955.72, N = 12SE +/- 2208.03, N = 1211790172081. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 250 - Mode: Read Write5 JanMaster + Revert3K6K9K12K15KMin: 7881.97 / Avg: 11790.43 / Max: 17828.93Min: 9085.22 / Avg: 17207.52 / Max: 36507.771. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average Latency5 JanMaster + Revert510152025SE +/- 1.62, N = 12SE +/- 1.79, N = 1222.7316.921. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average Latency5 JanMaster + Revert510152025Min: 14.08 / Avg: 22.73 / Max: 31.91Min: 6.88 / Avg: 16.92 / Max: 27.661. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 10000 - Clients: 100 - Mode: Read Write5 JanMaster + Revert2K4K6K8K10KSE +/- 670.48, N = 9SE +/- 466.99, N = 9947291311. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 10000 - Clients: 100 - Mode: Read Write5 JanMaster + Revert16003200480064008000Min: 7236.6 / Avg: 9472.39 / Max: 13658.34Min: 7031.37 / Avg: 9130.85 / Max: 11545.961. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 10000 - Clients: 100 - Mode: Read Write - Average Latency5 JanMaster + Revert3691215SE +/- 0.69, N = 9SE +/- 0.57, N = 910.9611.211. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 10000 - Clients: 100 - Mode: Read Write - Average Latency5 JanMaster + Revert3691215Min: 7.33 / Avg: 10.96 / Max: 13.84Min: 8.68 / Avg: 11.2 / Max: 14.261. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 10000 - Clients: 250 - Mode: Read Write5 JanMaster + Revert2K4K6K8K10KSE +/- 515.28, N = 9SE +/- 336.10, N = 9821487231. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 10000 - Clients: 250 - Mode: Read Write5 JanMaster + Revert15003000450060007500Min: 7048.89 / Avg: 8213.6 / Max: 11924.79Min: 7319.41 / Avg: 8722.96 / Max: 9685.761. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 10000 - Clients: 250 - Mode: Read Write - Average Latency5 JanMaster + Revert714212835SE +/- 1.54, N = 9SE +/- 1.16, N = 931.3729.171. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 10000 - Clients: 250 - Mode: Read Write - Average Latency5 JanMaster + Revert714212835Min: 21.05 / Avg: 31.37 / Max: 35.66Min: 25.97 / Avg: 29.17 / Max: 34.341. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm