Compare your own system(s) to this result file with the
Phoronix Test Suite by running the command:
phoronix-test-suite benchmark 2102248-HA-POSTGRESQ23
PostgreSQL on ZFS,
"PostgreSQL pgbench 13.0 - Scaling Factor: 1 - Clients: 1 - Mode: Read Write",
Higher Results Are Better
"default",172.463371,171.058361,155.824907,169.460366,166.17409,171.266059,171.757509,169.142153,171.041203,165.942923,165.47341,174.994968,175.87916,171.470028,171.513344
"sync=disabled",4871.086851,4809.560287,4695.364472
"recordsize=32k",169.905563,176.400793,168.522603
"recordsize=32k + logbias=throughput",145.993894,149.047636,155.369775,155.838032,153.629686,155.589321,152.966519
"single SSD ext4",303.44222,301.822376,301.370515
"PostgreSQL pgbench 13.0 - Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average Latency",
Lower Results Are Better
"default",5.799,5.847,6.418,5.902,6.018,5.839,5.823,5.913,5.847,6.027,6.044,5.715,5.686,5.833,5.831
"sync=disabled",0.205,0.208,0.213
"recordsize=32k",5.886,5.669,5.934
"recordsize=32k + logbias=throughput",6.85,6.71,6.437,6.417,6.51,6.428,6.538
"single SSD ext4",3.296,3.314,3.318
"PostgreSQL pgbench 13.0 - Scaling Factor: 1 - Clients: 100 - Mode: Read Write",
Higher Results Are Better
"default",170.233896,173.548869,175.262715
"sync=disabled",4290.149046,4202.581572,4307.462457
"recordsize=32k",170.737961,171.553281,172.981263
"recordsize=32k + logbias=throughput",151.852471,112.118087,152.837827,155.872146,159.258389,159.114121,156.802346,157.327509,158.134658,151.162123,152.683667,157.152462,159.802615
"single SSD ext4",314.296601,312.127588,314.430006
"PostgreSQL pgbench 13.0 - Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average Latency",
Lower Results Are Better
"default",587.608,576.405,570.753
"sync=disabled",23.318,23.803,23.223
"recordsize=32k",585.884,583.1,578.282
"recordsize=32k + logbias=throughput",658.798,892.219,654.488,641.752,628.133,628.705,637.987,635.852,632.588,661.799,655.161,636.577,626.004
"single SSD ext4",318.28,320.491,318.164
"PostgreSQL pgbench 13.0 - Scaling Factor: 1000 - Clients: 1 - Mode: Read Write",
Higher Results Are Better
"default",76.659231,93.510258,92.124298,78.968451,98.629759,94.237032,91.668845,101.078003,99.606074
"sync=disabled",941.157056,1001.9736,1302.333204,1017.077724,865.285646,1152.194039,834.313552,981.580659,959.549891,912.492276,1077.757926,992.818515
"recordsize=32k",98.932105,98.16051,100.789351
"recordsize=32k + logbias=throughput",108.980702,104.196927,96.897311,103.67448,110.198044,101.23633,112.886467,106.560367,95.856927
"single SSD ext4",225.552054,225.694001,225.563729
"PostgreSQL pgbench 13.0 - Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average Latency",
Lower Results Are Better
"default",13.047,10.695,10.856,12.665,10.14,10.613,10.91,9.895,10.041
"sync=disabled",1.063,0.998,0.768,0.983,1.156,0.868,1.199,1.019,1.042,1.096,0.928,1.007
"recordsize=32k",10.109,10.188,9.923
"recordsize=32k + logbias=throughput",9.177,9.598,10.321,9.647,9.076,9.879,8.859,9.385,10.433
"single SSD ext4",4.434,4.431,4.434
"PostgreSQL pgbench 13.0 - Scaling Factor: 1000 - Clients: 100 - Mode: Read Write",
Higher Results Are Better
"default",765.493996,767.760919,807.10455,894.90301,606.459373,862.36439
"sync=disabled",1254.670635,977.919696,831.130901,872.266935,997.267702,1207.112348,1450.132859,925.180801,1015.718803,950.014995,770.936209,942.657596
"recordsize=32k",1147.685908,977.732971,747.81359,759.793927,1157.013183,886.069808,1131.289206,1156.4977,1010.443748
"recordsize=32k + logbias=throughput",1283.456509,1009.234463,1131.421995,1000.044333,1000.773468,964.336235,929.512496,1129.576442,1026.274411
"single SSD ext4",5141.698332,5122.481095,5122.646027
"PostgreSQL pgbench 13.0 - Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average Latency",
Lower Results Are Better
"default",130.674,130.305,123.963,111.806,164.935,116.014
"sync=disabled",79.738,102.304,120.361,114.688,100.309,82.873,68.989,108.129,98.486,105.305,129.772,106.122
"recordsize=32k",87.161,102.326,133.763,131.655,86.462,112.912,88.436,86.497,99.009
"recordsize=32k + logbias=throughput",77.94,99.122,88.419,100.038,99.96,103.743,107.62,88.558,97.47
"single SSD ext4",19.455,19.529,19.529