pgbench-usb3-sata-btrfs-7200-zlib
DB perf by FS: USB3 SATA HGST 8TB 7200rpm BTRFS compress:zlib


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
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
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
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
USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib . 17.14 |==============


PostgreSQL pgbench 13.0
Scaling Factor: 1 - Clients: 50 - Mode: Read Only
TPS > Higher Is Better
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib . 10.99 |==============


PostgreSQL pgbench 13.0
Scaling Factor: 100 - Clients: 50 - Mode: Read Write
TPS > Higher Is Better
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
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
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
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
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
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
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
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
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
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
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
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
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
USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib . 2642.11 |============