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,
"PostgreSQL pgbench 13.0 - Scaling Factor: 1 - Clients: 1 - Mode: Read Only",
Higher Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",4721.967991,5727.909617,5175.289034,6709.67416,6412.560409,5813.219901,6453.534245,4603.892317,4075.203762,3401.80049,5616.37833,3969.674717
"PostgreSQL pgbench 13.0 - Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency",
Lower Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",0.212,0.175,0.193,0.149,0.156,0.172,0.155,0.217,0.246,0.294,0.178,0.252
"PostgreSQL pgbench 13.0 - Scaling Factor: 1 - Clients: 1 - Mode: Read Write",
Higher Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",83.386646,56.888737,59.21507,58.60454,63.277188,77.287922,72.417106,78.004173,69.692222,71.667622,58.395415,79.304198,74.470517,60.749065,70.183983
"PostgreSQL pgbench 13.0 - Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency",
Lower Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",12.002,17.585,16.897,17.072,15.81,12.945,13.815,12.827,14.356,13.961,17.133,12.616,13.435,16.47,14.255
"PostgreSQL pgbench 13.0 - Scaling Factor: 1 - Clients: 50 - Mode: Read Only",
Higher Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",14851.467909,14564.87161,14954.908348
"PostgreSQL pgbench 13.0 - Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency",
Lower Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",3.369,3.435,3.346
"PostgreSQL pgbench 13.0 - Scaling Factor: 1 - Clients: 100 - Mode: Read Only",
Higher Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",14489.985933,15045.500121,14658.325288
"PostgreSQL pgbench 13.0 - Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency",
Lower Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",6.906,6.651,6.827
"PostgreSQL pgbench 13.0 - Scaling Factor: 1 - Clients: 50 - Mode: Read Write",
Higher Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",113.436456,95.121056,111.623853,110.018014,111.501562,113.930733,108.13296,73.816727,52.26922,61.348334,56.943839,67.281383
"PostgreSQL pgbench 13.0 - Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency",
Lower Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",441.062,525.984,448.239,454.768,448.731,439.167,462.684,677.801,957.245,815.517,878.602,743.622
"PostgreSQL pgbench 13.0 - Scaling Factor: 100 - Clients: 1 - Mode: Read Only",
Higher Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",393.929969,316.532959,405.667109,460.302134,288.806039,441.482375,441.278589,890.636998,2896.045029
"PostgreSQL pgbench 13.0 - Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency",
Lower Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",2.54,3.161,2.467,2.174,3.464,2.266,2.267,1.123,0.346
"PostgreSQL pgbench 13.0 - Scaling Factor: 1 - Clients: 100 - Mode: Read Write",
Higher Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",61.339697,59.126598,57.980942,57.366513,55.079217,58.76481,62.349602,61.530331,56.480625,58.626519,55.1959,63.862617
"PostgreSQL pgbench 13.0 - Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency",
Lower Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",1631.269,1692.428,1725.797,1744.321,1816.73,1702.752,1604.908,1626.259,1771.634,1706.8,1812.955,1566.83
"PostgreSQL pgbench 13.0 - Scaling Factor: 100 - Clients: 1 - Mode: Read Write",
Higher Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",38.299831,49.044101,59.34759,46.019959,66.765664,44.696618,65.435943,35.972971,60.826909,28.048759,53.748666,44.803509
"PostgreSQL pgbench 13.0 - Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency",
Lower Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",26.123,20.402,16.858,21.741,14.986,22.391,15.289,27.814,16.448,35.674,18.614,22.332
"PostgreSQL pgbench 13.0 - Scaling Factor: 100 - Clients: 50 - Mode: Read Only",
Higher Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",878.165747,10288.412241,2859.42537,528.328443,2670.335522,593.757069,11173.670686,11181.164582,11045.314702,1065.817654,6119.878147,4391.730654
"PostgreSQL pgbench 13.0 - Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency",
Lower Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",56.975,4.863,17.498,94.703,18.739,84.266,4.478,4.475,4.53,46.943,8.176,11.393
"PostgreSQL pgbench 13.0 - Scaling Factor: 1000 - Clients: 1 - Mode: Read Only",
Higher Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",40.004261,42.178981,40.571792,40.354963
"PostgreSQL pgbench 13.0 - Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency",
Lower Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",25.009,23.721,24.66,24.792
"PostgreSQL pgbench 13.0 - Scaling Factor: 100 - Clients: 100 - Mode: Read Only",
Higher Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",327.228404,10704.791124,351.76727,403.256775,1083.869391,3149.650527,10336.290364,10681.48688,607.019438,300.279354,573.182192,4460.122418
"PostgreSQL pgbench 13.0 - Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency",
Lower Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",305.808,9.349,284.464,248.145,92.321,31.771,9.681,9.369,164.841,333.245,174.582,22.436
"PostgreSQL pgbench 13.0 - Scaling Factor: 100 - Clients: 50 - Mode: Read Write",
Higher Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",332.414236,259.550398,390.986201,356.882751,471.767749,215.58064,369.288266,248.898392,155.245537
"PostgreSQL pgbench 13.0 - Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency",
Lower Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",150.516,192.769,127.975,140.192,106.054,232.085,135.494,201.012,322.284
"PostgreSQL pgbench 13.0 - Scaling Factor: 1000 - Clients: 1 - Mode: Read Write",
Higher Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",20.06469,20.281797,23.995226,18.855064,20.096748,21.312196,20.027792,21.244519,19.180644
"PostgreSQL pgbench 13.0 - Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency",
Lower Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",49.865,49.345,41.695,53.066,49.787,46.944,49.97,47.094,52.178
"PostgreSQL pgbench 13.0 - Scaling Factor: 1000 - Clients: 50 - Mode: Read Only",
Higher Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",51.236301,40.39591,56.54034,42.344704,50.122035,55.947339,52.091527,54.991989,37.893167
"PostgreSQL pgbench 13.0 - Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency",
Lower Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",976.479,1238.524,884.901,1181.557,998.224,894.289,960.465,909.867,1320.322
"PostgreSQL pgbench 13.0 - Scaling Factor: 100 - Clients: 100 - Mode: Read Write",
Higher Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",688.374599,732.143584,833.552612,816.240811,706.075681,807.970342,523.797987,849.229671,683.664624,525.310314
"PostgreSQL pgbench 13.0 - Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency",
Lower Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",145.377,136.678,120.047,122.594,141.722,123.846,191.039,117.831,146.364,190.481
"PostgreSQL pgbench 13.0 - Scaling Factor: 1000 - Clients: 100 - Mode: Read Only",
Higher Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",49.225634,52.291403,49.791831,53.330145,39.942681,38.145174
"PostgreSQL pgbench 13.0 - Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency",
Lower Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",2032.701,1913.585,2009.835,1877.457,2506.701,2624.651
"PostgreSQL pgbench 13.0 - Scaling Factor: 1000 - Clients: 50 - Mode: Read Write",
Higher Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",36.378889,32.323416,39.646896,16.563114,27.684218,39.50309
"PostgreSQL pgbench 13.0 - Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency",
Lower Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",1376.353,1548.96,1263.203,3051.036,1810.451,1267.055
"PostgreSQL pgbench 13.0 - Scaling Factor: 1000 - Clients: 100 - Mode: Read Write",
Higher Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",43.549784,43.421062,42.483964
"PostgreSQL pgbench 13.0 - Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency",
Lower Results Are Better
"DB performance by FS: USB3 attached SATA enclosure 7200rpm HD with BTRFS",2297.753,2304.63,2355.407