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 DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 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: 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 4000 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 0.257 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 59 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 17.144 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 14982 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 3.340 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 14428 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 6.942 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 54 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 944.67 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 671 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 2.592 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 49 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 2069.79 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 26 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 43.84 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 9327 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 5.371 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 29 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 35.20 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 9114 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 10.991 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 279 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 186.92 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 11 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 87.96 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 36 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 1423.26 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 126 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 808.51 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 41 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 2541.58 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 36 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 1423.19 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 39 | 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 | DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS compress:zlib . 2642.11 |