0xO1-pts-pgbench-nightcrawler

AMD Ryzen 3 2200G testing with a ASUS ROG STRIX B450-F GAMING (3003 BIOS) and ASUS AMD Radeon Vega / Mobile 2GB 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 2111266-TJ-0XO1PTSPG50
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
Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780
November 24 2021
  12 Hours, 37 Minutes
Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686
November 24 2021
  2 Days, 23 Hours, 22 Minutes
Invert Hiding All Results Option
  1 Day, 18 Hours
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):


0xO1-pts-pgbench-nightcrawlerOpenBenchmarking.orgPhoronix Test SuiteAMD Ryzen 3 2200G @ 3.50GHz (4 Cores)ASUS ROG STRIX B450-F GAMING (3003 BIOS)AMD Raven/Raven230GB2048GB T-FORCE TM8FP8002TASUS AMD Radeon Vega / Mobile 2GB (1100/1067MHz)AMD Raven/Raven2/FenghuangSceptre C27Intel I211Ubuntu 20.045.11.0-40-generic (x86_64)GNOME Shell 3.36.9X Server 1.20.11GCC 9.3.0ext41920x1080ProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay ServerCompilerFile-SystemScreen Resolution0xO1-pts-pgbench-nightcrawler BenchmarksSystem Logs- Transparent Huge Pages: madvise- --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-HskZEa/gcc-9-9.3.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 - Scaling Governor: acpi-cpufreq ondemand (Boost: Enabled) - CPU Microcode: 0x8101016 - 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 STIBP: disabled RSB filling + srbds: Not affected + tsx_async_abort: Not affected

Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780 vs. Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686 ComparisonPhoronix Test SuiteBaseline+1.6%+1.6%+3.2%+3.2%+4.8%+4.8%+6.4%+6.4%6.5%6.5%3.3%2.5%2.4%2.3%2.1%2.1%1000 - 500 - Read Only1000 - 500 - Read Only - Average Latency1000 - 50 - Read Write4.9%1000 - 50 - Read Write - Average Latency4.9%1000 - 1 - Read Only - Average Latency100 - 100 - Read Write - Average Latency100 - 100 - Read Write1000 - 1 - Read Only1000 - 250 - Read Only1000 - 250 - Read Only - Average LatencyPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686

0xO1-pts-pgbench-nightcrawlerpgbench: 1 - 1 - Read Onlypgbench: 1 - 1 - Read Only - Average Latencypgbench: 1 - 1 - Read Writepgbench: 1 - 1 - Read Write - Average Latencypgbench: 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 - 500 - Read Onlypgbench: 1 - 500 - Read Only - Average Latencypgbench: 100 - 1 - Read Onlypgbench: 100 - 1 - Read Only - Average Latencypgbench: 1 - 100 - Read Writepgbench: 1 - 100 - Read Write - Average Latencypgbench: 1 - 250 - Read Writepgbench: 1 - 250 - Read Write - Average Latencypgbench: 1 - 500 - Read Writepgbench: 1 - 500 - Read Write - Average Latencypgbench: 100 - 1 - Read Writepgbench: 100 - 1 - Read Write - Average Latencypgbench: 100 - 50 - Read Onlypgbench: 100 - 50 - Read Only - Average Latencypgbench: 1000 - 1 - Read Onlypgbench: 1000 - 1 - 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: 100 - 500 - Read Onlypgbench: 100 - 500 - Read Only - Average Latencypgbench: 1000 - 1 - Read Writepgbench: 1000 - 1 - Read Write - Average Latencypgbench: 1000 - 50 - Read Onlypgbench: 1000 - 50 - Read Only - Average Latencypgbench: 10000 - 1 - Read Onlypgbench: 10000 - 1 - Read Only - Average Latencypgbench: 100 - 100 - Read Writepgbench: 100 - 100 - Read Write - Average Latencypgbench: 100 - 250 - Read Writepgbench: 100 - 250 - Read Write - Average Latencypgbench: 100 - 500 - Read Writepgbench: 100 - 500 - 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 - 500 - Read Onlypgbench: 1000 - 500 - Read Only - Average Latencypgbench: 10000 - 1 - Read Writepgbench: 10000 - 1 - Read Write - Average Latencypgbench: 10000 - 50 - Read Onlypgbench: 10000 - 50 - Read Only - Average Latencypgbench: 1000 - 100 - Read Writepgbench: 1000 - 100 - Read Write - Average Latencypgbench: 1000 - 250 - Read Writepgbench: 1000 - 250 - Read Write - Average Latencypgbench: 1000 - 500 - Read Writepgbench: 1000 - 500 - Read Write - Average Latencypgbench: 10000 - 100 - Read Onlypgbench: 10000 - 100 - Read Only - Average Latencypgbench: 10000 - 250 - Read Onlypgbench: 10000 - 250 - Read Only - Average Latencypgbench: 10000 - 50 - Read Writepgbench: 10000 - 50 - Read Write - Average Latencypgbench: 10000 - 500 - Read Onlypgbench: 10000 - 500 - Read Only - Average Latencypgbench: 10000 - 100 - Read Writepgbench: 10000 - 100 - Read Write - Average Latencypgbench: 10000 - 250 - Read Writepgbench: 10000 - 250 - Read Write - Average Latencypgbench: 10000 - 500 - Read Writepgbench: 10000 - 500 - Read Write - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686133460.07512940.773445561.122428682.333396406.308179227.8953808113.130126880.079151965.8341008248.083555901.72412000.833418681.194106060.095398712.508361086.92460388.2813405614.68311630.860361501.38325280.396547718.290504249.5864437112.699352012.841319307.83053349.3772402020.818132560.07512910.775443481.128428732.332396456.306179727.8193840413.020126890.079150666.409991252.220546916.22011990.834421711.186108470.092394992.532364416.86160098.3223426814.59211690.856362441.38024970.401560617.844507449.2724465112.011350122.856326157.66650859.8322559119.5417721.297222282.250523919.090506549.3604921101.607223764.4692026412.342355815.5021626830.737362628.697343674.8683487144.502OpenBenchmarking.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 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956863K6K9K12K15KSE +/- 123.94, N = 3SE +/- 21.33, N = 313346132561. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956862K4K6K8K10KMin: 13168.26 / Avg: 13346.02 / Max: 13584.5Min: 13223.71 / Avg: 13256.47 / Max: 13296.531. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956860.01690.03380.05070.06760.0845SE +/- 0.001, N = 3SE +/- 0.000, N = 30.0750.0751. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-163779568612345Min: 0.07 / 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 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read WriteDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-163779568630060090012001500SE +/- 2.77, N = 3SE +/- 1.23, N = 3129412911. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read WriteDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956862004006008001000Min: 1289.51 / Avg: 1294.06 / Max: 1299.08Min: 1288.42 / Avg: 1290.67 / Max: 1292.661. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956860.17440.34880.52320.69760.872SE +/- 0.001, N = 3SE +/- 0.001, N = 30.7730.7751. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686246810Min: 0.77 / Avg: 0.77 / Max: 0.78Min: 0.77 / Avg: 0.78 / Max: 0.781. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 50 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-163779568610K20K30K40K50KSE +/- 445.31, N = 3SE +/- 278.40, N = 344556443481. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 50 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956868K16K24K32K40KMin: 44029.77 / Avg: 44556.12 / Max: 45441.48Min: 44002.19 / Avg: 44347.76 / Max: 44898.651. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956860.25380.50760.76141.01521.269SE +/- 0.011, N = 3SE +/- 0.007, N = 31.1221.1281. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686246810Min: 1.1 / Avg: 1.12 / Max: 1.14Min: 1.11 / Avg: 1.13 / Max: 1.141. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 100 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956869K18K27K36K45KSE +/- 178.17, N = 3SE +/- 11.17, N = 342868428731. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 100 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956867K14K21K28K35KMin: 42523.46 / Avg: 42867.8 / Max: 43119.41Min: 42853.58 / Avg: 42873.1 / Max: 42892.271. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956860.52491.04981.57472.09962.6245SE +/- 0.010, N = 3SE +/- 0.001, N = 32.3332.3321. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686246810Min: 2.32 / Avg: 2.33 / Max: 2.35Min: 2.33 / Avg: 2.33 / Max: 2.331. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 250 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956868K16K24K32K40KSE +/- 384.22, N = 3SE +/- 190.02, N = 339640396451. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 250 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956867K14K21K28K35KMin: 39009.59 / Avg: 39640.05 / Max: 40335.76Min: 39317.28 / Avg: 39644.84 / Max: 39975.521. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686246810SE +/- 0.061, N = 3SE +/- 0.030, N = 36.3086.3061. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956863691215Min: 6.2 / Avg: 6.31 / Max: 6.41Min: 6.25 / Avg: 6.31 / Max: 6.361. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 50 - Mode: Read WriteDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686400800120016002000SE +/- 4.48, N = 3SE +/- 3.22, N = 3179217971. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 50 - Mode: Read WriteDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-163779568630060090012001500Min: 1783.52 / Avg: 1792.49 / Max: 1796.98Min: 1793.6 / Avg: 1797.38 / Max: 1803.781. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686714212835SE +/- 0.07, N = 3SE +/- 0.05, N = 327.9027.821. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686612182430Min: 27.83 / Avg: 27.89 / Max: 28.03Min: 27.72 / Avg: 27.82 / Max: 27.881. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 500 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956868K16K24K32K40KSE +/- 78.91, N = 3SE +/- 123.04, N = 338081384041. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 500 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956867K14K21K28K35KMin: 37969.83 / Avg: 38080.89 / Max: 38233.52Min: 38231.25 / Avg: 38403.66 / Max: 38641.921. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956863691215SE +/- 0.03, N = 3SE +/- 0.04, N = 313.1313.021. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-163779568648121620Min: 13.08 / Avg: 13.13 / Max: 13.17Min: 12.94 / Avg: 13.02 / Max: 13.081. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 1 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956863K6K9K12K15KSE +/- 48.94, N = 3SE +/- 50.49, N = 312688126891. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 1 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956862K4K6K8K10KMin: 12607.01 / Avg: 12688.44 / Max: 12776.18Min: 12618.3 / Avg: 12689.31 / Max: 12786.991. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956860.01780.03560.05340.07120.089SE +/- 0.000, N = 3SE +/- 0.000, N = 30.0790.0791. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-163779568612345Min: 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 14.0Scaling Factor: 1 - Clients: 100 - Mode: Read WriteDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-163779568630060090012001500SE +/- 4.43, N = 3SE +/- 9.11, N = 3151915061. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 100 - Mode: Read WriteDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-163779568630060090012001500Min: 1511.46 / Avg: 1519 / Max: 1526.8Min: 1488.72 / Avg: 1505.93 / Max: 1519.731. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956861530456075SE +/- 0.19, N = 3SE +/- 0.40, N = 365.8366.411. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956861326395265Min: 65.5 / Avg: 65.83 / Max: 66.16Min: 65.8 / Avg: 66.41 / Max: 67.171. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 250 - Mode: Read WriteDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956862004006008001000SE +/- 4.70, N = 3SE +/- 9.44, N = 310089911. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 250 - Mode: Read WriteDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956862004006008001000Min: 998.69 / Avg: 1007.77 / Max: 1014.44Min: 975.01 / Avg: 991.38 / Max: 1007.721. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-163779568660120180240300SE +/- 1.16, N = 3SE +/- 2.40, N = 3248.08252.221. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-163779568650100150200250Min: 246.44 / Avg: 248.08 / Max: 250.33Min: 248.08 / Avg: 252.22 / Max: 256.411. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 500 - Mode: Read WriteDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686120240360480600SE +/- 5.91, N = 12SE +/- 4.61, N = 125555461. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 500 - Mode: Read WriteDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686100200300400500Min: 521.52 / Avg: 555.18 / Max: 597.99Min: 520.09 / Avg: 546.15 / Max: 576.051. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956862004006008001000SE +/- 9.47, N = 12SE +/- 7.70, N = 12901.72916.221. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686160320480640800Min: 836.14 / Avg: 901.72 / Max: 958.73Min: 867.98 / Avg: 916.22 / Max: 961.361. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 1 - Mode: Read WriteDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-163779568630060090012001500SE +/- 2.77, N = 3SE +/- 2.30, N = 3120011991. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 1 - Mode: Read WriteDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956862004006008001000Min: 1195.24 / Avg: 1200.12 / Max: 1204.84Min: 1195.37 / Avg: 1199.25 / Max: 1203.331. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956860.18770.37540.56310.75080.9385SE +/- 0.002, N = 3SE +/- 0.002, N = 30.8330.8341. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686246810Min: 0.83 / Avg: 0.83 / Max: 0.84Min: 0.83 / Avg: 0.83 / Max: 0.841. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 50 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956869K18K27K36K45KSE +/- 232.40, N = 3SE +/- 118.12, N = 341868421711. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 50 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956867K14K21K28K35KMin: 41553.18 / Avg: 41868.39 / Max: 42321.81Min: 41940.85 / Avg: 42170.95 / Max: 42332.361. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956860.26870.53740.80611.07481.3435SE +/- 0.007, N = 3SE +/- 0.003, N = 31.1941.1861. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686246810Min: 1.18 / Avg: 1.19 / Max: 1.2Min: 1.18 / Avg: 1.19 / Max: 1.191. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 1 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956862K4K6K8K10KSE +/- 171.82, N = 9SE +/- 23.64, N = 310606108471. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 1 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956862K4K6K8K10KMin: 9251.4 / Avg: 10606.01 / Max: 10911.75Min: 10809.63 / Avg: 10846.74 / Max: 10890.681. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956860.02140.04280.06420.08560.107SE +/- 0.002, N = 9SE +/- 0.000, N = 30.0950.0921. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-163779568612345Min: 0.09 / Avg: 0.09 / Max: 0.11Min: 0.09 / Avg: 0.09 / Max: 0.091. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 100 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956869K18K27K36K45KSE +/- 108.95, N = 3SE +/- 300.83, N = 339871394991. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 100 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956867K14K21K28K35KMin: 39696.66 / Avg: 39871.12 / Max: 40071.4Min: 38899.69 / Avg: 39498.57 / Max: 39848.121. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956860.56971.13941.70912.27882.8485SE +/- 0.007, N = 3SE +/- 0.019, N = 32.5082.5321. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686246810Min: 2.5 / Avg: 2.51 / Max: 2.52Min: 2.51 / Avg: 2.53 / Max: 2.571. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 250 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956868K16K24K32K40KSE +/- 26.21, N = 3SE +/- 70.81, N = 336108364411. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 250 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956866K12K18K24K30KMin: 36069.13 / Avg: 36108.04 / Max: 36157.91Min: 36331.73 / Avg: 36441.08 / Max: 36573.71. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686246810SE +/- 0.005, N = 3SE +/- 0.013, N = 36.9246.8611. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956863691215Min: 6.91 / Avg: 6.92 / Max: 6.93Min: 6.84 / Avg: 6.86 / Max: 6.881. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 50 - Mode: Read WriteDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-163779568613002600390052006500SE +/- 8.94, N = 3SE +/- 6.22, N = 3603860091. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 50 - Mode: Read WriteDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-163779568610002000300040005000Min: 6022.41 / Avg: 6037.8 / Max: 6053.39Min: 5996.19 / Avg: 6008.59 / Max: 6015.671. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686246810SE +/- 0.012, N = 3SE +/- 0.009, N = 38.2818.3221. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956863691215Min: 8.26 / Avg: 8.28 / Max: 8.3Min: 8.31 / Avg: 8.32 / Max: 8.341. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 500 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956867K14K21K28K35KSE +/- 197.78, N = 3SE +/- 195.44, N = 334056342681. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 500 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956866K12K18K24K30KMin: 33751.17 / Avg: 34056.15 / Max: 34426.79Min: 33888.23 / Avg: 34268.21 / Max: 34537.551. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-163779568648121620SE +/- 0.08, N = 3SE +/- 0.08, N = 314.6814.591. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-163779568648121620Min: 14.52 / Avg: 14.68 / Max: 14.81Min: 14.48 / Avg: 14.59 / Max: 14.751. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 1 - Mode: Read WriteDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-163779568630060090012001500SE +/- 2.46, N = 3SE +/- 1.07, N = 3116311691. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 1 - Mode: Read WriteDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956862004006008001000Min: 1158.3 / Avg: 1162.93 / Max: 1166.71Min: 1167.2 / Avg: 1168.53 / Max: 1170.651. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956860.19350.3870.58050.7740.9675SE +/- 0.002, N = 3SE +/- 0.001, N = 30.8600.8561. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686246810Min: 0.86 / Avg: 0.86 / Max: 0.86Min: 0.85 / Avg: 0.86 / Max: 0.861. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 50 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956868K16K24K32K40KSE +/- 254.98, N = 3SE +/- 151.24, N = 336150362441. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 50 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956866K12K18K24K30KMin: 35862.08 / Avg: 36150.24 / Max: 36658.69Min: 35962.52 / Avg: 36243.52 / Max: 36480.981. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956860.31120.62240.93361.24481.556SE +/- 0.010, N = 3SE +/- 0.006, N = 31.3831.3801. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686246810Min: 1.36 / Avg: 1.38 / Max: 1.39Min: 1.37 / Avg: 1.38 / Max: 1.391. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 10000 - Clients: 1 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956865001000150020002500SE +/- 8.29, N = 3SE +/- 32.77, N = 9252824971. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 10000 - Clients: 1 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686400800120016002000Min: 2513.19 / Avg: 2527.57 / Max: 2541.91Min: 2364.5 / Avg: 2496.77 / Max: 2597.121. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 10000 - Clients: 1 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956860.09020.18040.27060.36080.451SE +/- 0.001, N = 3SE +/- 0.005, N = 90.3960.4011. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 10000 - Clients: 1 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-163779568612345Min: 0.39 / Avg: 0.4 / Max: 0.4Min: 0.39 / Avg: 0.4 / Max: 0.421. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 100 - Mode: Read WriteDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-163779568612002400360048006000SE +/- 67.57, N = 12SE +/- 64.85, N = 4547756061. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 100 - Mode: Read WriteDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-163779568610002000300040005000Min: 4945.89 / Avg: 5477.41 / Max: 5662.43Min: 5473.76 / Avg: 5606.28 / Max: 5772.11. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686510152025SE +/- 0.24, N = 12SE +/- 0.20, N = 418.2917.841. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686510152025Min: 17.66 / Avg: 18.29 / Max: 20.22Min: 17.33 / Avg: 17.84 / Max: 18.271. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 250 - Mode: Read WriteDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-163779568611002200330044005500SE +/- 30.10, N = 3SE +/- 14.70, N = 3504250741. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 250 - Mode: Read WriteDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956869001800270036004500Min: 4990.19 / Avg: 5042.07 / Max: 5094.44Min: 5046.84 / Avg: 5073.97 / Max: 5097.351. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956861122334455SE +/- 0.30, N = 3SE +/- 0.14, N = 349.5949.271. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956861020304050Min: 49.07 / Avg: 49.59 / Max: 50.1Min: 49.05 / Avg: 49.27 / Max: 49.541. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 500 - Mode: Read WriteDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-163779568610002000300040005000SE +/- 15.14, N = 3SE +/- 49.91, N = 3443744651. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 500 - Mode: Read WriteDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956868001600240032004000Min: 4407.53 / Avg: 4436.72 / Max: 4458.32Min: 4366.52 / Avg: 4464.97 / Max: 4528.461. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686306090120150SE +/- 0.39, N = 3SE +/- 1.26, N = 3112.70112.011. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-163779568620406080100Min: 112.15 / Avg: 112.7 / Max: 113.44Min: 110.41 / Avg: 112.01 / Max: 114.511. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 100 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956868K16K24K32K40KSE +/- 245.81, N = 3SE +/- 76.72, N = 335201350121. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 100 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956866K12K18K24K30KMin: 34855.08 / Avg: 35200.54 / Max: 35676.2Min: 34863.28 / Avg: 35011.61 / Max: 35119.771. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956860.64261.28521.92782.57043.213SE +/- 0.020, N = 3SE +/- 0.006, N = 32.8412.8561. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686246810Min: 2.8 / Avg: 2.84 / Max: 2.87Min: 2.85 / Avg: 2.86 / Max: 2.871. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 250 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956867K14K21K28K35KSE +/- 113.49, N = 3SE +/- 173.43, N = 331930326151. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 250 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956866K12K18K24K30KMin: 31742.87 / Avg: 31929.61 / Max: 32134.71Min: 32366.08 / Avg: 32615.24 / Max: 32948.81. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686246810SE +/- 0.028, N = 3SE +/- 0.040, N = 37.8307.6661. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956863691215Min: 7.78 / Avg: 7.83 / Max: 7.88Min: 7.59 / Avg: 7.67 / Max: 7.721. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 50 - Mode: Read WriteDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-163779568611002200330044005500SE +/- 68.80, N = 3SE +/- 17.20, N = 3533450851. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 50 - Mode: Read WriteDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956869001800270036004500Min: 5234.61 / Avg: 5334.18 / Max: 5466.2Min: 5062.85 / Avg: 5085.38 / Max: 5119.161. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956863691215SE +/- 0.120, N = 3SE +/- 0.033, N = 39.3779.8321. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956863691215Min: 9.15 / Avg: 9.38 / Max: 9.55Min: 9.77 / Avg: 9.83 / Max: 9.881. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 500 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956865K10K15K20K25KSE +/- 177.13, N = 3SE +/- 230.54, N = 324020255911. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 500 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956864K8K12K16K20KMin: 23677.91 / Avg: 24020.37 / Max: 24270.15Min: 25297.39 / Avg: 25591 / Max: 26045.681. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686510152025SE +/- 0.15, N = 3SE +/- 0.17, N = 320.8219.541. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637758780Desktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686510152025Min: 20.6 / Avg: 20.82 / Max: 21.12Min: 19.2 / Avg: 19.54 / Max: 19.771. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 10000 - Clients: 1 - Mode: Read WriteDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686170340510680850SE +/- 9.15, N = 97721. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 10000 - Clients: 1 - Mode: Read Write - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956860.29180.58360.87541.16721.459SE +/- 0.015, N = 91.2971. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 10000 - Clients: 50 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956865K10K15K20K25KSE +/- 40.28, N = 3222281. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 10000 - Clients: 50 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956860.50631.01261.51892.02522.5315SE +/- 0.004, N = 32.2501. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 100 - Mode: Read WriteDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-163779568611002200330044005500SE +/- 28.83, N = 352391. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686510152025SE +/- 0.11, N = 319.091. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 250 - Mode: Read WriteDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-163779568611002200330044005500SE +/- 19.10, N = 350651. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956861122334455SE +/- 0.19, N = 349.361. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 500 - Mode: Read WriteDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-163779568611002200330044005500SE +/- 21.93, N = 349211. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-163779568620406080100SE +/- 0.45, N = 3101.611. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 10000 - Clients: 100 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956865K10K15K20K25KSE +/- 51.70, N = 3223761. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 10000 - Clients: 100 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956861.00552.0113.01654.0225.0275SE +/- 0.010, N = 34.4691. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 10000 - Clients: 250 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956864K8K12K16K20KSE +/- 292.30, N = 3202641. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 10000 - Clients: 250 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956863691215SE +/- 0.18, N = 312.341. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 10000 - Clients: 50 - Mode: Read WriteDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956868001600240032004000SE +/- 424.25, N = 635581. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 10000 - Clients: 50 - Mode: Read Write - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-163779568648121620SE +/- 2.49, N = 615.501. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 10000 - Clients: 500 - Mode: Read OnlyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956863K6K9K12K15KSE +/- 70.70, N = 3162681. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 10000 - Clients: 500 - Mode: Read Only - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686714212835SE +/- 0.13, N = 330.741. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 10000 - Clients: 100 - Mode: Read WriteDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956868001600240032004000SE +/- 248.74, N = 936261. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 10000 - Clients: 100 - Mode: Read Write - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686714212835SE +/- 2.05, N = 928.701. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 10000 - Clients: 250 - Mode: Read WriteDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956867001400210028003500SE +/- 203.84, N = 934361. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 10000 - Clients: 250 - Mode: Read Write - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-163779568620406080100SE +/- 4.51, N = 974.871. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 10000 - Clients: 500 - Mode: Read WriteDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-16377956867001400210028003500SE +/- 104.40, N = 934871. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 10000 - Clients: 500 - Mode: Read Write - Average LatencyDesktop-x86_64-Ubuntu-20.04-pts-pgbench-nightcrawler-1637795686306090120150SE +/- 4.58, N = 9144.501. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

80 Results Shown

PostgreSQL pgbench:
  1 - 1 - Read Only
  1 - 1 - Read Only - Average Latency
  1 - 1 - Read Write
  1 - 1 - Read Write - Average Latency
  1 - 50 - Read Only
  1 - 50 - Read Only - Average Latency
  1 - 100 - Read Only
  1 - 100 - Read Only - Average Latency
  1 - 250 - Read Only
  1 - 250 - Read Only - Average Latency
  1 - 50 - Read Write
  1 - 50 - Read Write - Average Latency
  1 - 500 - Read Only
  1 - 500 - Read Only - Average Latency
  100 - 1 - Read Only
  100 - 1 - Read Only - Average Latency
  1 - 100 - Read Write
  1 - 100 - Read Write - Average Latency
  1 - 250 - Read Write
  1 - 250 - Read Write - Average Latency
  1 - 500 - Read Write
  1 - 500 - Read Write - Average Latency
  100 - 1 - Read Write
  100 - 1 - Read Write - Average Latency
  100 - 50 - Read Only
  100 - 50 - Read Only - Average Latency
  1000 - 1 - Read Only
  1000 - 1 - Read Only - Average Latency
  100 - 100 - Read Only
  100 - 100 - Read Only - Average Latency
  100 - 250 - Read Only
  100 - 250 - Read Only - Average Latency
  100 - 50 - Read Write
  100 - 50 - Read Write - Average Latency
  100 - 500 - Read Only
  100 - 500 - Read Only - Average Latency
  1000 - 1 - Read Write
  1000 - 1 - Read Write - Average Latency
  1000 - 50 - Read Only
  1000 - 50 - Read Only - Average Latency
  10000 - 1 - Read Only
  10000 - 1 - Read Only - Average Latency
  100 - 100 - Read Write
  100 - 100 - Read Write - Average Latency
  100 - 250 - Read Write
  100 - 250 - Read Write - Average Latency
  100 - 500 - Read Write
  100 - 500 - Read Write - Average Latency
  1000 - 100 - Read Only
  1000 - 100 - Read Only - Average Latency
  1000 - 250 - Read Only
  1000 - 250 - Read Only - Average Latency
  1000 - 50 - Read Write
  1000 - 50 - Read Write - Average Latency
  1000 - 500 - Read Only
  1000 - 500 - Read Only - Average Latency
  10000 - 1 - Read Write
  10000 - 1 - Read Write - Average Latency
  10000 - 50 - Read Only
  10000 - 50 - Read Only - Average Latency
  1000 - 100 - Read Write
  1000 - 100 - Read Write - Average Latency
  1000 - 250 - Read Write
  1000 - 250 - Read Write - Average Latency
  1000 - 500 - Read Write
  1000 - 500 - Read Write - Average Latency
  10000 - 100 - Read Only
  10000 - 100 - Read Only - Average Latency
  10000 - 250 - Read Only
  10000 - 250 - Read Only - Average Latency
  10000 - 50 - Read Write
  10000 - 50 - Read Write - Average Latency
  10000 - 500 - Read Only
  10000 - 500 - Read Only - Average Latency
  10000 - 100 - Read Write
  10000 - 100 - Read Write - Average Latency
  10000 - 250 - Read Write
  10000 - 250 - Read Write - Average Latency
  10000 - 500 - Read Write
  10000 - 500 - Read Write - Average Latency