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","DB performance by FS: Btrfs on 7200rpm SAS drive","DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4","DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS","USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib"
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","DB performance by FS: Btrfs on 7200rpm SAS drive","DB performance by FS: USB2 attached SATA enclosure 7200rpm HD with ext4","DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS","USB3 attached SATA 8TB Btrfs 7200rpm with compress:zlib"
"PostgreSQL pgbench - Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency (ms)",LIB,7.769,6.476,,6.795,6.942
"PostgreSQL pgbench - Scaling Factor: 1 - Clients: 100 - Mode: Read Only (TPS)",HIB,12883,15453,,14731,14428
"PostgreSQL pgbench - Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency (ms)",LIB,3.598,3.161,3.304,3.383,3.340
"PostgreSQL pgbench - Scaling Factor: 1 - Clients: 50 - Mode: Read Only (TPS)",HIB,13913,15831,15147,14790,14982
"PostgreSQL pgbench - Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency (ms)",LIB,1124.847,996.759,,2319.263,2642.108
"PostgreSQL pgbench - Scaling Factor: 1000 - Clients: 100 - Mode: Read Write (TPS)",HIB,89,101,,43,39
"PostgreSQL pgbench - Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency (ms)",LIB,748.923,602.106,,1719.510,1423.188
"PostgreSQL pgbench - Scaling Factor: 1000 - Clients: 50 - Mode: Read Write (TPS)",HIB,67,83,,32,36
"PostgreSQL pgbench - Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency (ms)",LIB,814.103,2235.742,,2160.822,2541.577
"PostgreSQL pgbench - Scaling Factor: 1000 - Clients: 100 - Mode: Read Only (TPS)",HIB,124,45,,47,41
"PostgreSQL pgbench - Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency (ms)",LIB,545.827,157.272,,143.598,808.508
"PostgreSQL pgbench - Scaling Factor: 100 - Clients: 100 - Mode: Read Write (TPS)",HIB,187,649,,717,126
"PostgreSQL pgbench - Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency (ms)",LIB,431.577,394.256,,1040.514,1423.262
"PostgreSQL pgbench - Scaling Factor: 1000 - Clients: 50 - Mode: Read Only (TPS)",HIB,117,127,,49,36
"PostgreSQL pgbench - Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency (ms)",LIB,66.228,76.699,,48.883,87.963
"PostgreSQL pgbench - Scaling Factor: 1000 - Clients: 1 - Mode: Read Write (TPS)",HIB,16,13,,21,11
"PostgreSQL pgbench - Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency (ms)",LIB,278.676,98.101,1014.692,178.709,186.917
"PostgreSQL pgbench - Scaling Factor: 100 - Clients: 50 - Mode: Read Write (TPS)",HIB,181,513,49,311,279
"PostgreSQL pgbench - Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency (ms)",LIB,231.034,9.034,,140.501,10.991
"PostgreSQL pgbench - Scaling Factor: 100 - Clients: 100 - Mode: Read Only (TPS)",HIB,455,11077,,3582,9114
"PostgreSQL pgbench - Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency (ms)",LIB,26.808,79.164,,24.546,35.198
"PostgreSQL pgbench - Scaling Factor: 1000 - Clients: 1 - Mode: Read Only (TPS)",HIB,38,15,,41,29
"PostgreSQL pgbench - Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency (ms)",LIB,130.745,31.995,861.414,29.753,5.371
"PostgreSQL pgbench - Scaling Factor: 100 - Clients: 50 - Mode: Read Only (TPS)",HIB,405,2643,58,5233,9327
"PostgreSQL pgbench - Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency (ms)",LIB,42.033,28.272,41.587,21.556,43.840
"PostgreSQL pgbench - Scaling Factor: 100 - Clients: 1 - Mode: Read Write (TPS)",HIB,27,36,24,49,26
"PostgreSQL pgbench - Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency (ms)",LIB,1109.973,2672.864,,1700.224,2069.793
"PostgreSQL pgbench - Scaling Factor: 1 - Clients: 100 - Mode: Read Write (TPS)",HIB,90,38,,59,49
"PostgreSQL pgbench - Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency (ms)",LIB,7.535,0.797,17.587,2.201,2.592
"PostgreSQL pgbench - Scaling Factor: 100 - Clients: 1 - Mode: Read Only (TPS)",HIB,133,2023,57,726,671
"PostgreSQL pgbench - Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency (ms)",LIB,549.816,1781.767,103.817,607.785,944.670
"PostgreSQL pgbench - Scaling Factor: 1 - Clients: 50 - Mode: Read Write (TPS)",HIB,91,28,489,90,54
"PostgreSQL pgbench - Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency (ms)",LIB,10.834,32.875,5.582,14.745,17.144
"PostgreSQL pgbench - Scaling Factor: 1 - Clients: 1 - Mode: Read Write (TPS)",HIB,92,31,240,69,59
"PostgreSQL pgbench - Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency (ms)",LIB,0.194,0.247,0.183,0.200,0.257
"PostgreSQL pgbench - Scaling Factor: 1 - Clients: 1 - Mode: Read Only (TPS)",HIB,5286,4054,5622,5223,4000