pgbench-usb3-sata-7200-btrfs 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 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
Processor Notes: Scaling Governor: cpufreq-dt schedutilSecurity Notes: 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
PostgreSQL pgbench This is a benchmark of PostgreSQL using pgbench for facilitating the database benchmarks. Learn more via the OpenBenchmarking.org test page.
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Only DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 1100 2200 3300 4400 5500 SE +/- 310.66, N = 12 5223 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 0.045 0.09 0.135 0.18 0.225 SE +/- 0.013, N = 12 0.200 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Write DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 15 30 45 60 75 SE +/- 2.26, N = 15 69 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 4 8 12 16 20 SE +/- 0.49, N = 15 14.75 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Only DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 3K 6K 9K 12K 15K SE +/- 116.66, N = 3 14790 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 0.7612 1.5224 2.2836 3.0448 3.806 SE +/- 0.027, N = 3 3.383 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Only DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 3K 6K 9K 12K 15K SE +/- 164.46, N = 3 14731 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 2 4 6 8 10 SE +/- 0.075, N = 3 6.795 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Write DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 20 40 60 80 100 SE +/- 7.24, N = 12 90 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 130 260 390 520 650 SE +/- 56.42, N = 12 607.79 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Only DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 160 320 480 640 800 SE +/- 277.40, N = 9 726 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 0.4952 0.9904 1.4856 1.9808 2.476 SE +/- 0.319, N = 9 2.201 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Write DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 13 26 39 52 65 SE +/- 0.81, N = 12 59 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 400 800 1200 1600 2000 SE +/- 23.22, N = 12 1700.22 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Write DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 11 22 33 44 55 SE +/- 3.50, N = 12 49 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 5 10 15 20 25 SE +/- 1.74, N = 12 21.56 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Only DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 1100 2200 3300 4400 5500 SE +/- 1301.79, N = 12 5233 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 7 14 21 28 35 SE +/- 9.47, N = 12 29.75 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 9 18 27 36 45 SE +/- 0.48, N = 4 41 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 6 12 18 24 30 SE +/- 0.28, N = 4 24.55 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Only DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 800 1600 2400 3200 4000 SE +/- 1272.56, N = 12 3582 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 30 60 90 120 150 SE +/- 36.74, N = 12 140.50 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Write DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 70 140 210 280 350 SE +/- 32.93, N = 9 311 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 40 80 120 160 200 SE +/- 22.41, N = 9 178.71 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 5 10 15 20 25 SE +/- 0.51, N = 9 21 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 11 22 33 44 55 SE +/- 1.12, N = 9 48.88 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 11 22 33 44 55 SE +/- 2.35, N = 9 49 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 200 400 600 800 1000 SE +/- 54.31, N = 9 1040.51 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Write DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 150 300 450 600 750 SE +/- 37.35, N = 10 717 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 30 60 90 120 150 SE +/- 8.54, N = 10 143.60 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 11 22 33 44 55 SE +/- 2.64, N = 6 47 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 500 1000 1500 2000 2500 SE +/- 131.07, N = 6 2160.82 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 7 14 21 28 35 SE +/- 3.61, N = 6 32 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 400 800 1200 1600 2000 SE +/- 279.34, N = 6 1719.51 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 10 20 30 40 50 SE +/- 0.34, N = 3 43 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
OpenBenchmarking.org ms, Fewer Is Better PostgreSQL pgbench 13.0 Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS 500 1000 1500 2000 2500 SE +/- 18.18, N = 3 2319.26 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -ldl -lm
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
Processor Notes: Scaling Governor: cpufreq-dt schedutilSecurity Notes: 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
Testing initiated at 2 July 2021 00:32 by user root.