pgbench_100-50-all

ARMv7 Cortex-A72 testing on Raspbian 10 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 2102207-HA-2102200HA03
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
Perf-Per
Dollar
Date
Triggered
  Test
  Duration
ginny
February 20
  17 Minutes
hermione
February 20
  17 Minutes
speedy
February 20
  11 Hours, 48 Minutes
Invert Hiding All Results Option
  4 Hours, 8 Minutes
Only show results where is faster than
Only show results matching title/arguments (delimit multiple options with a comma):


pgbench_100-50-allProcessorMotherboardMemoryDiskOSKernelCompilerFile-SystemSystem LayerDisplay ServerginnyhermionespeedyARMv8 Cortex-A72 @ 1.80GHz (4 Cores)BCM2835 Raspberry Pi 4 Model B Rev 1.48GB500GB Portable SSD T5Ubuntu 20.105.8.0-1015-raspi (aarch64)GCC 10.2.0ext4lxcbtrfsARMv7 Cortex-A72 @ 1.80GHz (4 Cores)BCM2711 Raspberry Pi 4 Model B Rev 1.24096MB16GB SL16GRaspbian 105.10.11-v7l+ (armv7l)X Server 1.20.4GCC 8.3.0ext4OpenBenchmarking.orgKernel Details- ginny: snd_bcm2835.enable_compat_alsa=0 snd_bcm2835.enable_hdmi=1 snd_bcm2835.enable_headphones=1- hermione: snd_bcm2835.enable_compat_alsa=0 snd_bcm2835.enable_hdmi=1 snd_bcm2835.enable_headphones=1- speedy: snd_bcm2835.enable_compat_alsa=0 snd_bcm2835.enable_hdmi=1Compiler Details- ginny: --build=aarch64-linux-gnu --disable-libquadmath --disable-libquadmath-support --disable-werror --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-fix-cortex-a53-843419 --enable-gnu-unique-object --enable-languages=c,ada,c++,go,d,fortran,objc,obj-c++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-nls --enable-objc-gc=auto --enable-plugin --enable-shared --enable-threads=posix --host=aarch64-linux-gnu --program-prefix=aarch64-linux-gnu- --target=aarch64-linux-gnu --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-target-system-zlib=auto -v - hermione: --build=aarch64-linux-gnu --disable-libquadmath --disable-libquadmath-support --disable-werror --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-fix-cortex-a53-843419 --enable-gnu-unique-object --enable-languages=c,ada,c++,go,d,fortran,objc,obj-c++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-nls --enable-objc-gc=auto --enable-plugin --enable-shared --enable-threads=posix --host=aarch64-linux-gnu --program-prefix=aarch64-linux-gnu- --target=aarch64-linux-gnu --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-target-system-zlib=auto -v - speedy: --build=arm-linux-gnueabihf --disable-libitm --disable-libquadmath --disable-libquadmath-support --disable-sjlj-exceptions --disable-werror --enable-bootstrap --enable-checking=release --enable-clocale=gnu --enable-gnu-unique-object --enable-languages=c,ada,c++,go,d,fortran,objc,obj-c++ --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-nls --enable-objc-gc=auto --enable-plugin --enable-shared --enable-threads=posix --host=arm-linux-gnueabihf --program-prefix=arm-linux-gnueabihf- --target=arm-linux-gnueabihf --with-arch=armv6 --with-default-libstdcxx-abi=new --with-float=hard --with-fpu=vfp --with-gcc-major-version-only --with-target-system-zlib -v Processor Details- Scaling Governor: cpufreq-dt ondemandSecurity Details- ginny, hermione: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Vulnerable + spectre_v1: Mitigation of __user pointer sanitization + spectre_v2: Vulnerable + srbds: Not affected + tsx_async_abort: Not affected

ginnyhermionespeedyResult OverviewPhoronix Test Suite 10.2.2100%284%468%652%837%PostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbenchPostgreSQL pgbench100 - 50 - Read Write - Average Latency100 - 50 - Read Write100 - 50 - Read Only100 - 50 - Read Only - Average Latency

pgbench_100-50-allpgbench: 100 - 50 - Read Onlypgbench: 100 - 50 - Read Only - Average Latencypgbench: 100 - 50 - Read Writepgbench: 100 - 50 - Read Write - Average Latencyginnyhermionespeedy80046.252124340.25566777.49592654.04091665.462167336.742OpenBenchmarking.org

PostgreSQL pgbench

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 50 - Mode: Read Onlyginnyhermionespeedy2K4K6K8K10KSE +/- 27.94, N = 3SE +/- 63.76, N = 3SE +/- 48.60, N = 38004667791661. (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 Onlyginnyhermionespeedy16003200480064008000Min: 7952.64 / Avg: 8003.73 / Max: 8048.87Min: 6602.65 / Avg: 6676.84 / Max: 6803.76Min: 9107.88 / Avg: 9165.59 / Max: 9262.191. (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 Latencyginnyhermionespeedy246810SE +/- 0.021, N = 3SE +/- 0.071, N = 3SE +/- 0.029, N = 36.2527.4955.4621. (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 Latencyginnyhermionespeedy3691215Min: 6.22 / Avg: 6.25 / Max: 6.29Min: 7.36 / Avg: 7.5 / Max: 7.58Min: 5.4 / Avg: 5.46 / Max: 5.51. (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 Writeginnyhermionespeedy30060090012001500SE +/- 2.68, N = 3SE +/- 10.03, N = 3SE +/- 18.50, N = 912439261671. (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 Writeginnyhermionespeedy2004006008001000Min: 1237.63 / Avg: 1242.81 / Max: 1246.56Min: 906.21 / Avg: 926.04 / Max: 938.51Min: 81.51 / Avg: 167.33 / Max: 242.671. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latencyginnyhermionespeedy70140210280350SE +/- 0.09, N = 3SE +/- 0.59, N = 3SE +/- 44.99, N = 940.2654.04336.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: 100 - Clients: 50 - Mode: Read Write - Average Latencyginnyhermionespeedy60120180240300Min: 40.13 / Avg: 40.26 / Max: 40.42Min: 53.31 / Avg: 54.04 / Max: 55.21Min: 206.26 / Avg: 336.74 / Max: 613.951. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm