pgbench-sas-btrfs-7200

DB performance by FS: Btrfs on 7200rpm SAS drive

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 2106305-IB-PGBENCHSA08
Jump To Table - Results

Statistics

Remove Outliers Before Calculating Averages

Graph Settings

Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Result
Identifier
View Logs
Performance Per
Dollar
Date
Run
  Test
  Duration
DB performance by FS: Btrfs on 7200rpm SAS drive
June 29 2021
  2 Days, 6 Hours, 55 Minutes
Only show results matching title/arguments (delimit multiple options with a comma):
Do not show results matching title/arguments (delimit multiple options with a comma):

pgbench-sas-btrfs-7200, "PostgreSQL pgbench 13.0 - Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average Latency", Lower Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",99.397,74.125,91.486,85.215,84.214,92.972,26.739 "PostgreSQL pgbench 13.0 - Scaling Factor: 1000 - Clients: 1 - Mode: Read Only", Higher Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",10.066153,13.499782,10.936827,11.740288,11.880456,10.762736,37.422379 "PostgreSQL pgbench 13.0 - Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average Latency", Lower Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",386.738,422.768,394.696,409.313,407.338,382.243,368.821,403.813,372.57 "PostgreSQL pgbench 13.0 - Scaling Factor: 1000 - Clients: 50 - Mode: Read Only", Higher Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",129.381564,118.344308,126.758449,122.235332,122.825513,130.892014,135.656661,123.900797,134.287274 "PostgreSQL pgbench 13.0 - Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency", Lower Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",76.664,66.781,79.611,79.505,70.435,89,82.212,69.9,76.184 "PostgreSQL pgbench 13.0 - Scaling Factor: 1000 - Clients: 1 - Mode: Read Write", Higher Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",13.049879,14.986431,12.569901,12.58568,14.206177,11.242928,12.171307,14.31498,13.134352 "PostgreSQL pgbench 13.0 - Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average Latency", Lower Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",586.409,640.572,624.121,613.816,613.934,598.058,541.44,557.83,642.771 "PostgreSQL pgbench 13.0 - Scaling Factor: 1000 - Clients: 50 - Mode: Read Write", Higher Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",85.320108,78.106729,80.165345,81.510219,81.493951,83.657998,92.406364,89.689609,77.839883 "PostgreSQL pgbench 13.0 - Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average Latency", Lower Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",2207.287,2249.256,2387.945,2080.406,2387.437,2414.358,1923.507 "PostgreSQL pgbench 13.0 - Scaling Factor: 1000 - Clients: 100 - Mode: Read Only", Higher Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",45.332194,44.485478,41.903487,48.096632,41.910755,41.443173,52.020367 "PostgreSQL pgbench 13.0 - Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency", Lower Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",909.935,891.873,954.178,1166.412,1087.15,971.003 "PostgreSQL pgbench 13.0 - Scaling Factor: 1000 - Clients: 100 - Mode: Read Write", Higher Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",109.966073,112.195035,104.870222,85.792298,92.050958,103.052314 "PostgreSQL pgbench 13.0 - Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency", Lower Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",96.517,88.623,120.14,102.791,96.69,99.795,91.01,95.751,100.79,93.684,94.523,96.901 "PostgreSQL pgbench 13.0 - Scaling Factor: 100 - Clients: 50 - Mode: Read Write", Higher Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",518.400216,564.568162,416.468143,486.749681,517.495838,501.343178,549.7945,522.508743,496.390608,534.054491,529.324903,516.332874 "PostgreSQL pgbench 13.0 - Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency", Lower Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",224.619,163.975,146.552,142.321,140.365,149.649,178.847,134.42,144.35,143.407,175.587,143.177 "PostgreSQL pgbench 13.0 - Scaling Factor: 100 - Clients: 100 - Mode: Read Write", Higher Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",445.488899,610.286452,682.853296,703.079332,712.921566,668.643563,559.505615,744.436989,693.232333,697.75796,569.871391,698.906856 "PostgreSQL pgbench 13.0 - Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency", Lower Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",4.468,17.928,33.052,27.386,27.602,33.615,28.568,25.605,20.795,20.437,23.699,120.783 "PostgreSQL pgbench 13.0 - Scaling Factor: 100 - Clients: 50 - Mode: Read Only", Higher Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",11200.529429,2790.847593,1513.826256,1827.006647,1812.783548,1488.405795,1751.418072,1954.054084,2406.091727,2448.257866,2111.212076,414.256416 "PostgreSQL pgbench 13.0 - Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency", Lower Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",29.854,26.278,24.8,29.243,27.995,30.894,26.825,26.09,27.615,26.146,32.49,31.037 "PostgreSQL pgbench 13.0 - Scaling Factor: 100 - Clients: 1 - Mode: Read Write", Higher Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",33.517039,38.078111,40.350274,34.21764,35.740174,32.390011,37.306964,38.354957,36.240983,38.267957,30.792919,32.238619 "PostgreSQL pgbench 13.0 - Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency", Lower Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",0.994,1.334,1.671,0.323,0.329,0.321,0.357,0.319,1.526 "PostgreSQL pgbench 13.0 - Scaling Factor: 100 - Clients: 1 - Mode: Read Only", Higher Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",1006.322297,749.901586,598.752214,3094.136708,3042.231058,3113.435302,2805.026488,3137.596261,655.655042 "PostgreSQL pgbench 13.0 - Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average Latency", Lower Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",1425.077,1675.692,1896.257,2298.144,1879.091,1453.987,1596.512,1684.046,1713.73,1959.33,1857.642,1723.921,2010.384,1791.213,1761.473 "PostgreSQL pgbench 13.0 - Scaling Factor: 1 - Clients: 50 - Mode: Read Write", Higher Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",35.107615,29.856053,26.384259,21.769602,26.624444,34.408569,31.337921,29.707065,29.193,25.533102,26.9344,29.019597,24.884887,27.930075,28.401897 "PostgreSQL pgbench 13.0 - Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency", Lower Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",25.998,33.422,31.273,29.544,35.274,37.562,28.164,36.524,38.976,37.074,32.603,35.284,26.661,28.383,36.376 "PostgreSQL pgbench 13.0 - Scaling Factor: 1 - Clients: 1 - Mode: Read Write", Higher Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",38.482406,29.93338,31.990024,33.8641,28.363506,26.634404,35.524421,27.392609,25.66933,26.985392,30.684749,28.353093,37.526192,35.249655,27.503982 "PostgreSQL pgbench 13.0 - Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency", Lower Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",2840.928,2600.247,2652.536,2824.537,2947.712,2837.803,2646.789,2669.468,2698.317,2482,2560.728,2487.335,2588.309,2722.641,2533.605 "PostgreSQL pgbench 13.0 - Scaling Factor: 1 - Clients: 100 - Mode: Read Write", Higher Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",35.219634,38.48022,37.720384,35.424151,33.942272,35.259233,37.803873,37.481469,37.081082,40.313682,39.073672,40.227382,38.656909,36.749878,39.492432 "PostgreSQL pgbench 13.0 - Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency", Lower Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",8.984,9.054,9.063 "PostgreSQL pgbench 13.0 - Scaling Factor: 100 - Clients: 100 - Mode: Read Only", Higher Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",11138.157957,11052.178137,11041.339228 "PostgreSQL pgbench 13.0 - Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average Latency", Lower Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",0.245,0.248,0.248 "PostgreSQL pgbench 13.0 - Scaling Factor: 1 - Clients: 1 - Mode: Read Only", Higher Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",4089.351633,4031.960012,4040.942609 "PostgreSQL pgbench 13.0 - Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average Latency", Lower Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",6.454,6.384,6.591 "PostgreSQL pgbench 13.0 - Scaling Factor: 1 - Clients: 100 - Mode: Read Only", Higher Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",15503.627465,15674.264593,15182.250418 "PostgreSQL pgbench 13.0 - Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average Latency", Lower Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",3.207,3.168,3.108 "PostgreSQL pgbench 13.0 - Scaling Factor: 1 - Clients: 50 - Mode: Read Only", Higher Results Are Better "DB performance by FS: Btrfs on 7200rpm SAS drive",15601.528627,15791.549802,16098.642192