pgbench-usb3-sata-7200-btrfs

DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS

HTML result view exported from: https://openbenchmarking.org/result/2107020-IB-PGBENCHUS59&gru.

pgbench-usb3-sata-7200-btrfsProcessorMotherboardChipsetMemoryDiskOSKernelCompilerFile-SystemDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFSARMv8 Cortex-A72 @ 1.42GHz (6 Cores)Pine64 RockPro64 v2.1Fuzhou Rockchip RK33994096MB4001GB HGST HDS5C4040AL + 8002GB HUH72808CLAR8000 + 4001GB + 2 x 8002GB 728080ALE600 + 31GB SD32GGentoo/Linux5.6.0-1137-ayufan-ge57f05e7bf8f (aarch64)GCC 11.1.0btrfsOpenBenchmarking.org- Scaling Governor: cpufreq-dt schedutil- itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Vulnerable + spectre_v1: Mitigation of __user pointer sanitization + spectre_v2: Vulnerable + tsx_async_abort: Not affected

pgbench-usb3-sata-7200-btrfspgbench: 1 - 1 - Read Onlypgbench: 1 - 1 - Read Writepgbench: 1 - 50 - Read Onlypgbench: 1 - 100 - Read Onlypgbench: 1 - 50 - Read Writepgbench: 100 - 1 - Read Onlypgbench: 1 - 100 - Read Writepgbench: 100 - 1 - Read Writepgbench: 100 - 50 - Read Onlypgbench: 1000 - 1 - Read Onlypgbench: 100 - 100 - Read Onlypgbench: 100 - 50 - Read Writepgbench: 1000 - 1 - Read Writepgbench: 1000 - 50 - Read Onlypgbench: 100 - 100 - Read Writepgbench: 1000 - 100 - Read Onlypgbench: 1000 - 50 - Read Writepgbench: 1000 - 100 - Read Writepgbench: 1 - 1 - Read Only - Average Latencypgbench: 1 - 1 - Read Write - Average Latencypgbench: 1 - 50 - Read Only - Average Latencypgbench: 1 - 100 - Read Only - Average Latencypgbench: 1 - 50 - Read Write - Average Latencypgbench: 100 - 1 - Read Only - Average Latencypgbench: 1 - 100 - Read Write - Average Latencypgbench: 100 - 1 - Read Write - Average Latencypgbench: 100 - 50 - Read Only - Average Latencypgbench: 1000 - 1 - Read Only - Average Latencypgbench: 100 - 100 - Read Only - Average Latencypgbench: 100 - 50 - Read Write - Average Latencypgbench: 1000 - 1 - Read Write - Average Latencypgbench: 1000 - 50 - Read Only - Average Latencypgbench: 100 - 100 - Read Write - Average Latencypgbench: 1000 - 100 - Read Only - Average Latencypgbench: 1000 - 50 - Read Write - Average Latencypgbench: 1000 - 100 - Read Write - Average LatencyDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS5223691479014731907265949523341358231121497174732430.20014.7453.3836.795607.7852.2011700.22421.55629.75324.546140.501178.70948.8831040.514143.5982160.8221719.5102319.263OpenBenchmarking.org

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 1 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 1 - Mode: Read OnlyDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS11002200330044005500SE +/- 310.66, N = 1252231. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 1 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 1 - Mode: Read WriteDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS1530456075SE +/- 2.26, N = 15691. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 50 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 50 - Mode: Read OnlyDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS3K6K9K12K15KSE +/- 116.66, N = 3147901. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 100 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 100 - Mode: Read OnlyDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS3K6K9K12K15KSE +/- 164.46, N = 3147311. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 50 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 50 - Mode: Read WriteDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS20406080100SE +/- 7.24, N = 12901. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 1 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 1 - Mode: Read OnlyDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS160320480640800SE +/- 277.40, N = 97261. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 100 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 100 - Mode: Read WriteDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS1326395265SE +/- 0.81, N = 12591. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 1 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 1 - Mode: Read WriteDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS1122334455SE +/- 3.50, N = 12491. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 50 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 50 - Mode: Read OnlyDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS11002200330044005500SE +/- 1301.79, N = 1252331. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 1 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 1 - Mode: Read OnlyDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS918273645SE +/- 0.48, N = 4411. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 100 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 100 - Mode: Read OnlyDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS8001600240032004000SE +/- 1272.56, N = 1235821. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 50 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 50 - Mode: Read WriteDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS70140210280350SE +/- 32.93, N = 93111. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 1 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 1 - Mode: Read WriteDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS510152025SE +/- 0.51, N = 9211. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 50 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 50 - Mode: Read OnlyDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS1122334455SE +/- 2.35, N = 9491. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 100 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 100 - Mode: Read WriteDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS150300450600750SE +/- 37.35, N = 107171. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 100 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 100 - Mode: Read OnlyDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS1122334455SE +/- 2.64, N = 6471. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 50 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 50 - Mode: Read WriteDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS714212835SE +/- 3.61, N = 6321. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 100 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 100 - Mode: Read WriteDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS1020304050SE +/- 0.34, N = 3431. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average LatencyDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS0.0450.090.1350.180.225SE +/- 0.013, N = 120.2001. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average LatencyDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS48121620SE +/- 0.49, N = 1514.751. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average LatencyDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS0.76121.52242.28363.04483.806SE +/- 0.027, N = 33.3831. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average LatencyDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS246810SE +/- 0.075, N = 36.7951. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average LatencyDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS130260390520650SE +/- 56.42, N = 12607.791. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average LatencyDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS0.49520.99041.48561.98082.476SE +/- 0.319, N = 92.2011. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average LatencyDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS400800120016002000SE +/- 23.22, N = 121700.221. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average LatencyDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS510152025SE +/- 1.74, N = 1221.561. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average LatencyDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS714212835SE +/- 9.47, N = 1229.751. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average LatencyDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS612182430SE +/- 0.28, N = 424.551. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average LatencyDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS306090120150SE +/- 36.74, N = 12140.501. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average LatencyDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS4080120160200SE +/- 22.41, N = 9178.711. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average LatencyDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS1122334455SE +/- 1.12, N = 948.881. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average LatencyDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS2004006008001000SE +/- 54.31, N = 91040.511. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average LatencyDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS306090120150SE +/- 8.54, N = 10143.601. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average LatencyDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS5001000150020002500SE +/- 131.07, N = 62160.821. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average LatencyDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS400800120016002000SE +/- 279.34, N = 61719.511. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

PostgreSQL pgbench

Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 13.0Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average LatencyDB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS5001000150020002500SE +/- 18.18, N = 32319.261. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm

Phoronix Test Suite v10.8.4