postgresql random io test with 2 SSD Kingston V+100 500GB in (software) Raid1

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



2 kingston V+100 500GB
Soft RAID1 (md)
ioscheduler [noop]
ext3
Linux pro-cdn1 2.6.26-2-amd64 #1 SMP Tue Jan 25 05:59:43 UTC 2011
x86_64 GNU/Linux
Filesystem            Size  Used Avail Use% Mounted on
/dev/md4              452G  301G  128G  71% /home/ssd
--------

Random 8KB read/write with 1% write
./pgiosim  -w1 -a1 -v -b 1000000 /home/ssd/big.1
Write Mode: 1%
Stallcheck at 1.000000
Verbose
Unknown units of blocks
Arg: 1
Read 1000000 blocks
Added /home/ssd/big.1

-------

3.20%,  32036 read,    300 written, 25625.08kB/sec 3203.14 iops
5.33%,  21283 read,    198 written, 17026.31kB/sec 2128.29 iops
7.47%,  21356 read,    245 written, 17084.73kB/sec 2135.59 iops
9.62%,  21511 read,    234 written, 17208.72kB/sec 2151.09 iops
11.78%,  21591 read,    216 written, 17271.71kB/sec 2158.96 iops
14.08%,  23032 read,    245 written, 18425.52kB/sec 2303.19 iops
16.53%,  24527 read,    228 written, 19621.52kB/sec 2452.69 iops
18.89%,  23535 read,    225 written, 18827.91kB/sec 2353.49 iops
21.19%,  23003 read,    229 written, 18402.34kB/sec 2300.29 iops
23.40%,  22139 read,    211 written, 17711.13kB/sec 2213.89 iops
25.66%,  22628 read,    225 written, 18102.33kB/sec 2262.79 iops
27.86%,  21983 read,    238 written, 17586.32kB/sec 2198.29 iops
30.14%,  22823 read,    211 written, 18258.31kB/sec 2282.29 iops
32.44%,  22975 read,    240 written, 18379.92kB/sec 2297.49 iops
34.83%,  23870 read,    214 written, 19095.92kB/sec 2386.99 iops
37.24%,  24129 read,    213 written, 19303.10kB/sec 2412.89 iops
39.49%,  22450 read,    210 written, 17959.92kB/sec 2244.99 iops
41.77%,  22827 read,    235 written, 18261.53kB/sec 2282.69 iops
43.98%,  22138 read,    218 written, 17710.30kB/sec 2213.79 iops
46.31%,  23293 read,    241 written, 18634.30kB/sec 2329.29 iops
48.86%,  25422 read,    258 written, 20337.52kB/sec 2542.19 iops
51.06%,  22091 read,    222 written, 17672.72kB/sec 2209.09 iops
53.46%,  23970 read,    215 written, 19175.93kB/sec 2396.99 iops
55.80%,  23359 read,    224 written, 18687.12kB/sec 2335.89 iops
58.04%,  22472 read,    232 written, 17977.24kB/sec 2247.16 iops
60.34%,  22981 read,    230 written, 18384.72kB/sec 2298.09 iops
62.17%,  18228 read,    192 written, 14580.33kB/sec 1822.54 iops
64.60%,  24336 read,    229 written, 19465.85kB/sec 2433.23 iops
66.89%,  22912 read,    210 written, 18329.52kB/sec 2291.19 iops
69.06%,  21677 read,    231 written, 17341.54kB/sec 2167.69 iops
71.28%,  22255 read,    210 written, 17803.91kB/sec 2225.49 iops
73.68%,  23928 read,    243 written, 19142.30kB/sec 2392.79 iops
75.90%,  22255 read,    205 written, 17803.93kB/sec 2225.49 iops
78.17%,  22641 read,    233 written, 18112.72kB/sec 2264.09 iops
80.50%,  23328 read,    235 written, 18662.29kB/sec 2332.79 iops
82.84%,  23379 read,    230 written, 18703.11kB/sec 2337.89 iops
84.90%,  20670 read,    236 written, 16535.95kB/sec 2066.99 iops
86.91%,  20018 read,    222 written, 16012.14kB/sec 2001.52 iops
89.24%,  23321 read,    235 written, 18654.39kB/sec 2331.80 iops
91.56%,  23224 read,    227 written, 18579.13kB/sec 2322.39 iops
94.05%,  24880 read,    262 written, 19903.93kB/sec 2487.99 iops
96.40%,  23549 read,    205 written, 18839.14kB/sec 2354.89 iops
98.80%,  23956 read,    230 written, 19164.73kB/sec 2395.59 iops

------
./pgiosim  -w10 -a1 -v -b 1000000 /home/ssd/big.1
Write Mode: 10%
Stallcheck at 1.000000
Verbose
Unknown units of blocks
Arg: 1
Read 1000000 blocks
Added /home/ssd/big.1

1.62%,  16226 read,   1642 written, 12979.00kB/sec 1622.37 iops
1.67%,    433 read,     38 written,  346.40kB/sec   43.30 iops
2.95%,  12839 read,   1282 written, 10271.06kB/sec 1283.88 iops
2.95%,      3 read,      0 written,    2.40kB/sec    0.30 iops
3.50%,   5500 read,    548 written, 4399.83kB/sec  549.98 iops
4.95%,  14524 read,   1468 written, 11619.12kB/sec 1452.39 iops
4.95%,      3 read,      1 written,    2.40kB/sec    0.30 iops
4.95%,      8 read,      0 written,    6.40kB/sec    0.80 iops
6.20%,  12471 read,   1241 written, 9976.67kB/sec 1247.08 iops
6.20%,      3 read,      0 written,    2.40kB/sec    0.30 iops
7.63%,  14272 read,   1445 written, 11417.26kB/sec 1427.16 iops
7.63%,      3 read,      0 written,    2.40kB/sec    0.30 iops
7.65%,    263 read,     22 written,  210.40kB/sec   26.30 iops
8.65%,   9930 read,    990 written, 7943.83kB/sec  992.98 iops
8.67%,    268 read,     24 written,  214.40kB/sec   26.80 iops
9.30%,   6296 read,    621 written, 5036.78kB/sec  629.60 iops
9.83%,   5233 read,    541 written, 4186.35kB/sec  523.29 iops
10.75%,   9222 read,    960 written, 7377.56kB/sec  922.20 iops
10.80%,    506 read,     52 written,  404.80kB/sec   50.60 iops
11.74%,   9417 read,    933 written, 7533.53kB/sec  941.69 iops
11.77%,    314 read,     29 written,  251.20kB/sec   31.40 iops
12.56%,   7906 read,    793 written, 6324.78kB/sec  790.60 iops
13.37%,   8052 read,    830 written, 6441.52kB/sec  805.19 iops
13.40%,    309 read,     29 written,  247.20kB/sec   30.90 iops
14.01%,   6116 read,    635 written, 4892.73kB/sec  611.59 iops
14.71%,   6994 read,    675 written, 5595.18kB/sec  699.40 iops
15.83%,  11205 read,   1188 written, 8953.19kB/sec 1119.15 iops
15.90%,    651 read,     68 written,  520.80kB/sec   65.10 iops
16.33%,   4355 read,    490 written, 3480.77kB/sec  435.10 iops
17.14%,   8098 read,    777 written, 6478.33kB/sec  809.79 iops
17.14%,      6 read,      0 written,    4.80kB/sec    0.60 iops
18.70%,  15603 read,   1622 written, 12482.33kB/sec 1560.29 iops
18.70%,      4 read,      0 written,    3.20kB/sec    0.40 iops
18.71%,     34 read,      5 written,   27.20kB/sec    3.40 iops
19.29%,   5829 read,    595 written, 4663.08kB/sec  582.89 iops
20.81%,  15209 read,   1477 written, 12167.16kB/sec 1520.90 iops
20.81%,      3 read,      0 written,    2.40kB/sec    0.30 iops
20.82%,     61 read,      8 written,   48.80kB/sec    6.10 iops
21.98%,  11665 read,   1144 written, 9331.42kB/sec 1166.43 iops
21.98%,      2 read,      0 written,    1.60kB/sec    0.20 iops
22.78%,   7988 read,    817 written, 6389.86kB/sec  798.73 iops
23.12%,   3364 read,    346 written, 2690.97kB/sec  336.37 iops
23.49%,   3746 read,    357 written, 2996.69kB/sec  374.59 iops
24.67%,  11720 read,   1137 written, 9375.97kB/sec 1172.00 iops
24.67%,      4 read,      0 written,    3.20kB/sec    0.40 iops
25.50%,   8365 read,    808 written, 6691.96kB/sec  836.49 iops
25.69%,   1865 read,    190 written, 1491.33kB/sec  186.42 iops
26.14%,   4462 read,    424 written, 3569.58kB/sec  446.20 iops
27.07%,   9377 read,    928 written, 7494.42kB/sec  936.80 iops
27.58%,   5103 read,    532 written, 4082.37kB/sec  510.30 iops
28.54%,   9537 read,    918 written, 7619.92kB/sec  952.49 iops
28.70%,   1600 read,    151 written, 1279.99kB/sec  160.00 iops
29.99%,  12901 read,   1247 written, 10307.61kB/sec 1288.45 iops
30.12%,   1339 read,    139 written, 1071.19kB/sec  133.90 iops
30.16%,    421 read,     41 written,  336.75kB/sec   42.09 iops
30.60%,   4368 read,    486 written, 3494.38kB/sec  436.80 iops
32.16%,  15580 read,   1585 written, 12463.80kB/sec 1557.97 iops
32.16%,      2 read,      0 written,    1.60kB/sec    0.20 iops
32.19%,    330 read,     21 written,  263.97kB/sec   33.00 iops
32.92%,   7302 read,    748 written, 5841.50kB/sec  730.19 iops
33.95%,  10339 read,   1030 written, 8269.88kB/sec 1033.74 iops
33.96%,      4 read,      0 written,    3.20kB/sec    0.40 iops
34.32%,   3673 read,    374 written, 2938.35kB/sec  367.29 iops
35.66%,  13395 read,   1335 written, 10715.92kB/sec 1339.49 iops
35.66%,      9 read,      3 written,    7.20kB/sec    0.90 iops
36.05%,   3890 read,    389 written, 3111.96kB/sec  388.99 iops
37.19%,  11383 read,   1104 written, 9097.74kB/sec 1137.22 iops
37.19%,      2 read,      0 written,    1.60kB/sec    0.20 iops
38.62%,  14295 read,   1511 written, 11421.06kB/sec 1427.63 iops
38.62%,      6 read,      0 written,    4.80kB/sec    0.60 iops
38.62%,      2 read,      0 written,    1.60kB/sec    0.20 iops
39.20%,   5831 read,    579 written, 4664.78kB/sec  583.10 iops
40.25%,  10453 read,   1006 written, 8355.83kB/sec 1044.48 iops
40.25%,      2 read,      0 written,    1.60kB/sec    0.20 iops
41.72%,  14710 read,   1501 written, 11767.59kB/sec 1470.95 iops
41.72%,      4 read,      0 written,    3.20kB/sec    0.40 iops
41.72%,      2 read,      0 written,    1.60kB/sec    0.20 iops
42.87%,  11472 read,   1144 written, 9177.50kB/sec 1147.19 iops
42.87%,      5 read,      0 written,    4.00kB/sec    0.50 iops
44.08%,  12076 read,   1233 written, 9660.75kB/sec 1207.59 iops
44.08%,      4 read,      1 written,    3.20kB/sec    0.40 iops
44.45%,   3684 read,    364 written, 2947.17kB/sec  368.40 iops
45.71%,  12684 read,   1339 written, 10147.10kB/sec 1268.39 iops
45.71%,      4 read,      0 written,    3.20kB/sec    0.40 iops
46.00%,   2823 read,    284 written, 2256.73kB/sec  282.09 iops
46.41%,   4116 read,    423 written, 3292.78kB/sec  411.60 iops
47.54%,  11360 read,   1121 written, 9087.86kB/sec 1135.98 iops
47.59%,    451 read,     52 written,  360.75kB/sec   45.09 iops
48.25%,   6646 read,    680 written, 5316.07kB/sec  664.51 iops
49.53%,  12717 read,   1281 written, 10173.34kB/sec 1271.67 iops
49.53%,      4 read,      0 written,    3.20kB/sec    0.40 iops
49.84%,   3107 read,    311 written, 2484.65kB/sec  310.58 iops
50.81%,   9737 read,    961 written, 7789.56kB/sec  973.69 iops
50.81%,      4 read,      1 written,    3.20kB/sec    0.40 iops
51.69%,   8811 read,    934 written, 7047.89kB/sec  880.99 iops
51.82%,   1281 read,    129 written, 1024.53kB/sec  128.07 iops
52.89%,  10674 read,   1034 written, 8539.07kB/sec 1067.38 iops
52.89%,     14 read,      3 written,   11.20kB/sec    1.40 iops
53.41%,   5235 read,    532 written, 4187.99kB/sec  523.50 iops
54.08%,   6711 read,    679 written, 5368.75kB/sec  671.09 iops
54.94%,   8535 read,    878 written, 6827.91kB/sec  853.49 iops
54.94%,      4 read,      0 written,    3.20kB/sec    0.40 iops
55.65%,   7086 read,    682 written, 5668.57kB/sec  708.57 iops
57.23%,  15799 read,   1561 written, 12639.04kB/sec 1579.88 iops
57.23%,      2 read,      0 written,    1.60kB/sec    0.20 iops
57.23%,      4 read,      0 written,    3.20kB/sec    0.40 iops
57.83%,   6043 read,    615 written, 4833.90kB/sec  604.24 iops
59.43%,  16034 read,   1657 written, 12827.16kB/sec 1603.39 iops
59.43%,      5 read,      0 written,    4.00kB/sec    0.50 iops
59.44%,      8 read,      1 written,    6.40kB/sec    0.80 iops
60.81%,  13705 read,   1397 written, 10963.65kB/sec 1370.46 iops
60.81%,      4 read,      0 written,    3.20kB/sec    0.40 iops
60.84%,    377 read,     30 written,  301.55kB/sec   37.69 iops
61.58%,   7402 read,    760 written, 5921.57kB/sec  740.20 iops
62.26%,   6764 read,    679 written, 5411.12kB/sec  676.39 iops
63.18%,   9188 read,    870 written, 7346.94kB/sec  918.37 iops
63.77%,   5951 read,    554 written, 4760.63kB/sec  595.08 iops
63.77%,      5 read,      0 written,    4.00kB/sec    0.50 iops
64.71%,   9386 read,    973 written, 7508.68kB/sec  938.59 iops
64.71%,      4 read,      0 written,    3.20kB/sec    0.40 iops
65.87%,  11559 read,   1142 written, 9246.80kB/sec 1155.85 iops
65.91%,    406 read,     41 written,  324.79kB/sec   40.60 iops
67.53%,  16184 read,   1634 written, 12929.73kB/sec 1616.22 iops
67.53%,      3 read,      0 written,    2.40kB/sec    0.30 iops
67.53%,      3 read,      0 written,    2.40kB/sec    0.30 iops
68.66%,  11289 read,   1124 written, 9031.13kB/sec 1128.89 iops
68.66%,      3 read,      0 written,    2.40kB/sec    0.30 iops
70.12%,  14665 read,   1482 written, 11731.93kB/sec 1466.49 iops
70.13%,      6 read,      1 written,    4.80kB/sec    0.60 iops
70.17%,    489 read,     53 written,  391.20kB/sec   48.90 iops
70.61%,   4311 read,    438 written, 3448.77kB/sec  431.10 iops
72.32%,  17185 read,   1741 written, 13747.94kB/sec 1718.49 iops
72.32%,      4 read,      0 written,    3.20kB/sec    0.40 iops
72.32%,      1 read,      0 written,    0.80kB/sec    0.10 iops
72.97%,   6433 read,    653 written, 5141.42kB/sec  642.68 iops
73.55%,   5830 read,    584 written, 4663.93kB/sec  582.99 iops
74.72%,  11705 read,   1188 written, 9355.64kB/sec 1169.45 iops
74.72%,      1 read,      0 written,    0.80kB/sec    0.10 iops
75.18%,   4561 read,    388 written, 3643.86kB/sec  455.48 iops
75.50%,   3230 read,    292 written, 2583.90kB/sec  322.99 iops
76.88%,  13816 read,   1427 written, 11052.76kB/sec 1381.60 iops
76.88%,      3 read,      1 written,    2.40kB/sec    0.30 iops
77.86%,   9736 read,   1007 written, 7788.77kB/sec  973.60 iops
78.00%,   1424 read,    138 written, 1139.19kB/sec  142.40 iops
78.67%,   6737 read,    675 written, 5389.53kB/sec  673.69 iops
79.50%,   8296 read,    816 written, 6636.43kB/sec  829.55 iops
79.50%,      3 read,      0 written,    2.40kB/sec    0.30 iops
80.44%,   9361 read,    924 written, 7488.75kB/sec  936.09 iops
80.44%,      3 read,      0 written,    2.40kB/sec    0.30 iops
81.66%,  12259 read,   1217 written, 9807.12kB/sec 1225.89 iops
81.66%,      3 read,      1 written,    2.40kB/sec    0.30 iops
82.72%,  10554 read,   1106 written, 8441.93kB/sec 1055.24 iops
82.95%,   2329 read,    224 written, 1863.19kB/sec  232.90 iops
82.99%,    408 read,     39 written,  326.40kB/sec   40.80 iops
84.07%,  10723 read,   1090 written, 8578.37kB/sec 1072.30 iops
84.07%,      4 read,      0 written,    3.20kB/sec    0.40 iops
85.10%,  10379 read,   1028 written, 8303.15kB/sec 1037.89 iops
85.12%,    167 read,     14 written,  133.59kB/sec   16.70 iops
86.31%,  11925 read,   1117 written, 9539.95kB/sec 1192.49 iops
86.31%,      4 read,      1 written,    3.20kB/sec    0.40 iops
86.66%,   3452 read,    352 written, 2761.42kB/sec  345.18 iops
87.77%,  11113 read,   1088 written, 8890.26kB/sec 1111.28 iops
87.77%,      3 read,      1 written,    2.40kB/sec    0.30 iops
88.91%,  11434 read,   1081 written, 9147.12kB/sec 1143.39 iops
88.91%,      5 read,      0 written,    4.00kB/sec    0.50 iops
89.75%,   8341 read,    802 written, 6672.71kB/sec  834.09 iops
90.23%,   4835 read,    491 written, 3867.94kB/sec  483.49 iops
91.12%,   8910 read,    941 written, 7127.93kB/sec  890.99 iops
91.12%,      3 read,      0 written,    2.40kB/sec    0.30 iops
91.71%,   5909 read,    567 written, 4726.76kB/sec  590.85 iops
92.15%,   4316 read,    415 written, 3452.78kB/sec  431.60 iops
93.44%,  12960 read,   1299 written, 10367.83kB/sec 1295.98 iops
93.44%,      4 read,      0 written,    3.20kB/sec    0.40 iops
93.73%,   2857 read,    292 written, 2285.59kB/sec  285.70 iops
95.35%,  16170 read,   1658 written, 12935.95kB/sec 1616.99 iops
95.35%,      3 read,      0 written,    2.40kB/sec    0.30 iops
95.35%,      5 read,      0 written,    4.00kB/sec    0.50 iops
96.65%,  13060 read,   1274 written, 10447.89kB/sec 1305.99 iops
96.65%,      5 read,      0 written,    4.00kB/sec    0.50 iops
97.46%,   8065 read,    853 written, 6451.07kB/sec  806.38 iops
97.57%,   1158 read,    120 written,  926.40kB/sec  115.80 iops
98.70%,  11221 read,   1113 written, 8975.70kB/sec 1121.96 iops
98.70%,     42 read,      4 written,   33.60kB/sec    4.20 iops
99.85%,  11480 read,   1170 written, 9180.01kB/sec 1147.50 iops
99.85%,      2 read,      0 written,    1.60kB/sec    0.20 iops


-- 
Laurent "ker2x" Laborde
Sysadmin & DBA at http://www.over-blog.com/

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux