usb2-sata-ext4-7200
DB performance testing by Filesystem on small ARM64 SBC


db performance by filesystem: ext4 connected by usb2 SATA enclosure: 

	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


PostgreSQL pgbench 13.0
Scaling Factor: 1 - Clients: 1 - Mode: Read Only
TPS > Higher Is Better
db performance by filesystem: ext4 connected by usb2 SATA enclosure . 5622 |===


PostgreSQL pgbench 13.0
Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency
ms < Lower Is Better
db performance by filesystem: ext4 connected by usb2 SATA enclosure . 0.183 |==


PostgreSQL pgbench 13.0
Scaling Factor: 1 - Clients: 1 - Mode: Read Write
TPS > Higher Is Better
db performance by filesystem: ext4 connected by usb2 SATA enclosure . 240 |====


PostgreSQL pgbench 13.0
Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency
ms < Lower Is Better
db performance by filesystem: ext4 connected by usb2 SATA enclosure . 5.582 |==


PostgreSQL pgbench 13.0
Scaling Factor: 1 - Clients: 50 - Mode: Read Only
TPS > Higher Is Better
db performance by filesystem: ext4 connected by usb2 SATA enclosure . 15147 |==


PostgreSQL pgbench 13.0
Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency
ms < Lower Is Better
db performance by filesystem: ext4 connected by usb2 SATA enclosure . 3.304 |==


PostgreSQL pgbench 13.0
Scaling Factor: 1 - Clients: 50 - Mode: Read Write
TPS > Higher Is Better
db performance by filesystem: ext4 connected by usb2 SATA enclosure . 489 |====


PostgreSQL pgbench 13.0
Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency
ms < Lower Is Better
db performance by filesystem: ext4 connected by usb2 SATA enclosure . 103.82 |=


PostgreSQL pgbench 13.0
Scaling Factor: 100 - Clients: 1 - Mode: Read Only
TPS > Higher Is Better
db performance by filesystem: ext4 connected by usb2 SATA enclosure . 57 |=====


PostgreSQL pgbench 13.0
Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency
ms < Lower Is Better
db performance by filesystem: ext4 connected by usb2 SATA enclosure . 17.59 |==


PostgreSQL pgbench 13.0
Scaling Factor: 100 - Clients: 1 - Mode: Read Write
TPS > Higher Is Better
db performance by filesystem: ext4 connected by usb2 SATA enclosure . 24 |=====


PostgreSQL pgbench 13.0
Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency
ms < Lower Is Better
db performance by filesystem: ext4 connected by usb2 SATA enclosure . 41.59 |==


PostgreSQL pgbench 13.0
Scaling Factor: 100 - Clients: 50 - Mode: Read Only
TPS > Higher Is Better
db performance by filesystem: ext4 connected by usb2 SATA enclosure . 58 |=====


PostgreSQL pgbench 13.0
Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency
ms < Lower Is Better
db performance by filesystem: ext4 connected by usb2 SATA enclosure . 861.41 |=


PostgreSQL pgbench 13.0
Scaling Factor: 100 - Clients: 50 - Mode: Read Write
TPS > Higher Is Better
db performance by filesystem: ext4 connected by usb2 SATA enclosure . 49 |=====


PostgreSQL pgbench 13.0
Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency
ms < Lower Is Better
db performance by filesystem: ext4 connected by usb2 SATA enclosure . 1014.69 |