Compare your own system(s) to this result file with the
Phoronix Test Suite by running the command:
phoronix-test-suite benchmark 2107047-IB-MERGE136101 pgbench-ext4-SATA - Phoronix Test Suite pgbench-ext4-SATA DB performance testing by FS: SATA attached variable rpm HD with ext4
HTML result view exported from: https://openbenchmarking.org/result/2107047-IB-MERGE136101&grt&rdt .
Processor Motherboard Chipset Memory Disk OS Kernel Compiler File-System DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress DB performance by FS SATA variable rpm HD with ext4 zlib USB2 attached SATA enclosure 7200rpm HD with ext4 Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS ARMv8 Cortex-A72 @ 1.42GHz (6 Cores) Pine64 RockPro64 v2.1 Fuzhou Rockchip RK3399 4096MB 4001GB HGST HDS5C4040AL + 8002GB HUH72808CLAR8000 + 4001GB + 2 x 8002GB 728080ALE600 + 31GB SD32G Gentoo/Linux 5.6.0-1137-ayufan-ge57f05e7bf8f (aarch64) GCC 11.1.0 ext4 btrfs ext4 btrfs OpenBenchmarking.org Compiler Details - DB performance by FS: SATA variable rpm HD with ext4, USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib, DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4, DB performance by FS: Btrfs on 7200rpm SAS drive: --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 Details - Scaling Governor: cpufreq-dt schedutil Security Details - 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
pgbench: 1 - 1 - Read Only pgbench: 1 - 1 - Read Only - Average Latency pgbench: 1 - 1 - Read Write pgbench: 1 - 1 - Read Write - Average Latency pgbench: 1 - 50 - Read Only pgbench: 1 - 50 - Read Only - Average Latency pgbench: 1 - 100 - Read Only pgbench: 1 - 100 - Read Only - Average Latency pgbench: 1 - 50 - Read Write pgbench: 1 - 50 - Read Write - Average Latency pgbench: 100 - 1 - Read Only pgbench: 100 - 1 - Read Only - Average Latency pgbench: 1 - 100 - Read Write pgbench: 1 - 100 - Read Write - Average Latency pgbench: 100 - 1 - Read Write pgbench: 100 - 1 - Read Write - Average Latency pgbench: 100 - 50 - Read Only pgbench: 100 - 50 - Read Only - Average Latency pgbench: 1000 - 1 - Read Only pgbench: 1000 - 1 - Read Only - Average Latency pgbench: 100 - 100 - Read Only pgbench: 100 - 100 - Read Only - Average Latency pgbench: 100 - 50 - Read Write pgbench: 100 - 50 - Read Write - Average Latency pgbench: 1000 - 1 - Read Write pgbench: 1000 - 1 - Read Write - Average Latency pgbench: 1000 - 50 - Read Only pgbench: 1000 - 50 - Read Only - Average Latency pgbench: 100 - 100 - Read Write pgbench: 100 - 100 - Read Write - Average Latency pgbench: 1000 - 100 - Read Only pgbench: 1000 - 100 - Read Only - Average Latency pgbench: 1000 - 50 - Read Write pgbench: 1000 - 50 - Read Write - Average Latency pgbench: 1000 - 100 - Read Write pgbench: 1000 - 100 - Read Write - Average Latency DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress DB performance by FS SATA variable rpm HD with ext4 zlib USB2 attached SATA enclosure 7200rpm HD with ext4 Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 5286 0.194 92 10.834 13913 3.598 12883 7.769 91 549.816 133 7.535 90 1109.973 27 42.033 405 130.745 38 26.808 455 231.034 181 278.676 16 66.228 117 431.577 187 545.827 124 814.103 67 748.923 89 1124.847 4000 0.257 59 17.144 14982 3.340 14428 6.942 54 944.670 671 2.592 49 2069.793 26 43.840 9327 5.371 29 35.198 9114 10.991 279 186.917 11 87.963 36 1423.262 126 808.508 41 2541.577 36 1423.188 39 2642.108 5622 0.183 240 5.582 15147 3.304 489 103.817 57 17.587 24 41.587 58 861.414 49 1014.692 4054 0.247 31 32.875 15831 3.161 15453 6.476 28 1781.767 2023 0.797 38 2672.864 36 28.272 2643 31.995 15 79.164 11077 9.034 513 98.101 13 76.699 127 394.256 649 157.272 45 2235.742 83 602.106 101 996.759 5223 0.200 69 14.745 14790 3.383 14731 6.795 90 607.785 726 2.201 59 1700.224 49 21.556 5233 29.753 41 24.546 3582 140.501 311 178.709 21 48.883 49 1040.514 717 143.598 47 2160.822 32 1719.510 43 2319.263 OpenBenchmarking.org
PostgreSQL pgbench Scaling Factor: 1 - Clients: 1 - Mode: Read Only DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Only SATA variable rpm HD with ext4 zlib USB2 attached SATA enclosure 7200rpm HD with ext4 Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 1200 2400 3600 4800 6000 SE +/- 272.89, N = 12 SE +/- 264.65, N = 15 SE +/- 17.82, N = 3 SE +/- 310.66, N = 12 SE +/- 216.12, N = 12 5286 5622 4054 5223 4000 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency SATA variable rpm HD with ext4 zlib USB2 attached SATA enclosure 7200rpm HD with ext4 Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 0.0578 0.1156 0.1734 0.2312 0.289 SE +/- 0.009, N = 12 SE +/- 0.008, N = 15 SE +/- 0.001, N = 3 SE +/- 0.013, N = 12 SE +/- 0.012, N = 12 0.194 0.183 0.247 0.200 0.257 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 1 - Mode: Read Write DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Write SATA variable rpm HD with ext4 zlib USB2 attached SATA enclosure 7200rpm HD with ext4 Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 50 100 150 200 250 SE +/- 0.25, N = 3 SE +/- 27.89, N = 12 SE +/- 1.09, N = 15 SE +/- 2.26, N = 15 SE +/- 2.27, N = 15 92 240 31 69 59 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency SATA variable rpm HD with ext4 zlib USB2 attached SATA enclosure 7200rpm HD with ext4 Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 8 16 24 32 40 SE +/- 0.030, N = 3 SE +/- 1.124, N = 12 SE +/- 1.105, N = 15 SE +/- 0.490, N = 15 SE +/- 0.627, N = 15 10.834 5.582 32.875 14.745 17.144 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 50 - Mode: Read Only DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Only SATA variable rpm HD with ext4 zlib USB2 attached SATA enclosure 7200rpm HD with ext4 Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 3K 6K 9K 12K 15K SE +/- 125.25, N = 7 SE +/- 83.84, N = 3 SE +/- 144.82, N = 3 SE +/- 116.66, N = 3 SE +/- 70.45, N = 3 13913 15147 15831 14790 14982 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency SATA variable rpm HD with ext4 zlib USB2 attached SATA enclosure 7200rpm HD with ext4 Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 0.8096 1.6192 2.4288 3.2384 4.048 SE +/- 0.033, N = 7 SE +/- 0.018, N = 3 SE +/- 0.029, N = 3 SE +/- 0.027, N = 3 SE +/- 0.016, N = 3 3.598 3.304 3.161 3.383 3.340 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 100 - Mode: Read Only DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Only SATA variable rpm HD with ext4 zlib Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 3K 6K 9K 12K 15K SE +/- 85.70, N = 3 SE +/- 144.24, N = 3 SE +/- 164.46, N = 3 SE +/- 114.79, N = 15 12883 15453 14731 14428 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency SATA variable rpm HD with ext4 zlib Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 2 4 6 8 10 SE +/- 0.051, N = 3 SE +/- 0.061, N = 3 SE +/- 0.075, N = 3 SE +/- 0.054, N = 15 7.769 6.476 6.795 6.942 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 50 - Mode: Read Write DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Write SATA variable rpm HD with ext4 zlib USB2 attached SATA enclosure 7200rpm HD with ext4 Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 110 220 330 440 550 SE +/- 0.45, N = 3 SE +/- 15.03, N = 13 SE +/- 0.90, N = 15 SE +/- 7.24, N = 12 SE +/- 1.99, N = 15 91 489 28 90 54 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency SATA variable rpm HD with ext4 zlib USB2 attached SATA enclosure 7200rpm HD with ext4 Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 400 800 1200 1600 2000 SE +/- 2.73, N = 3 SE +/- 4.15, N = 13 SE +/- 56.78, N = 15 SE +/- 56.42, N = 12 SE +/- 30.21, N = 15 549.82 103.82 1781.77 607.79 944.67 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 100 - Clients: 1 - Mode: Read Only DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Only SATA variable rpm HD with ext4 zlib USB2 attached SATA enclosure 7200rpm HD with ext4 Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 400 800 1200 1600 2000 SE +/- 0.14, N = 3 SE +/- 1.13, N = 9 SE +/- 404.52, N = 9 SE +/- 277.40, N = 9 SE +/- 152.35, N = 12 133 57 2023 726 671 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency SATA variable rpm HD with ext4 zlib USB2 attached SATA enclosure 7200rpm HD with ext4 Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 4 8 12 16 20 SE +/- 0.008, N = 3 SE +/- 0.344, N = 9 SE +/- 0.194, N = 9 SE +/- 0.319, N = 9 SE +/- 0.584, N = 12 7.535 17.587 0.797 2.201 2.592 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 100 - Mode: Read Write DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Write SATA variable rpm HD with ext4 zlib Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 20 40 60 80 100 SE +/- 0.16, N = 3 SE +/- 0.50, N = 15 SE +/- 0.81, N = 12 SE +/- 2.15, N = 15 90 38 59 49 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency SATA variable rpm HD with ext4 zlib Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 600 1200 1800 2400 3000 SE +/- 2.06, N = 3 SE +/- 36.09, N = 15 SE +/- 23.22, N = 12 SE +/- 76.50, N = 15 1109.97 2672.86 1700.22 2069.79 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 100 - Clients: 1 - Mode: Read Write DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Write SATA variable rpm HD with ext4 zlib USB2 attached SATA enclosure 7200rpm HD with ext4 Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 11 22 33 44 55 SE +/- 3.65, N = 9 SE +/- 0.35, N = 3 SE +/- 0.86, N = 12 SE +/- 3.50, N = 12 SE +/- 3.51, N = 9 27 24 36 49 26 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency SATA variable rpm HD with ext4 zlib USB2 attached SATA enclosure 7200rpm HD with ext4 Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 10 20 30 40 50 SE +/- 4.50, N = 9 SE +/- 0.60, N = 3 SE +/- 0.69, N = 12 SE +/- 1.74, N = 12 SE +/- 6.06, N = 9 42.03 41.59 28.27 21.56 43.84 1. (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 DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Only SATA variable rpm HD with ext4 zlib USB2 attached SATA enclosure 7200rpm HD with ext4 Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 2K 4K 6K 8K 10K SE +/- 43.65, N = 9 SE +/- 0.43, N = 3 SE +/- 796.92, N = 12 SE +/- 1301.79, N = 12 SE +/- 93.78, N = 12 405 58 2643 5233 9327 1. (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 DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency SATA variable rpm HD with ext4 zlib USB2 attached SATA enclosure 7200rpm HD with ext4 Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 200 400 600 800 1000 SE +/- 8.526, N = 9 SE +/- 6.352, N = 3 SE +/- 8.377, N = 12 SE +/- 9.469, N = 12 SE +/- 0.054, N = 12 130.745 861.414 31.995 29.753 5.371 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 1 - Mode: Read Only DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only SATA variable rpm HD with ext4 zlib Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 9 18 27 36 45 SE +/- 2.23, N = 7 SE +/- 3.73, N = 7 SE +/- 0.48, N = 4 SE +/- 2.05, N = 9 38 15 41 29 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency SATA variable rpm HD with ext4 zlib Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 20 40 60 80 100 SE +/- 1.63, N = 7 SE +/- 9.24, N = 7 SE +/- 0.28, N = 4 SE +/- 2.13, N = 9 26.81 79.16 24.55 35.20 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 100 - Clients: 100 - Mode: Read Only DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Only SATA variable rpm HD with ext4 zlib Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 2K 4K 6K 8K 10K SE +/- 32.94, N = 12 SE +/- 30.63, N = 3 SE +/- 1272.56, N = 12 SE +/- 83.92, N = 12 455 11077 3582 9114 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency SATA variable rpm HD with ext4 zlib Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 50 100 150 200 250 SE +/- 14.021, N = 12 SE +/- 0.025, N = 3 SE +/- 36.736, N = 12 SE +/- 0.096, N = 12 231.034 9.034 140.501 10.991 1. (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 DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Write SATA variable rpm HD with ext4 zlib USB2 attached SATA enclosure 7200rpm HD with ext4 Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 110 220 330 440 550 SE +/- 6.65, N = 9 SE +/- 0.24, N = 3 SE +/- 10.76, N = 12 SE +/- 32.93, N = 9 SE +/- 16.64, N = 12 181 49 513 311 279 1. (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 DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency SATA variable rpm HD with ext4 zlib USB2 attached SATA enclosure 7200rpm HD with ext4 Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 200 400 600 800 1000 SE +/- 10.12, N = 9 SE +/- 4.87, N = 3 SE +/- 2.31, N = 12 SE +/- 22.41, N = 9 SE +/- 11.34, N = 12 278.68 1014.69 98.10 178.71 186.92 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 1 - Mode: Read Write DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write SATA variable rpm HD with ext4 zlib Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 5 10 15 20 25 SE +/- 1.79, N = 9 SE +/- 0.39, N = 9 SE +/- 0.51, N = 9 SE +/- 0.29, N = 9 16 13 21 11 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency SATA variable rpm HD with ext4 zlib Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 20 40 60 80 100 SE +/- 5.95, N = 9 SE +/- 2.30, N = 9 SE +/- 1.12, N = 9 SE +/- 2.20, N = 9 66.23 76.70 48.88 87.96 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 50 - Mode: Read Only DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only SATA variable rpm HD with ext4 zlib Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 30 60 90 120 150 SE +/- 3.98, N = 9 SE +/- 1.95, N = 9 SE +/- 2.35, N = 9 SE +/- 1.84, N = 9 117 127 49 36 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency SATA variable rpm HD with ext4 zlib Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 300 600 900 1200 1500 SE +/- 13.39, N = 9 SE +/- 6.03, N = 9 SE +/- 54.31, N = 9 SE +/- 63.21, N = 9 431.58 394.26 1040.51 1423.26 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 100 - Clients: 100 - Mode: Read Write DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Write SATA variable rpm HD with ext4 zlib Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 150 300 450 600 750 SE +/- 7.73, N = 12 SE +/- 24.87, N = 12 SE +/- 37.35, N = 10 SE +/- 5.29, N = 9 187 649 717 126 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency SATA variable rpm HD with ext4 zlib Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 200 400 600 800 1000 SE +/- 25.45, N = 12 SE +/- 7.36, N = 12 SE +/- 8.54, N = 10 SE +/- 36.68, N = 9 545.83 157.27 143.60 808.51 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 100 - Mode: Read Only DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only SATA variable rpm HD with ext4 zlib Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 30 60 90 120 150 SE +/- 3.14, N = 9 SE +/- 1.47, N = 7 SE +/- 2.64, N = 6 SE +/- 2.40, N = 9 124 45 47 41 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency SATA variable rpm HD with ext4 zlib Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 500 1000 1500 2000 2500 SE +/- 21.21, N = 9 SE +/- 69.13, N = 7 SE +/- 131.07, N = 6 SE +/- 160.61, N = 9 814.10 2235.74 2160.82 2541.58 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 50 - Mode: Read Write DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write SATA variable rpm HD with ext4 zlib Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 20 40 60 80 100 SE +/- 2.13, N = 7 SE +/- 1.67, N = 9 SE +/- 3.61, N = 6 SE +/- 2.28, N = 9 67 83 32 36 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency SATA variable rpm HD with ext4 zlib Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 400 800 1200 1600 2000 SE +/- 24.01, N = 7 SE +/- 11.67, N = 9 SE +/- 279.34, N = 6 SE +/- 98.25, N = 9 748.92 602.11 1719.51 1423.19 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 100 - Mode: Read Write DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write SATA variable rpm HD with ext4 zlib Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 20 40 60 80 100 SE +/- 1.11, N = 3 SE +/- 4.23, N = 6 SE +/- 0.34, N = 3 SE +/- 2.26, N = 8 89 101 43 39 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
PostgreSQL pgbench Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency SATA variable rpm HD with ext4 zlib Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS 600 1200 1800 2400 3000 SE +/- 13.83, N = 3 SE +/- 43.96, N = 6 SE +/- 18.18, N = 3 SE +/- 129.76, N = 8 1124.85 996.76 2319.26 2642.11 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
Phoronix Test Suite v10.8.4