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

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/