usb2-sata-ext4-7200

DB performance testing by Filesystem on small ARM64 SBC

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 2106260-IB-USB2SATAE61
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
View Logs
Performance Per
Dollar
Date
Run
  Test
  Duration
db performance by filesystem: ext4 connected by usb2 SATA enclosure
June 26 2021
  3 Hours, 29 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):

db performance by filesystem: ext4 connected by usb2 SATA enclosure

Processor: ARMv8 Cortex-A72 @ 1.42GHz (6 Cores), Motherboard: Pine64 RockPro64 v2.1, Chipset: Fuzhou Rockchip RK3399, Memory: 4096MB, Disk: 4001GB HGST HDS5C4040AL + 8002GB HUH72808CLAR8000 + 4001GB + 2 x 8002GB 728080ALE600 + 31GB SD32G

OS: Gentoo/Linux, Kernel: 5.6.0-1137-ayufan-ge57f05e7bf8f (aarch64), Compiler: GCC 11.1.0, File-System: ext4

Compiler Notes: --bindir=/usr/aarch64-unknown-linux-gnu/gcc-bin/11.1.0 --build=aarch64-unknown-linux-gnu --datadir=/usr/share/gcc-data/aarch64-unknown-linux-gnu/11.1.0 --disable-esp --disable-fixed-point --disable-libada --disable-libssp --disable-libvtv --disable-multilib --disable-systemtap --disable-valgrind-annotations --disable-vtable-verify --disable-werror --enable-__cxa_atexit --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-default-ssp --enable-languages=c,c++,fortran --enable-libgomp --enable-libstdcxx-time --enable-lto --enable-nls --enable-obsolete --enable-secureplt --enable-shared --enable-threads=posix --host=aarch64-unknown-linux-gnu --includedir=/usr/lib/gcc/aarch64-unknown-linux-gnu/11.1.0/include --mandir=/usr/share/gcc-data/aarch64-unknown-linux-gnu/11.1.0/man --with-python-dir=/share/gcc-data/aarch64-unknown-linux-gnu/11.1.0/python --without-isl --without-zstd
Processor Notes: Scaling Governor: cpufreq-dt schedutil
Security Notes: 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 + tsx_async_abort: Not affected

usb2-sata-ext4-7200OpenBenchmarking.orgPhoronix Test SuiteARMv8 Cortex-A72 @ 1.42GHz (6 Cores)Pine64 RockPro64 v2.1Fuzhou Rockchip RK33994096MB4001GB HGST HDS5C4040AL + 8002GB HUH72808CLAR8000 + 4001GB + 2 x 8002GB 728080ALE600 + 31GB SD32GGentoo/Linux5.6.0-1137-ayufan-ge57f05e7bf8f (aarch64)GCC 11.1.0ext4ProcessorMotherboardChipsetMemoryDiskOSKernelCompilerFile-SystemUsb2-sata-ext4-7200 BenchmarksSystem Logs- --bindir=/usr/aarch64-unknown-linux-gnu/gcc-bin/11.1.0 --build=aarch64-unknown-linux-gnu --datadir=/usr/share/gcc-data/aarch64-unknown-linux-gnu/11.1.0 --disable-esp --disable-fixed-point --disable-libada --disable-libssp --disable-libvtv --disable-multilib --disable-systemtap --disable-valgrind-annotations --disable-vtable-verify --disable-werror --enable-__cxa_atexit --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-default-ssp --enable-languages=c,c++,fortran --enable-libgomp --enable-libstdcxx-time --enable-lto --enable-nls --enable-obsolete --enable-secureplt --enable-shared --enable-threads=posix --host=aarch64-unknown-linux-gnu --includedir=/usr/lib/gcc/aarch64-unknown-linux-gnu/11.1.0/include --mandir=/usr/share/gcc-data/aarch64-unknown-linux-gnu/11.1.0/man --with-python-dir=/share/gcc-data/aarch64-unknown-linux-gnu/11.1.0/python --without-isl --without-zstd - Scaling Governor: cpufreq-dt schedutil- 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 + tsx_async_abort: Not affected

usb2-sata-ext4-7200pgbench: 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 - 50 - Read Writepgbench: 1 - 50 - Read Write - Average Latencypgbench: 100 - 1 - Read Onlypgbench: 100 - 1 - Read Only - Average Latencypgbench: 100 - 1 - Read Writepgbench: 100 - 1 - Read Write - Average Latencypgbench: 100 - 50 - Read Onlypgbench: 100 - 50 - Read Only - Average Latencypgbench: 100 - 50 - Read Writepgbench: 100 - 50 - Read Write - Average Latencydb performance by filesystem: ext4 connected by usb2 SATA enclosure56220.1832405.582151473.304489103.8175717.5872441.58758861.414491014.692OpenBenchmarking.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 Onlydb performance by filesystem: ext4 connected by usb2 SATA enclosure12002400360048006000SE +/- 264.65, N = 1556221. (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 Latencydb performance by filesystem: ext4 connected by usb2 SATA enclosure0.04120.08240.12360.16480.206SE +/- 0.008, N = 150.1831. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 1 - Mode: Read Writedb performance by filesystem: ext4 connected by usb2 SATA enclosure50100150200250SE +/- 27.89, N = 122401. (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 Write - Average Latencydb performance by filesystem: ext4 connected by usb2 SATA enclosure1.2562.5123.7685.0246.28SE +/- 1.124, N = 125.5821. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 50 - Mode: Read Onlydb performance by filesystem: ext4 connected by usb2 SATA enclosure3K6K9K12K15KSE +/- 83.84, N = 3151471. (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: 50 - Mode: Read Only - Average Latencydb performance by filesystem: ext4 connected by usb2 SATA enclosure0.74341.48682.23022.97363.717SE +/- 0.018, N = 33.3041. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 50 - Mode: Read Writedb performance by filesystem: ext4 connected by usb2 SATA enclosure110220330440550SE +/- 15.03, N = 134891. (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: 50 - Mode: Read Write - Average Latencydb performance by filesystem: ext4 connected by usb2 SATA enclosure20406080100SE +/- 4.15, N = 13103.821. (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 Onlydb performance by filesystem: ext4 connected by usb2 SATA enclosure1326395265SE +/- 1.13, N = 9571. (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 Latencydb performance by filesystem: ext4 connected by usb2 SATA enclosure48121620SE +/- 0.34, N = 917.591. (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 Writedb performance by filesystem: ext4 connected by usb2 SATA enclosure612182430SE +/- 0.35, N = 3241. (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 Write - Average Latencydb performance by filesystem: ext4 connected by usb2 SATA enclosure918273645SE +/- 0.60, N = 341.591. (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 Onlydb performance by filesystem: ext4 connected by usb2 SATA enclosure1326395265SE +/- 0.43, N = 3581. (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 Latencydb performance by filesystem: ext4 connected by usb2 SATA enclosure2004006008001000SE +/- 6.35, N = 3861.411. (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 Writedb performance by filesystem: ext4 connected by usb2 SATA enclosure1122334455SE +/- 0.24, N = 3491. (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 Latencydb performance by filesystem: ext4 connected by usb2 SATA enclosure2004006008001000SE +/- 4.87, N = 31014.691. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

db performance by filesystem: ext4 connected by usb2 SATA enclosure

Processor: ARMv8 Cortex-A72 @ 1.42GHz (6 Cores), Motherboard: Pine64 RockPro64 v2.1, Chipset: Fuzhou Rockchip RK3399, Memory: 4096MB, Disk: 4001GB HGST HDS5C4040AL + 8002GB HUH72808CLAR8000 + 4001GB + 2 x 8002GB 728080ALE600 + 31GB SD32G

OS: Gentoo/Linux, Kernel: 5.6.0-1137-ayufan-ge57f05e7bf8f (aarch64), Compiler: GCC 11.1.0, File-System: ext4

Compiler Notes: --bindir=/usr/aarch64-unknown-linux-gnu/gcc-bin/11.1.0 --build=aarch64-unknown-linux-gnu --datadir=/usr/share/gcc-data/aarch64-unknown-linux-gnu/11.1.0 --disable-esp --disable-fixed-point --disable-libada --disable-libssp --disable-libvtv --disable-multilib --disable-systemtap --disable-valgrind-annotations --disable-vtable-verify --disable-werror --enable-__cxa_atexit --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-default-ssp --enable-languages=c,c++,fortran --enable-libgomp --enable-libstdcxx-time --enable-lto --enable-nls --enable-obsolete --enable-secureplt --enable-shared --enable-threads=posix --host=aarch64-unknown-linux-gnu --includedir=/usr/lib/gcc/aarch64-unknown-linux-gnu/11.1.0/include --mandir=/usr/share/gcc-data/aarch64-unknown-linux-gnu/11.1.0/man --with-python-dir=/share/gcc-data/aarch64-unknown-linux-gnu/11.1.0/python --without-isl --without-zstd
Processor Notes: Scaling Governor: cpufreq-dt schedutil
Security Notes: 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 + tsx_async_abort: Not affected

Testing initiated at 26 June 2021 11:02 by user root.