pgbench-ext4-SATA DB performance testing by FS: SATA attached variable rpm HD with ext4 DB performance by FS: SATA variable rpm HD with ext4: Processor: ARMv8 Cortex-A72 @ 1.42GHz (6 Cores), Motherboard: Pine64 RockPro64 v2.1, Chipset: Fuzhou Rockchip RK3399, Memory: 4096MB, Disk: 4001GB HGST HDS5C4040AL + 8002GB HUH72808CLAR8000 + 4001GB + 2 x 8002GB 728080ALE600 + 31GB SD32G OS: Gentoo/Linux, Kernel: 5.6.0-1137-ayufan-ge57f05e7bf8f (aarch64), Compiler: GCC 11.1.0, File-System: ext4 DB performance by FS: Btrfs on 7200rpm SAS drive: 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 DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4: Processor: ARMv8 Cortex-A72 @ 1.42GHz (6 Cores), Motherboard: Pine64 RockPro64 v2.1, Chipset: Fuzhou Rockchip RK3399, Memory: 4096MB, Disk: 4001GB HGST HDS5C4040AL + 8002GB HUH72808CLAR8000 + 4001GB + 2 x 8002GB 728080ALE600 + 31GB SD32G OS: Gentoo/Linux, Kernel: 5.6.0-1137-ayufan-ge57f05e7bf8f (aarch64), Compiler: GCC 11.1.0, File-System: ext4 DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS: 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 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 PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 7.769 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 6.476 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 6.795 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 6.942 | PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Only TPS > Higher Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 12883 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 15453 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 14731 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 14428 | PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 3.598 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 3.161 | DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4 .. 3.304 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 3.383 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 3.340 | PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Only TPS > Higher Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 13913 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 15831 | DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4 .. 15147 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 14790 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 14982 | PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 1124.85 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 996.76 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 2319.26 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 2642.11 | PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write TPS > Higher Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 89 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 101 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 43 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 39 | PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 748.92 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 602.11 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 1719.51 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 1423.19 | PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write TPS > Higher Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 67 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 83 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 32 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 36 | PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 814.10 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 2235.74 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 2160.82 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 2541.58 | PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only TPS > Higher Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 124 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 45 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 47 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 41 | PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 545.83 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 157.27 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 143.60 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 808.51 | PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Write TPS > Higher Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 187 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 649 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 717 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 126 | PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 431.58 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 394.26 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 1040.51 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 1423.26 | PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only TPS > Higher Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 117 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 127 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 49 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 36 | PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 66.23 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 76.70 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 48.88 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 87.96 | PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write TPS > Higher Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 16 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 13 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 21 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 11 | PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 278.68 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 98.10 | DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4 .. 1014.69 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 178.71 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 186.92 | PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Write TPS > Higher Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 181 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 513 | DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4 .. 49 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 311 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 279 | PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 231.034 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 9.034 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 140.501 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 10.991 | PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Only TPS > Higher Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 455 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 11077 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 3582 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 9114 | PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 26.81 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 79.16 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 24.55 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 35.20 | PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only TPS > Higher Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 38 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 15 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 41 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 29 | PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 130.745 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 31.995 | DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4 .. 861.414 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 29.753 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 5.371 | PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Only TPS > Higher Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 405 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 2643 | DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4 .. 58 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 5233 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 9327 | PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 42.03 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 28.27 | DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4 .. 41.59 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 21.56 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 43.84 | PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Write TPS > Higher Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 27 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 36 | DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4 .. 24 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 49 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 26 | PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 1109.97 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 2672.86 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 1700.22 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 2069.79 | PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Write TPS > Higher Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 90 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 38 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 59 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 49 | PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 7.535 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 0.797 | DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4 .. 17.587 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 2.201 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 2.592 | PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Only TPS > Higher Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 133 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 2023 | DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4 .. 57 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 726 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 671 | PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 549.82 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 1781.77 | DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4 .. 103.82 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 607.79 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 944.67 | PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Write TPS > Higher Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 91 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 28 | DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4 .. 489 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 90 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 54 | PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 10.834 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 32.875 | DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4 .. 5.582 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 14.745 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 17.144 | PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Write TPS > Higher Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 92 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 31 | DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4 .. 240 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 69 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 59 | PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 0.194 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 0.247 | DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4 .. 0.183 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 0.200 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 0.257 | PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Only TPS > Higher Is Better DB performance by FS: SATA variable rpm HD with ext4 ..................... 5286 | DB performance by FS: Btrfs on 7200rpm SAS drive ......................... 4054 | DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4 .. 5622 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 5223 | USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib .................. 4000 |