DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS
Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 2107020-IB-PGBENCHUS59
pgbench-usb3-sata-7200-btrfs
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS
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
PostgreSQL pgbench 13.0
Scaling Factor: 1 - Clients: 1 - Mode: Read Only
TPS > Higher Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 5223 |
PostgreSQL pgbench 13.0
Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency
ms < Lower Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 0.200 |
PostgreSQL pgbench 13.0
Scaling Factor: 1 - Clients: 1 - Mode: Read Write
TPS > Higher Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 69 |
PostgreSQL pgbench 13.0
Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency
ms < Lower Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 14.75 |
PostgreSQL pgbench 13.0
Scaling Factor: 1 - Clients: 50 - Mode: Read Only
TPS > Higher Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 14790 |
PostgreSQL pgbench 13.0
Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency
ms < Lower Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 3.383 |
PostgreSQL pgbench 13.0
Scaling Factor: 1 - Clients: 100 - Mode: Read Only
TPS > Higher Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 14731 |
PostgreSQL pgbench 13.0
Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency
ms < Lower Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 6.795 |
PostgreSQL pgbench 13.0
Scaling Factor: 1 - Clients: 50 - Mode: Read Write
TPS > Higher Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 90 |
PostgreSQL pgbench 13.0
Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency
ms < Lower Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 607.79 |
PostgreSQL pgbench 13.0
Scaling Factor: 100 - Clients: 1 - Mode: Read Only
TPS > Higher Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 726 |
PostgreSQL pgbench 13.0
Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency
ms < Lower Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 2.201 |
PostgreSQL pgbench 13.0
Scaling Factor: 1 - Clients: 100 - Mode: Read Write
TPS > Higher Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 59 |
PostgreSQL pgbench 13.0
Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency
ms < Lower Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 1700.22 |
PostgreSQL pgbench 13.0
Scaling Factor: 100 - Clients: 1 - Mode: Read Write
TPS > Higher Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 49 |
PostgreSQL pgbench 13.0
Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency
ms < Lower Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 21.56 |
PostgreSQL pgbench 13.0
Scaling Factor: 100 - Clients: 50 - Mode: Read Only
TPS > Higher Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 5233 |
PostgreSQL pgbench 13.0
Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency
ms < Lower Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 29.75 |
PostgreSQL pgbench 13.0
Scaling Factor: 1000 - Clients: 1 - Mode: Read Only
TPS > Higher Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 41 |
PostgreSQL pgbench 13.0
Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency
ms < Lower Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 24.55 |
PostgreSQL pgbench 13.0
Scaling Factor: 100 - Clients: 100 - Mode: Read Only
TPS > Higher Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 3582 |
PostgreSQL pgbench 13.0
Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency
ms < Lower Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 140.50 |
PostgreSQL pgbench 13.0
Scaling Factor: 100 - Clients: 50 - Mode: Read Write
TPS > Higher Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 311 |
PostgreSQL pgbench 13.0
Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency
ms < Lower Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 178.71 |
PostgreSQL pgbench 13.0
Scaling Factor: 1000 - Clients: 1 - Mode: Read Write
TPS > Higher Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 21 |
PostgreSQL pgbench 13.0
Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency
ms < Lower Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 48.88 |
PostgreSQL pgbench 13.0
Scaling Factor: 1000 - Clients: 50 - Mode: Read Only
TPS > Higher Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 49 |
PostgreSQL pgbench 13.0
Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency
ms < Lower Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 1040.51 |
PostgreSQL pgbench 13.0
Scaling Factor: 100 - Clients: 100 - Mode: Read Write
TPS > Higher Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 717 |
PostgreSQL pgbench 13.0
Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency
ms < Lower Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 143.60 |
PostgreSQL pgbench 13.0
Scaling Factor: 1000 - Clients: 100 - Mode: Read Only
TPS > Higher Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 47 |
PostgreSQL pgbench 13.0
Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency
ms < Lower Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 2160.82 |
PostgreSQL pgbench 13.0
Scaling Factor: 1000 - Clients: 50 - Mode: Read Write
TPS > Higher Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 32 |
PostgreSQL pgbench 13.0
Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency
ms < Lower Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 1719.51 |
PostgreSQL pgbench 13.0
Scaling Factor: 1000 - Clients: 100 - Mode: Read Write
TPS > Higher Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 43 |
PostgreSQL pgbench 13.0
Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency
ms < Lower Is Better
DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS . 2319.26 |