DB performance testing by FS: SATA attached variable rpm HD with ext4
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
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: 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 |
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 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 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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 |