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&rdt&grs .
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 - 100 - Read Only - Average Latency pgbench: 1 - 100 - Read Only pgbench: 1 - 50 - Read Only - Average Latency pgbench: 1 - 50 - Read Only pgbench: 1000 - 100 - Read Write - Average Latency pgbench: 1000 - 100 - Read Write pgbench: 1000 - 50 - Read Write - Average Latency pgbench: 1000 - 50 - Read Write pgbench: 1000 - 100 - Read Only - Average Latency pgbench: 1000 - 100 - Read Only pgbench: 100 - 100 - Read Write - Average Latency pgbench: 100 - 100 - Read Write pgbench: 1000 - 50 - Read Only - Average Latency pgbench: 1000 - 50 - Read Only pgbench: 1000 - 1 - Read Write - Average Latency pgbench: 1000 - 1 - Read Write pgbench: 100 - 50 - Read Write - Average Latency pgbench: 100 - 50 - Read Write pgbench: 100 - 100 - Read Only - Average Latency pgbench: 100 - 100 - Read Only pgbench: 1000 - 1 - Read Only - Average Latency pgbench: 1000 - 1 - Read Only pgbench: 100 - 50 - Read Only - Average Latency pgbench: 100 - 50 - Read Only pgbench: 100 - 1 - Read Write - Average Latency pgbench: 100 - 1 - Read Write pgbench: 1 - 100 - Read Write - Average Latency pgbench: 1 - 100 - Read Write pgbench: 100 - 1 - Read Only - Average Latency pgbench: 100 - 1 - Read Only pgbench: 1 - 50 - Read Write - Average Latency pgbench: 1 - 50 - Read Write pgbench: 1 - 1 - Read Write - Average Latency pgbench: 1 - 1 - Read Write pgbench: 1 - 1 - Read Only - Average Latency pgbench: 1 - 1 - Read Only 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 7.769 12883 3.598 13913 1124.847 89 748.923 67 814.103 124 545.827 187 431.577 117 66.228 16 278.676 181 231.034 455 26.808 38 130.745 405 42.033 27 1109.973 90 7.535 133 549.816 91 10.834 92 0.194 5286 6.942 14428 3.340 14982 2642.108 39 1423.188 36 2541.577 41 808.508 126 1423.262 36 87.963 11 186.917 279 10.991 9114 35.198 29 5.371 9327 43.840 26 2069.793 49 2.592 671 944.670 54 17.144 59 0.257 4000 3.304 15147 1014.692 49 861.414 58 41.587 24 17.587 57 103.817 489 5.582 240 0.183 5622 6.476 15453 3.161 15831 996.759 101 602.106 83 2235.742 45 157.272 649 394.256 127 76.699 13 98.101 513 9.034 11077 79.164 15 31.995 2643 28.272 36 2672.864 38 0.797 2023 1781.767 28 32.875 31 0.247 4054 6.795 14731 3.383 14790 2319.263 43 1719.510 32 2160.822 47 143.598 717 1040.514 49 48.883 21 178.709 311 140.501 3582 24.546 41 29.753 5233 21.556 49 1700.224 59 2.201 726 607.785 90 14.745 69 0.200 5223 OpenBenchmarking.org
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: 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: 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: 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: 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
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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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 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 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
Phoronix Test Suite v10.8.4