pgbench_100-50-all

ARMv7 Cortex-A72 testing on Raspbian 10 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2102207-HA-2102200HA03&grs.

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

pgbench_100-50-allpgbench: 100 - 50 - Read Onlypgbench: 100 - 50 - Read Only - Average Latencypgbench: 100 - 50 - Read Write - Average Latencypgbench: 100 - 50 - Read Writeginnyhermionespeedy80046.25240.255124366777.49554.04092691665.462336.742167OpenBenchmarking.org

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 50 - Mode: Read Only

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

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency

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

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency

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

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 50 - Mode: Read Write

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

Phoronix Test Suite v10.8.4