floop

ARMv8 Cortex-A72 testing on Debian 12 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2402256-NE-2402252NE49.

floopProcessorMotherboardChipsetMemoryDiskOSKernelCompilerFile-SystemScreen Resolutionfloop_1freebsd_debian_postgresql_comparisonARM Cortex-A72 r0p3 @ 1.50GHz (4 Cores)Unknown ProductBroadcom BCM2711 PCIe Bridge2048MB26GBFreeBSD14.0-RELEASE-p5 (arm64)Clang 16.0.6ufs592x448ARMv8 Cortex-A72 @ 1.50GHz (4 Cores)Raspberry Pi 4 Model B Rev 1.2Broadcom BCM271132GB SN32GDebian 126.1.0-rpi8-rpi-v8 (aarch64)GCC 12.2.0ext4OpenBenchmarking.orgKernel Details- freebsd_debian_postgresql_comparison: snd_bcm2835.enable_headphones=0 snd_bcm2835.enable_headphones=1 snd_bcm2835.enable_hdmi=1 snd_bcm2835.enable_hdmi=0 Compiler Details- freebsd_debian_postgresql_comparison: --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 Processor Details- freebsd_debian_postgresql_comparison: Scaling Governor: cpufreq-dt performanceSecurity Details- freebsd_debian_postgresql_comparison: gather_data_sampling: Not affected + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_rstack_overflow: Not affected + spec_store_bypass: Vulnerable + spectre_v1: Mitigation of __user pointer sanitization + spectre_v2: Vulnerable + srbds: Not affected + tsx_async_abort: Not affected

flooppgbench: 100 - 50 - Read Onlypgbench: 100 - 50 - Read Only - Average Latencypgbench: 100 - 50 - Read Writepgbench: 100 - 50 - Read Write - Average Latencyfloop_1freebsd_debian_postgresql_comparison59684.032303164.893281917.79150499.237OpenBenchmarking.org

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 50 - Mode: Read Onlyfloop_1freebsd_debian_postgresql_comparison6001200180024003000SE +/- 7.17, N = 9SE +/- 54.06, N = 95962819

PostgreSQL

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latencyfloop_1freebsd_debian_postgresql_comparison20406080100SE +/- 1.05, N = 9SE +/- 0.35, N = 984.0317.79

PostgreSQL

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 50 - Mode: Read Writefloop_1freebsd_debian_postgresql_comparison110220330440550SE +/- 2.35, N = 3SE +/- 5.84, N = 9303504

PostgreSQL

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

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latencyfloop_1freebsd_debian_postgresql_comparison4080120160200SE +/- 1.27, N = 3SE +/- 1.14, N = 9164.8999.24

Phoronix Test Suite v10.8.4