pgbench-usb3-sata-btrfs-7200-zlib DB perf by FS: USB3 SATA HGST 8TB 7200rpm BTRFS compress:zlib
Compare your own system(s) to this result file with the
Phoronix Test Suite by running the command:
phoronix-test-suite benchmark 2106265-IB-PGBENCHUS04 USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 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: btrfs
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-zstdProcessor Notes: Scaling Governor: cpufreq-dt schedutilSecurity 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
PostgreSQL pgbench This is a benchmark of PostgreSQL using pgbench for facilitating the database benchmarks. Learn more via the OpenBenchmarking.org test page.
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Only USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 900 1800 2700 3600 4500 SE +/- 216.12, N = 12 4000 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 0.0578 0.1156 0.1734 0.2312 0.289 SE +/- 0.012, N = 12 0.257 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Write USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 13 26 39 52 65 SE +/- 2.27, N = 15 59 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 4 8 12 16 20 SE +/- 0.63, N = 15 17.14 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Only USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 3K 6K 9K 12K 15K SE +/- 70.45, N = 3 14982 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 0.7515 1.503 2.2545 3.006 3.7575 SE +/- 0.016, N = 3 3.340 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Only USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 3K 6K 9K 12K 15K SE +/- 114.79, N = 15 14428 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 2 4 6 8 10 SE +/- 0.054, N = 15 6.942 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Write USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 12 24 36 48 60 SE +/- 1.99, N = 15 54 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 200 400 600 800 1000 SE +/- 30.21, N = 15 944.67 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Only USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 140 280 420 560 700 SE +/- 152.35, N = 12 671 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 0.5832 1.1664 1.7496 2.3328 2.916 SE +/- 0.584, N = 12 2.592 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Write USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 11 22 33 44 55 SE +/- 2.15, N = 15 49 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 400 800 1200 1600 2000 SE +/- 76.50, N = 15 2069.79 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Write USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 6 12 18 24 30 SE +/- 3.51, N = 9 26 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 10 20 30 40 50 SE +/- 6.06, N = 9 43.84 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Only USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 2K 4K 6K 8K 10K SE +/- 93.78, N = 12 9327 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 1.2085 2.417 3.6255 4.834 6.0425 SE +/- 0.054, N = 12 5.371 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 7 14 21 28 35 SE +/- 2.05, N = 9 29 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 8 16 24 32 40 SE +/- 2.13, N = 9 35.20 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Only USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 2K 4K 6K 8K 10K SE +/- 83.92, N = 12 9114 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 3 6 9 12 15 SE +/- 0.10, N = 12 10.99 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Write USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 60 120 180 240 300 SE +/- 16.64, N = 12 279 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 40 80 120 160 200 SE +/- 11.34, N = 12 186.92 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 3 6 9 12 15 SE +/- 0.29, N = 9 11 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 20 40 60 80 100 SE +/- 2.20, N = 9 87.96 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 8 16 24 32 40 SE +/- 1.84, N = 9 36 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 300 600 900 1200 1500 SE +/- 63.21, N = 9 1423.26 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Write USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 30 60 90 120 150 SE +/- 5.29, N = 9 126 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 200 400 600 800 1000 SE +/- 36.68, N = 9 808.51 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 9 18 27 36 45 SE +/- 2.40, N = 9 41 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 500 1000 1500 2000 2500 SE +/- 160.61, N = 9 2541.58 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 8 16 24 32 40 SE +/- 2.28, N = 9 36 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 300 600 900 1200 1500 SE +/- 98.25, N = 9 1423.19 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 9 18 27 36 45 SE +/- 2.26, N = 8 39 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 600 1200 1800 2400 3000 SE +/- 129.76, N = 8 2642.11 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib 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: btrfs
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-zstdProcessor Notes: Scaling Governor: cpufreq-dt schedutilSecurity 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 24 June 2021 16:58 by user galiven.