mirrored zpool on 2x 128G SATA SSD, modified zfs settings: recordsize=32k, default zfs settings: logbias=latency, sync=standard, ashift=12, no SLOG, no L2ARC
Compare your own system(s) to this result file with the
Phoronix Test Suite by running the command:
phoronix-test-suite benchmark 2102248-HA-POSTGRESQ18
PostgreSQL on ZFS,
"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
"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
"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
"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
"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
"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
"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
"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