pgbench-pi3-1to1000-1-v1

ARMv7 Cortex-A53 testing with a BCM2835 Raspberry Pi 3 Model B Rev 1.2 and BCM2708 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 2101214-HA-PGBENCHPI16
Jump To Table - Results

Statistics

Remove Outliers Before Calculating Averages

Graph Settings

Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
pgbench-pi3-1to1000-1-v1
January 21 2021
  8 Hours, 43 Minutes
Only show results matching title/arguments (delimit multiple options with a comma):
Do not show results matching title/arguments (delimit multiple options with a comma):

pgbench-pi3-1to1000-1-v1

Processor: ARMv7 Cortex-A53 @ 1.20GHz (4 Cores), Motherboard: BCM2835 Raspberry Pi 3 Model B Rev 1.2, Memory: 925MB, Disk: 64GB SC64G, Graphics: BCM2708

OS: Raspbian 10, Kernel: 5.4.51-v7+ (armv7l), Desktop: LXDE, Display Server: X Server 1.20.4, Compiler: GCC 8.3.0 + Clang 7.0.1-8+rpi3+deb10u2, File-System: ext4, Screen Resolution: 720x480

Kernel Notes: snd_bcm2835.enable_compat_alsa=0 snd_bcm2835.enable_hdmi=1 snd_bcm2835.enable_headphones=1
Compiler Notes: --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 Notes: Scaling Governor: cpufreq-dt ondemand

pgbench-pi3-1to1000-1-v1OpenBenchmarking.orgPhoronix Test SuiteARMv7 Cortex-A53 @ 1.20GHz (4 Cores)BCM2835 Raspberry Pi 3 Model B Rev 1.2925MB64GB SC64GBCM2708Raspbian 105.4.51-v7+ (armv7l)LXDEX Server 1.20.4GCC 8.3.0 + Clang 7.0.1-8+rpi3+deb10u2ext4720x480ProcessorMotherboardMemoryDiskGraphicsOSKernelDesktopDisplay ServerCompilerFile-SystemScreen ResolutionPgbench-pi3-1to1000-1-v1 BenchmarksSystem Logs- snd_bcm2835.enable_compat_alsa=0 snd_bcm2835.enable_hdmi=1 snd_bcm2835.enable_headphones=1 - --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 - Scaling Governor: cpufreq-dt ondemand

pgbench-pi3-1to1000-1-v1pgbench: 1 - 1 - Read Onlypgbench: 1 - 1 - Read Only - Average Latencypgbench: 100 - 1 - Read Onlypgbench: 100 - 1 - Read Only - Average Latencypgbench: 1000 - 1 - Read Onlypgbench: 1000 - 1 - Read Only - Average Latencypgbench-pi3-1to1000-1-v135640.2816311.5854042.479OpenBenchmarking.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: 1 - Mode: Read Onlypgbench-pi3-1to1000-1-v18001600240032004000SE +/- 36.66, N = 535641. (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: 1 - Mode: Read Only - Average Latencypgbench-pi3-1to1000-1-v10.06320.12640.18960.25280.316SE +/- 0.003, N = 50.2811. (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: 1 - Mode: Read Onlypgbench-pi3-1to1000-1-v1140280420560700SE +/- 6.91, N = 36311. (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: 1 - Mode: Read Only - Average Latencypgbench-pi3-1to1000-1-v10.35660.71321.06981.42641.783SE +/- 0.017, N = 31.5851. (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: 1 - Mode: Read Onlypgbench-pi3-1to1000-1-v190180270360450SE +/- 4.95, N = 34041. (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: 1 - Mode: Read Only - Average Latencypgbench-pi3-1to1000-1-v10.55781.11561.67342.23122.789SE +/- 0.030, N = 32.4791. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

pgbench-pi3-1to1000-1-v1

Processor: ARMv7 Cortex-A53 @ 1.20GHz (4 Cores), Motherboard: BCM2835 Raspberry Pi 3 Model B Rev 1.2, Memory: 925MB, Disk: 64GB SC64G, Graphics: BCM2708

OS: Raspbian 10, Kernel: 5.4.51-v7+ (armv7l), Desktop: LXDE, Display Server: X Server 1.20.4, Compiler: GCC 8.3.0 + Clang 7.0.1-8+rpi3+deb10u2, File-System: ext4, Screen Resolution: 720x480

Kernel Notes: snd_bcm2835.enable_compat_alsa=0 snd_bcm2835.enable_hdmi=1 snd_bcm2835.enable_headphones=1
Compiler Notes: --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 Notes: Scaling Governor: cpufreq-dt ondemand

Testing initiated at 21 January 2021 12:11 by user pi.