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&sor .
Processor Motherboard Chipset Memory Disk OS Kernel Compiler File-System DB performance by FS USB3 attached SATA 8TB Btrfs 7200rpm with compress SATA variable rpm HD with ext4 Btrfs on 7200rpm SAS drive USB2 attached SATA enclosure 7200rpm HD with ext4 USB3 attached SATA enclosure 7200rpm HD with BTRFS zlib 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, DB performance by FS: Btrfs on 7200rpm SAS drive, DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4, USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib: --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 SATA variable rpm HD with ext4 Btrfs on 7200rpm SAS drive USB2 attached SATA enclosure 7200rpm HD with ext4 USB3 attached SATA enclosure 7200rpm HD with BTRFS zlib 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 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 5622 0.183 240 5.582 15147 3.304 489 103.817 57 17.587 24 41.587 58 861.414 49 1014.692 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 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 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 USB2 attached SATA enclosure 7200rpm HD with ext4 SATA variable rpm HD with ext4 USB3 attached SATA enclosure 7200rpm HD with BTRFS Btrfs on 7200rpm SAS drive zlib 1200 2400 3600 4800 6000 SE +/- 264.65, N = 15 SE +/- 272.89, N = 12 SE +/- 310.66, N = 12 SE +/- 17.82, N = 3 SE +/- 216.12, N = 12 5622 5286 5223 4054 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 USB2 attached SATA enclosure 7200rpm HD with ext4 SATA variable rpm HD with ext4 USB3 attached SATA enclosure 7200rpm HD with BTRFS Btrfs on 7200rpm SAS drive zlib 0.0578 0.1156 0.1734 0.2312 0.289 SE +/- 0.008, N = 15 SE +/- 0.009, N = 12 SE +/- 0.013, N = 12 SE +/- 0.001, N = 3 SE +/- 0.012, N = 12 0.183 0.194 0.200 0.247 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 USB2 attached SATA enclosure 7200rpm HD with ext4 SATA variable rpm HD with ext4 USB3 attached SATA enclosure 7200rpm HD with BTRFS zlib Btrfs on 7200rpm SAS drive 50 100 150 200 250 SE +/- 27.89, N = 12 SE +/- 0.25, N = 3 SE +/- 2.26, N = 15 SE +/- 1.09, N = 15 SE +/- 2.27, N = 15 240 92 69 31 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 USB2 attached SATA enclosure 7200rpm HD with ext4 SATA variable rpm HD with ext4 USB3 attached SATA enclosure 7200rpm HD with BTRFS zlib Btrfs on 7200rpm SAS drive 8 16 24 32 40 SE +/- 1.124, N = 12 SE +/- 0.030, N = 3 SE +/- 0.490, N = 15 SE +/- 1.105, N = 15 SE +/- 0.627, N = 15 5.582 10.834 14.745 32.875 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 Btrfs on 7200rpm SAS drive USB2 attached SATA enclosure 7200rpm HD with ext4 zlib USB3 attached SATA enclosure 7200rpm HD with BTRFS SATA variable rpm HD with ext4 3K 6K 9K 12K 15K SE +/- 144.82, N = 3 SE +/- 83.84, N = 3 SE +/- 116.66, N = 3 SE +/- 125.25, N = 7 SE +/- 70.45, N = 3 15831 15147 14790 13913 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 Btrfs on 7200rpm SAS drive USB2 attached SATA enclosure 7200rpm HD with ext4 zlib USB3 attached SATA enclosure 7200rpm HD with BTRFS SATA variable rpm HD with ext4 0.8096 1.6192 2.4288 3.2384 4.048 SE +/- 0.029, N = 3 SE +/- 0.018, N = 3 SE +/- 0.027, N = 3 SE +/- 0.033, N = 7 SE +/- 0.016, N = 3 3.161 3.304 3.383 3.598 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 Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS zlib SATA variable rpm HD with ext4 3K 6K 9K 12K 15K SE +/- 144.24, N = 3 SE +/- 164.46, N = 3 SE +/- 85.70, N = 3 SE +/- 114.79, N = 15 15453 14731 12883 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 Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS zlib SATA variable rpm HD with ext4 2 4 6 8 10 SE +/- 0.061, N = 3 SE +/- 0.075, N = 3 SE +/- 0.051, N = 3 SE +/- 0.054, N = 15 6.476 6.795 7.769 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 USB2 attached SATA enclosure 7200rpm HD with ext4 SATA variable rpm HD with ext4 USB3 attached SATA enclosure 7200rpm HD with BTRFS zlib Btrfs on 7200rpm SAS drive 110 220 330 440 550 SE +/- 15.03, N = 13 SE +/- 0.45, N = 3 SE +/- 7.24, N = 12 SE +/- 0.90, N = 15 SE +/- 1.99, N = 15 489 91 90 28 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 USB2 attached SATA enclosure 7200rpm HD with ext4 SATA variable rpm HD with ext4 USB3 attached SATA enclosure 7200rpm HD with BTRFS zlib Btrfs on 7200rpm SAS drive 400 800 1200 1600 2000 SE +/- 4.15, N = 13 SE +/- 2.73, N = 3 SE +/- 56.42, N = 12 SE +/- 56.78, N = 15 SE +/- 30.21, N = 15 103.82 549.82 607.79 1781.77 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 Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS zlib SATA variable rpm HD with ext4 USB2 attached SATA enclosure 7200rpm HD with ext4 400 800 1200 1600 2000 SE +/- 404.52, N = 9 SE +/- 277.40, N = 9 SE +/- 0.14, N = 3 SE +/- 1.13, N = 9 SE +/- 152.35, N = 12 2023 726 133 57 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 Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS zlib SATA variable rpm HD with ext4 USB2 attached SATA enclosure 7200rpm HD with ext4 4 8 12 16 20 SE +/- 0.194, N = 9 SE +/- 0.319, N = 9 SE +/- 0.008, N = 3 SE +/- 0.344, N = 9 SE +/- 0.584, N = 12 0.797 2.201 7.535 17.587 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 USB3 attached SATA enclosure 7200rpm HD with BTRFS zlib Btrfs on 7200rpm SAS drive 20 40 60 80 100 SE +/- 0.16, N = 3 SE +/- 0.81, N = 12 SE +/- 0.50, N = 15 SE +/- 2.15, N = 15 90 59 38 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 USB3 attached SATA enclosure 7200rpm HD with BTRFS zlib Btrfs on 7200rpm SAS drive 600 1200 1800 2400 3000 SE +/- 2.06, N = 3 SE +/- 23.22, N = 12 SE +/- 36.09, N = 15 SE +/- 76.50, N = 15 1109.97 1700.22 2672.86 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 USB3 attached SATA enclosure 7200rpm HD with BTRFS Btrfs on 7200rpm SAS drive SATA variable rpm HD with ext4 zlib USB2 attached SATA enclosure 7200rpm HD with ext4 11 22 33 44 55 SE +/- 3.50, N = 12 SE +/- 0.86, N = 12 SE +/- 3.65, N = 9 SE +/- 0.35, N = 3 SE +/- 3.51, N = 9 49 36 27 24 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 USB3 attached SATA enclosure 7200rpm HD with BTRFS Btrfs on 7200rpm SAS drive USB2 attached SATA enclosure 7200rpm HD with ext4 SATA variable rpm HD with ext4 zlib 10 20 30 40 50 SE +/- 1.74, N = 12 SE +/- 0.69, N = 12 SE +/- 0.60, N = 3 SE +/- 4.50, N = 9 SE +/- 6.06, N = 9 21.56 28.27 41.59 42.03 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 USB3 attached SATA 8TB Btrfs 7200rpm with compress DB performance by FS OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Only zlib USB3 attached SATA enclosure 7200rpm HD with BTRFS Btrfs on 7200rpm SAS drive SATA variable rpm HD with ext4 USB2 attached SATA enclosure 7200rpm HD with ext4 2K 4K 6K 8K 10K SE +/- 93.78, N = 12 SE +/- 1301.79, N = 12 SE +/- 796.92, N = 12 SE +/- 43.65, N = 9 SE +/- 0.43, N = 3 9327 5233 2643 405 58 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 USB3 attached SATA 8TB Btrfs 7200rpm with compress DB performance by FS OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency zlib USB3 attached SATA enclosure 7200rpm HD with BTRFS Btrfs on 7200rpm SAS drive SATA variable rpm HD with ext4 USB2 attached SATA enclosure 7200rpm HD with ext4 200 400 600 800 1000 SE +/- 0.054, N = 12 SE +/- 9.469, N = 12 SE +/- 8.377, N = 12 SE +/- 8.526, N = 9 SE +/- 6.352, N = 3 5.371 29.753 31.995 130.745 861.414 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 USB3 attached SATA enclosure 7200rpm HD with BTRFS SATA variable rpm HD with ext4 zlib Btrfs on 7200rpm SAS drive 9 18 27 36 45 SE +/- 0.48, N = 4 SE +/- 2.23, N = 7 SE +/- 3.73, N = 7 SE +/- 2.05, N = 9 41 38 15 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 USB3 attached SATA enclosure 7200rpm HD with BTRFS SATA variable rpm HD with ext4 zlib Btrfs on 7200rpm SAS drive 20 40 60 80 100 SE +/- 0.28, N = 4 SE +/- 1.63, N = 7 SE +/- 9.24, N = 7 SE +/- 2.13, N = 9 24.55 26.81 79.16 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 Btrfs on 7200rpm SAS drive zlib USB3 attached SATA enclosure 7200rpm HD with BTRFS SATA variable rpm HD with ext4 2K 4K 6K 8K 10K SE +/- 30.63, N = 3 SE +/- 1272.56, N = 12 SE +/- 32.94, N = 12 SE +/- 83.92, N = 12 11077 3582 455 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 Btrfs on 7200rpm SAS drive zlib USB3 attached SATA enclosure 7200rpm HD with BTRFS SATA variable rpm HD with ext4 50 100 150 200 250 SE +/- 0.025, N = 3 SE +/- 36.736, N = 12 SE +/- 14.021, N = 12 SE +/- 0.096, N = 12 9.034 140.501 231.034 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 Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS zlib SATA variable rpm HD with ext4 USB2 attached SATA enclosure 7200rpm HD with ext4 110 220 330 440 550 SE +/- 10.76, N = 12 SE +/- 32.93, N = 9 SE +/- 6.65, N = 9 SE +/- 0.24, N = 3 SE +/- 16.64, N = 12 513 311 181 49 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 Btrfs on 7200rpm SAS drive USB3 attached SATA enclosure 7200rpm HD with BTRFS zlib SATA variable rpm HD with ext4 USB2 attached SATA enclosure 7200rpm HD with ext4 200 400 600 800 1000 SE +/- 2.31, N = 12 SE +/- 22.41, N = 9 SE +/- 10.12, N = 9 SE +/- 4.87, N = 3 SE +/- 11.34, N = 12 98.10 178.71 278.68 1014.69 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 USB3 attached SATA enclosure 7200rpm HD with BTRFS SATA variable rpm HD with ext4 Btrfs on 7200rpm SAS drive zlib 5 10 15 20 25 SE +/- 0.51, N = 9 SE +/- 1.79, N = 9 SE +/- 0.39, N = 9 SE +/- 0.29, N = 9 21 16 13 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 USB3 attached SATA enclosure 7200rpm HD with BTRFS SATA variable rpm HD with ext4 Btrfs on 7200rpm SAS drive zlib 20 40 60 80 100 SE +/- 1.12, N = 9 SE +/- 5.95, N = 9 SE +/- 2.30, N = 9 SE +/- 2.20, N = 9 48.88 66.23 76.70 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 Btrfs on 7200rpm SAS drive SATA variable rpm HD with ext4 USB3 attached SATA enclosure 7200rpm HD with BTRFS zlib 30 60 90 120 150 SE +/- 1.95, N = 9 SE +/- 3.98, N = 9 SE +/- 2.35, N = 9 SE +/- 1.84, N = 9 127 117 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 Btrfs on 7200rpm SAS drive SATA variable rpm HD with ext4 USB3 attached SATA enclosure 7200rpm HD with BTRFS zlib 300 600 900 1200 1500 SE +/- 6.03, N = 9 SE +/- 13.39, N = 9 SE +/- 54.31, N = 9 SE +/- 63.21, N = 9 394.26 431.58 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 USB3 attached SATA enclosure 7200rpm HD with BTRFS Btrfs on 7200rpm SAS drive SATA variable rpm HD with ext4 zlib 150 300 450 600 750 SE +/- 37.35, N = 10 SE +/- 24.87, N = 12 SE +/- 7.73, N = 12 SE +/- 5.29, N = 9 717 649 187 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 USB3 attached SATA enclosure 7200rpm HD with BTRFS Btrfs on 7200rpm SAS drive SATA variable rpm HD with ext4 zlib 200 400 600 800 1000 SE +/- 8.54, N = 10 SE +/- 7.36, N = 12 SE +/- 25.45, N = 12 SE +/- 36.68, N = 9 143.60 157.27 545.83 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 USB3 attached SATA enclosure 7200rpm HD with BTRFS Btrfs on 7200rpm SAS drive zlib 30 60 90 120 150 SE +/- 3.14, N = 9 SE +/- 2.64, N = 6 SE +/- 1.47, N = 7 SE +/- 2.40, N = 9 124 47 45 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 USB3 attached SATA enclosure 7200rpm HD with BTRFS Btrfs on 7200rpm SAS drive zlib 500 1000 1500 2000 2500 SE +/- 21.21, N = 9 SE +/- 131.07, N = 6 SE +/- 69.13, N = 7 SE +/- 160.61, N = 9 814.10 2160.82 2235.74 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 Btrfs on 7200rpm SAS drive SATA variable rpm HD with ext4 zlib USB3 attached SATA enclosure 7200rpm HD with BTRFS 20 40 60 80 100 SE +/- 1.67, N = 9 SE +/- 2.13, N = 7 SE +/- 3.61, N = 6 SE +/- 2.28, N = 9 83 67 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 Btrfs on 7200rpm SAS drive SATA variable rpm HD with ext4 zlib USB3 attached SATA enclosure 7200rpm HD with BTRFS 400 800 1200 1600 2000 SE +/- 11.67, N = 9 SE +/- 24.01, N = 7 SE +/- 279.34, N = 6 SE +/- 98.25, N = 9 602.11 748.92 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 Btrfs on 7200rpm SAS drive SATA variable rpm HD with ext4 USB3 attached SATA enclosure 7200rpm HD with BTRFS zlib 20 40 60 80 100 SE +/- 4.23, N = 6 SE +/- 1.11, N = 3 SE +/- 0.34, N = 3 SE +/- 2.26, N = 8 101 89 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 Btrfs on 7200rpm SAS drive SATA variable rpm HD with ext4 USB3 attached SATA enclosure 7200rpm HD with BTRFS zlib 600 1200 1800 2400 3000 SE +/- 43.96, N = 6 SE +/- 13.83, N = 3 SE +/- 18.18, N = 3 SE +/- 129.76, N = 8 996.76 1124.85 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