Compare your own system(s) to this result file with the
Phoronix Test Suite by running the command:
phoronix-test-suite benchmark 2107047-IB-MERGE136101
pgbench-ext4-SATA
DB performance testing by FS: SATA attached variable rpm HD with ext4
,,"DB performance by FS: SATA variable rpm HD with ext4","USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib","DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4","DB performance by FS: Btrfs on 7200rpm SAS drive","DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS"
Processor,,ARMv8 Cortex-A72 @ 1.42GHz (6 Cores),ARMv8 Cortex-A72 @ 1.42GHz (6 Cores),ARMv8 Cortex-A72 @ 1.42GHz (6 Cores),ARMv8 Cortex-A72 @ 1.42GHz (6 Cores),ARMv8 Cortex-A72 @ 1.42GHz (6 Cores)
Motherboard,,Pine64 RockPro64 v2.1,Pine64 RockPro64 v2.1,Pine64 RockPro64 v2.1,Pine64 RockPro64 v2.1,Pine64 RockPro64 v2.1
Chipset,,Fuzhou Rockchip RK3399,Fuzhou Rockchip RK3399,Fuzhou Rockchip RK3399,Fuzhou Rockchip RK3399,Fuzhou Rockchip RK3399
Memory,,4096MB,4096MB,4096MB,4096MB,4096MB
Disk,,4001GB HGST HDS5C4040AL + 8002GB HUH72808CLAR8000 + 4001GB + 2 x 8002GB 728080ALE600 + 31GB SD32G,4001GB HGST HDS5C4040AL + 8002GB HUH72808CLAR8000 + 4001GB + 2 x 8002GB 728080ALE600 + 31GB SD32G,4001GB HGST HDS5C4040AL + 8002GB HUH72808CLAR8000 + 4001GB + 2 x 8002GB 728080ALE600 + 31GB SD32G,4001GB HGST HDS5C4040AL + 8002GB HUH72808CLAR8000 + 4001GB + 2 x 8002GB 728080ALE600 + 31GB SD32G,4001GB HGST HDS5C4040AL + 8002GB HUH72808CLAR8000 + 4001GB + 2 x 8002GB 728080ALE600 + 31GB SD32G
OS,,Gentoo/Linux,Gentoo/Linux,Gentoo/Linux,Gentoo/Linux,Gentoo/Linux
Kernel,,5.6.0-1137-ayufan-ge57f05e7bf8f (aarch64),5.6.0-1137-ayufan-ge57f05e7bf8f (aarch64),5.6.0-1137-ayufan-ge57f05e7bf8f (aarch64),5.6.0-1137-ayufan-ge57f05e7bf8f (aarch64),5.6.0-1137-ayufan-ge57f05e7bf8f (aarch64)
Compiler,,GCC 11.1.0,GCC 11.1.0,GCC 11.1.0,GCC 11.1.0,GCC 11.1.0
File-System,,ext4,btrfs,ext4,btrfs,btrfs
,,"DB performance by FS: SATA variable rpm HD with ext4","USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib","DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4","DB performance by FS: Btrfs on 7200rpm SAS drive","DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS"
"PostgreSQL pgbench - Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency (ms)",LIB,7.769,6.942,,6.476,6.795
"PostgreSQL pgbench - Scaling Factor: 1 - Clients: 100 - Mode: Read Only (TPS)",HIB,12883,14428,,15453,14731
"PostgreSQL pgbench - Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency (ms)",LIB,3.598,3.340,3.304,3.161,3.383
"PostgreSQL pgbench - Scaling Factor: 1 - Clients: 50 - Mode: Read Only (TPS)",HIB,13913,14982,15147,15831,14790
"PostgreSQL pgbench - Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency (ms)",LIB,1124.847,2642.108,,996.759,2319.263
"PostgreSQL pgbench - Scaling Factor: 1000 - Clients: 100 - Mode: Read Write (TPS)",HIB,89,39,,101,43
"PostgreSQL pgbench - Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency (ms)",LIB,748.923,1423.188,,602.106,1719.510
"PostgreSQL pgbench - Scaling Factor: 1000 - Clients: 50 - Mode: Read Write (TPS)",HIB,67,36,,83,32
"PostgreSQL pgbench - Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency (ms)",LIB,814.103,2541.577,,2235.742,2160.822
"PostgreSQL pgbench - Scaling Factor: 1000 - Clients: 100 - Mode: Read Only (TPS)",HIB,124,41,,45,47
"PostgreSQL pgbench - Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency (ms)",LIB,545.827,808.508,,157.272,143.598
"PostgreSQL pgbench - Scaling Factor: 100 - Clients: 100 - Mode: Read Write (TPS)",HIB,187,126,,649,717
"PostgreSQL pgbench - Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency (ms)",LIB,431.577,1423.262,,394.256,1040.514
"PostgreSQL pgbench - Scaling Factor: 1000 - Clients: 50 - Mode: Read Only (TPS)",HIB,117,36,,127,49
"PostgreSQL pgbench - Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency (ms)",LIB,66.228,87.963,,76.699,48.883
"PostgreSQL pgbench - Scaling Factor: 1000 - Clients: 1 - Mode: Read Write (TPS)",HIB,16,11,,13,21
"PostgreSQL pgbench - Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency (ms)",LIB,278.676,186.917,1014.692,98.101,178.709
"PostgreSQL pgbench - Scaling Factor: 100 - Clients: 50 - Mode: Read Write (TPS)",HIB,181,279,49,513,311
"PostgreSQL pgbench - Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency (ms)",LIB,231.034,10.991,,9.034,140.501
"PostgreSQL pgbench - Scaling Factor: 100 - Clients: 100 - Mode: Read Only (TPS)",HIB,455,9114,,11077,3582
"PostgreSQL pgbench - Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency (ms)",LIB,26.808,35.198,,79.164,24.546
"PostgreSQL pgbench - Scaling Factor: 1000 - Clients: 1 - Mode: Read Only (TPS)",HIB,38,29,,15,41
"PostgreSQL pgbench - Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency (ms)",LIB,130.745,5.371,861.414,31.995,29.753
"PostgreSQL pgbench - Scaling Factor: 100 - Clients: 50 - Mode: Read Only (TPS)",HIB,405,9327,58,2643,5233
"PostgreSQL pgbench - Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency (ms)",LIB,42.033,43.840,41.587,28.272,21.556
"PostgreSQL pgbench - Scaling Factor: 100 - Clients: 1 - Mode: Read Write (TPS)",HIB,27,26,24,36,49
"PostgreSQL pgbench - Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency (ms)",LIB,1109.973,2069.793,,2672.864,1700.224
"PostgreSQL pgbench - Scaling Factor: 1 - Clients: 100 - Mode: Read Write (TPS)",HIB,90,49,,38,59
"PostgreSQL pgbench - Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency (ms)",LIB,7.535,2.592,17.587,0.797,2.201
"PostgreSQL pgbench - Scaling Factor: 100 - Clients: 1 - Mode: Read Only (TPS)",HIB,133,671,57,2023,726
"PostgreSQL pgbench - Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency (ms)",LIB,549.816,944.670,103.817,1781.767,607.785
"PostgreSQL pgbench - Scaling Factor: 1 - Clients: 50 - Mode: Read Write (TPS)",HIB,91,54,489,28,90
"PostgreSQL pgbench - Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency (ms)",LIB,10.834,17.144,5.582,32.875,14.745
"PostgreSQL pgbench - Scaling Factor: 1 - Clients: 1 - Mode: Read Write (TPS)",HIB,92,59,240,31,69
"PostgreSQL pgbench - Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency (ms)",LIB,0.194,0.257,0.183,0.247,0.200
"PostgreSQL pgbench - Scaling Factor: 1 - Clients: 1 - Mode: Read Only (TPS)",HIB,5286,4000,5622,4054,5223