EPYC 7F72 PostgreSQL

AMD EPYC 7F72 24-Core testing with a ASRockRack EPYCD8 (P2.10 BIOS) and ASPEED 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 2009245-FI-EPYC7F72P26
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
1
September 24 2020
  2 Hours, 43 Minutes
2
September 24 2020
  3 Hours, 17 Minutes
3
September 24 2020
  2 Hours, 5 Minutes
Invert Hiding All Results Option
  2 Hours, 42 Minutes

Only show results where is faster than
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):


EPYC 7F72 PostgreSQLProcessorMotherboardChipsetMemoryDiskGraphicsAudioNetworkOSKernelDesktopDisplay ServerDisplay DriverCompilerFile-SystemScreen Resolution123AMD EPYC 7F72 24-Core @ 3.20GHz (24 Cores / 48 Threads)ASRockRack EPYCD8 (P2.10 BIOS)AMD Starship/Matisse126GB3841GB Micron_9300_MTFDHAL3T8TDPASPEEDAMD Starship/Matisse2 x Intel I350Ubuntu 20.045.9.0-050900rc6daily20200921-generic (x86_64) 20200920GNOME Shell 3.36.4X Server 1.20.8modesetting 1.20.8GCC 9.3.0ext41024x768OpenBenchmarking.orgCompiler 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,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- Scaling Governor: acpi-cpufreq ondemand - CPU Microcode: 0x830101cSecurity Details- 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: always-on RSB filling + srbds: Not affected + tsx_async_abort: Not affected

123Result OverviewPhoronix Test Suite100%102%105%107%110%PostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbench100 - 50 - Read Write - Average Latency100 - 50 - Read Write100 - 250 - Read Write - Average Latency100 - 250 - Read Write100 - 100 - Read Write - Average Latency100 - 100 - Read Write1 - 250 - Read Write1 - 250 - Read Write - Average Latency1000 - 100 - Read Write - Average Latency1000 - 100 - Read Write1000 - 50 - Read Write - Average Latency1 - 50 - Read Only - Average Latency1000 - 50 - Read Write1000 - 250 - Read Write - Average Latency1000 - 250 - Read Write1 - 50 - Read Only1 - 50 - Read Write1 - 50 - Read Write - Average Latency100 - 50 - Read Only100 - 50 - Read Only - Average Latency1000 - 50 - Read Only1000 - 50 - Read Only - Average Latency1 - 100 - Read Only1 - 100 - Read Only - Average Latency1000 - 100 - Read Only1 - 250 - Read Only100 - 100 - Read Only1 - 250 - Read Only - Average Latency1 - 100 - Read Write - Average Latency1 - 100 - Read Write100 - 100 - Read Only - Average Latency1000 - 100 - Read Only - Average Latency100 - 250 - Read Only - Average Latency1000 - 250 - Read Only - Average Latency1000 - 250 - Read Only100 - 250 - Read Only

EPYC 7F72 PostgreSQLpgbench: 1 - 50 - Read Onlypgbench: 1 - 50 - Read Only - Average Latencypgbench: 1 - 100 - Read Onlypgbench: 1 - 100 - Read Only - Average Latencypgbench: 1 - 250 - Read Onlypgbench: 1 - 250 - Read Only - Average Latencypgbench: 1 - 50 - Read Writepgbench: 1 - 50 - Read Write - Average Latencypgbench: 1 - 100 - Read Writepgbench: 1 - 100 - Read Write - Average Latencypgbench: 1 - 250 - Read Writepgbench: 1 - 250 - Read Write - Average Latencypgbench: 100 - 50 - Read Onlypgbench: 100 - 50 - Read Only - Average Latencypgbench: 100 - 100 - Read Onlypgbench: 100 - 100 - Read Only - Average Latencypgbench: 100 - 250 - Read Onlypgbench: 100 - 250 - Read Only - Average Latencypgbench: 100 - 50 - Read Writepgbench: 100 - 50 - Read Write - Average Latencypgbench: 1000 - 50 - Read Onlypgbench: 1000 - 50 - Read Only - Average Latencypgbench: 100 - 100 - Read Writepgbench: 100 - 100 - Read Write - Average Latencypgbench: 100 - 250 - Read Writepgbench: 100 - 250 - Read Write - Average Latencypgbench: 1000 - 100 - Read Onlypgbench: 1000 - 100 - Read Only - Average Latencypgbench: 1000 - 250 - Read Onlypgbench: 1000 - 250 - Read Only - Average Latencypgbench: 1000 - 50 - Read Writepgbench: 1000 - 50 - Read Write - Average Latencypgbench: 1000 - 100 - Read Writepgbench: 1000 - 100 - Read Write - Average Latencypgbench: 1000 - 250 - Read Writepgbench: 1000 - 250 - Read Write - Average Latency1236116690.0825270840.1905827440.430429811.637336929.7232243112.2604580390.1094172450.2404528880.552228712.1874312070.116310833.224320707.8093993550.2514327750.578221972.258309003.241331787.5446222150.0815235950.1915811330.431432711.560337029.7202311108.3794564920.1104181310.2404525480.553250221.9994303610.116338472.958350427.1443998040.2514321670.579227412.199298533.366324527.7226247980.085240870.1915799660.432434511.512335629.8452167115.5784537720.1104161520.2414519880.554250331.9984273910.117333783.000334527.4893978700.2524315230.580226872.205310453.225327117.658OpenBenchmarking.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: 1 - Clients: 50 - Mode: Read Only123130K260K390K520K650KSE +/- 8035.17, N = 3SE +/- 1522.06, N = 3SE +/- 640.21, N = 36116696222156247981. (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 Only123110K220K330K440K550KMin: 597910.46 / Avg: 611669.14 / Max: 625739.87Min: 620181 / Avg: 622214.55 / Max: 625193.09Min: 623717.08 / Avg: 624798.34 / Max: 625932.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: 1 - Clients: 50 - Mode: Read Only - Average Latency1230.01850.0370.05550.0740.0925SE +/- 0.001, N = 3SE +/- 0.000, N = 3SE +/- 0.000, N = 30.0820.0810.0801. (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 Only - Average Latency12312345Min: 0.08 / Avg: 0.08 / Max: 0.08Min: 0.08 / Avg: 0.08 / Max: 0.08Min: 0.08 / Avg: 0.08 / Max: 0.081. (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: 100 - Mode: Read Only123110K220K330K440K550KSE +/- 998.48, N = 3SE +/- 1368.71, N = 3SE +/- 1825.42, N = 35270845235955240871. (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: 100 - Mode: Read Only12390K180K270K360K450KMin: 525096.65 / Avg: 527083.72 / Max: 528249.15Min: 520950.42 / Avg: 523595.19 / Max: 525529.15Min: 520997.15 / Avg: 524087.1 / Max: 527316.011. (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: 100 - Mode: Read Only - Average Latency1230.0430.0860.1290.1720.215SE +/- 0.000, N = 3SE +/- 0.001, N = 3SE +/- 0.001, N = 30.1900.1910.1911. (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: 100 - Mode: Read Only - Average Latency12312345Min: 0.19 / Avg: 0.19 / Max: 0.19Min: 0.19 / Avg: 0.19 / Max: 0.19Min: 0.19 / Avg: 0.19 / Max: 0.191. (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: 250 - Mode: Read Only123120K240K360K480K600KSE +/- 859.82, N = 3SE +/- 1646.10, N = 3SE +/- 737.91, N = 35827445811335799661. (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: 250 - Mode: Read Only123100K200K300K400K500KMin: 581024.17 / Avg: 582743.68 / Max: 583621.68Min: 579393.21 / Avg: 581133.17 / Max: 584423.55Min: 578518.97 / Avg: 579965.94 / Max: 580940.891. (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: 250 - Mode: Read Only - Average Latency1230.09720.19440.29160.38880.486SE +/- 0.001, N = 3SE +/- 0.001, N = 3SE +/- 0.001, N = 30.4300.4310.4321. (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: 250 - Mode: Read Only - Average Latency12312345Min: 0.43 / Avg: 0.43 / Max: 0.43Min: 0.43 / Avg: 0.43 / Max: 0.43Min: 0.43 / Avg: 0.43 / Max: 0.431. (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 Write1239001800270036004500SE +/- 7.36, N = 3SE +/- 4.85, N = 3SE +/- 7.51, N = 34298432743451. (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 Write1238001600240032004000Min: 4289.13 / Avg: 4297.98 / Max: 4312.6Min: 4317.71 / Avg: 4326.61 / Max: 4334.41Min: 4332.4 / Avg: 4344.8 / Max: 4358.341. (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 Latency1233691215SE +/- 0.02, N = 3SE +/- 0.01, N = 3SE +/- 0.02, N = 311.6411.5611.511. (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 Latency1233691215Min: 11.6 / Avg: 11.64 / Max: 11.66Min: 11.54 / Avg: 11.56 / Max: 11.58Min: 11.48 / Avg: 11.51 / Max: 11.551. (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: 100 - Mode: Read Write1237001400210028003500SE +/- 24.66, N = 3SE +/- 21.84, N = 3SE +/- 36.11, N = 33369337033561. (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: 100 - Mode: Read Write1236001200180024003000Min: 3336.76 / Avg: 3369.31 / Max: 3417.67Min: 3333.83 / Avg: 3369.77 / Max: 3409.23Min: 3292.53 / Avg: 3356.27 / Max: 3417.561. (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: 100 - Mode: Read Write - Average Latency123714212835SE +/- 0.21, N = 3SE +/- 0.19, N = 3SE +/- 0.32, N = 329.7229.7229.851. (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: 100 - Mode: Read Write - Average Latency123714212835Min: 29.3 / Avg: 29.72 / Max: 30Min: 29.38 / Avg: 29.72 / Max: 30.04Min: 29.31 / Avg: 29.84 / Max: 30.411. (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: 250 - Mode: Read Write1235001000150020002500SE +/- 43.81, N = 15SE +/- 24.14, N = 8SE +/- 36.39, N = 32243231121671. (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: 250 - Mode: Read Write123400800120016002000Min: 1840.32 / Avg: 2243.29 / Max: 2431.47Min: 2166.53 / Avg: 2311.44 / Max: 2395.43Min: 2102.2 / Avg: 2166.86 / Max: 2228.111. (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: 250 - Mode: Read Write - Average Latency123306090120150SE +/- 2.47, N = 15SE +/- 1.17, N = 8SE +/- 1.94, N = 3112.26108.38115.581. (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: 250 - Mode: Read Write - Average Latency12320406080100Min: 102.96 / Avg: 112.26 / Max: 136.01Min: 104.52 / Avg: 108.38 / Max: 115.54Min: 112.34 / Avg: 115.58 / Max: 119.051. (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: 50 - Mode: Read Only123100K200K300K400K500KSE +/- 2544.53, N = 3SE +/- 2051.05, N = 3SE +/- 1014.04, N = 34580394564924537721. (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: 50 - Mode: Read Only12380K160K240K320K400KMin: 453105.43 / Avg: 458038.67 / Max: 461587.55Min: 454198.39 / Avg: 456491.96 / Max: 460584.1Min: 451976.64 / Avg: 453772.42 / Max: 455486.531. (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: 50 - Mode: Read Only - Average Latency1230.02480.04960.07440.09920.124SE +/- 0.001, N = 3SE +/- 0.000, N = 3SE +/- 0.000, N = 30.1090.1100.1101. (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: 50 - Mode: Read Only - Average Latency12312345Min: 0.11 / Avg: 0.11 / Max: 0.11Min: 0.11 / Avg: 0.11 / Max: 0.11Min: 0.11 / Avg: 0.11 / Max: 0.111. (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 Only12390K180K270K360K450KSE +/- 519.46, N = 3SE +/- 653.22, N = 3SE +/- 1042.56, N = 34172454181314161521. (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 Only12370K140K210K280K350KMin: 416623.17 / Avg: 417244.81 / Max: 418276.53Min: 417049.41 / Avg: 418131.12 / Max: 419306.41Min: 414067.85 / Avg: 416151.69 / Max: 417256.791. (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 Only - Average Latency1230.05420.10840.16260.21680.271SE +/- 0.000, N = 3SE +/- 0.000, N = 3SE +/- 0.001, N = 30.2400.2400.2411. (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 Only - Average Latency12312345Min: 0.24 / Avg: 0.24 / Max: 0.24Min: 0.24 / Avg: 0.24 / Max: 0.24Min: 0.24 / Avg: 0.24 / Max: 0.241. (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 Only123100K200K300K400K500KSE +/- 242.53, N = 3SE +/- 962.17, N = 3SE +/- 521.63, N = 34528884525484519881. (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 Only12380K160K240K320K400KMin: 452403.38 / Avg: 452888.26 / Max: 453142.19Min: 451183.27 / Avg: 452548.46 / Max: 454405.57Min: 451070.92 / Avg: 451987.97 / Max: 452877.251. (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 Only - Average Latency1230.12470.24940.37410.49880.6235SE +/- 0.000, N = 3SE +/- 0.001, N = 3SE +/- 0.001, N = 30.5520.5530.5541. (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 Only - Average Latency123246810Min: 0.55 / Avg: 0.55 / Max: 0.55Min: 0.55 / Avg: 0.55 / Max: 0.56Min: 0.55 / Avg: 0.55 / Max: 0.561. (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: 50 - Mode: Read Write1235K10K15K20K25KSE +/- 75.30, N = 3SE +/- 62.45, N = 3SE +/- 36.86, N = 32287125022250331. (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: 50 - Mode: Read Write1234K8K12K16K20KMin: 22734.72 / Avg: 22871.16 / Max: 22994.57Min: 24914.59 / Avg: 25021.53 / Max: 25130.89Min: 24972.29 / Avg: 25032.5 / Max: 25099.441. (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: 50 - Mode: Read Write - Average Latency1230.49210.98421.47631.96842.4605SE +/- 0.007, N = 3SE +/- 0.005, N = 3SE +/- 0.003, N = 32.1871.9991.9981. (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: 50 - Mode: Read Write - Average Latency123246810Min: 2.18 / Avg: 2.19 / Max: 2.2Min: 1.99 / Avg: 2 / Max: 2.01Min: 1.99 / Avg: 2 / Max: 21. (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: 50 - Mode: Read Only12390K180K270K360K450KSE +/- 4133.73, N = 3SE +/- 1933.67, N = 3SE +/- 2642.85, N = 34312074303614273911. (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: 50 - Mode: Read Only12370K140K210K280K350KMin: 424788.16 / Avg: 431207.03 / Max: 438928.88Min: 426498.52 / Avg: 430361.16 / Max: 432457.45Min: 422808.42 / Avg: 427391.3 / Max: 431963.491. (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: 50 - Mode: Read Only - Average Latency1230.02630.05260.07890.10520.1315SE +/- 0.001, N = 3SE +/- 0.000, N = 3SE +/- 0.001, N = 30.1160.1160.1171. (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: 50 - Mode: Read Only - Average Latency12312345Min: 0.11 / Avg: 0.12 / Max: 0.12Min: 0.12 / Avg: 0.12 / Max: 0.12Min: 0.12 / Avg: 0.12 / Max: 0.121. (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 Write1237K14K21K28K35KSE +/- 322.53, N = 8SE +/- 112.64, N = 3SE +/- 29.33, N = 33108333847333781. (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 Write1236K12K18K24K30KMin: 29940.85 / Avg: 31083.26 / Max: 32437.54Min: 33621.81 / Avg: 33846.98 / Max: 33965.48Min: 33323.47 / Avg: 33378.1 / Max: 33423.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: 100 - Clients: 100 - Mode: Read Write - Average Latency1230.72541.45082.17622.90163.627SE +/- 0.033, N = 8SE +/- 0.010, N = 3SE +/- 0.003, N = 33.2242.9583.0001. (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 Latency123246810Min: 3.09 / Avg: 3.22 / Max: 3.34Min: 2.95 / Avg: 2.96 / Max: 2.98Min: 3 / Avg: 3 / Max: 3.011. (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 Write1238K16K24K32K40KSE +/- 405.78, N = 3SE +/- 16.24, N = 3SE +/- 408.19, N = 63207035042334521. (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 Write1236K12K18K24K30KMin: 31301.52 / Avg: 32070.13 / Max: 32680.03Min: 35014.23 / Avg: 35042.29 / Max: 35070.47Min: 32440.65 / Avg: 33451.6 / Max: 34724.711. (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 Latency123246810SE +/- 0.100, N = 3SE +/- 0.003, N = 3SE +/- 0.090, N = 67.8097.1447.4891. (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 Latency1233691215Min: 7.66 / Avg: 7.81 / Max: 8Min: 7.14 / Avg: 7.14 / Max: 7.15Min: 7.21 / Avg: 7.49 / Max: 7.721. (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 Only12390K180K270K360K450KSE +/- 209.74, N = 3SE +/- 377.00, N = 3SE +/- 619.45, N = 33993553998043978701. (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 Only12370K140K210K280K350KMin: 398943.11 / Avg: 399355.05 / Max: 399629.55Min: 399161.56 / Avg: 399804.39 / Max: 400467.09Min: 396976.31 / Avg: 397870.25 / Max: 399060.051. (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 Only - Average Latency1230.05670.11340.17010.22680.2835SE +/- 0.000, N = 3SE +/- 0.000, N = 3SE +/- 0.000, N = 30.2510.2510.2521. (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 Only - Average Latency12312345Min: 0.25 / Avg: 0.25 / Max: 0.25Min: 0.25 / Avg: 0.25 / Max: 0.25Min: 0.25 / Avg: 0.25 / Max: 0.251. (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 Only12390K180K270K360K450KSE +/- 751.53, N = 3SE +/- 378.51, N = 3SE +/- 341.69, N = 34327754321674315231. (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 Only12380K160K240K320K400KMin: 431271.91 / Avg: 432774.9 / Max: 433538.38Min: 431414.78 / Avg: 432166.78 / Max: 432618.13Min: 431078.57 / Avg: 431523.08 / Max: 432194.861. (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 Only - Average Latency1230.13050.2610.39150.5220.6525SE +/- 0.001, N = 3SE +/- 0.000, N = 3SE +/- 0.001, N = 30.5780.5790.5801. (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 Only - Average Latency123246810Min: 0.58 / Avg: 0.58 / Max: 0.58Min: 0.58 / Avg: 0.58 / Max: 0.58Min: 0.58 / Avg: 0.58 / Max: 0.581. (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: 50 - Mode: Read Write1235K10K15K20K25KSE +/- 287.66, N = 12SE +/- 59.76, N = 3SE +/- 57.02, N = 32219722741226871. (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: 50 - Mode: Read Write1234K8K12K16K20KMin: 20211.05 / Avg: 22197.06 / Max: 22859.09Min: 22622.46 / Avg: 22741.06 / Max: 22813.25Min: 22572.83 / Avg: 22686.63 / Max: 22749.851. (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: 50 - Mode: Read Write - Average Latency1230.50811.01621.52432.03242.5405SE +/- 0.031, N = 12SE +/- 0.006, N = 3SE +/- 0.006, N = 32.2582.1992.2051. (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: 50 - Mode: Read Write - Average Latency123246810Min: 2.19 / Avg: 2.26 / Max: 2.48Min: 2.19 / Avg: 2.2 / Max: 2.21Min: 2.2 / Avg: 2.21 / Max: 2.221. (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 Write1237K14K21K28K35KSE +/- 30.01, N = 3SE +/- 446.01, N = 15SE +/- 66.14, N = 33090029853310451. (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 Write1235K10K15K20K25KMin: 30851.53 / Avg: 30899.66 / Max: 30954.79Min: 26339.54 / Avg: 29852.66 / Max: 31137.06Min: 30967.04 / Avg: 31045.25 / Max: 31176.741. (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 Latency1230.75741.51482.27223.02963.787SE +/- 0.003, N = 3SE +/- 0.053, N = 15SE +/- 0.007, N = 33.2413.3663.2251. (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 Latency123246810Min: 3.24 / Avg: 3.24 / Max: 3.25Min: 3.22 / Avg: 3.37 / Max: 3.8Min: 3.21 / Avg: 3.23 / Max: 3.231. (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 Write1237K14K21K28K35KSE +/- 70.03, N = 3SE +/- 321.69, N = 12SE +/- 386.16, N = 63317832452327111. (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 Write1236K12K18K24K30KMin: 33094.41 / Avg: 33177.7 / Max: 33316.87Min: 30049.77 / Avg: 32452.04 / Max: 33257.6Min: 30954.05 / Avg: 32710.66 / Max: 33398.411. (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 Latency123246810SE +/- 0.016, N = 3SE +/- 0.080, N = 12SE +/- 0.094, N = 67.5447.7227.6581. (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 Latency1233691215Min: 7.51 / Avg: 7.54 / Max: 7.56Min: 7.53 / Avg: 7.72 / Max: 8.33Min: 7.49 / Avg: 7.66 / Max: 8.091. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm