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

1 SSD Kingston V+100 250GB, no raid.

/home/pgiosim-0.5/pgiosim -w1 -a1 -v -b 1000000 /home/ssd/big1
Write Mode: 1%
Stallcheck at 1.000000
Verbose
Unknown units of blocks
Arg: 1
Read 1000000 blocks
Added /home/ssd/big1
3.57%, 35720 read, 365 written, 28567.73kB/sec 3570.97 iops
6.14%, 25684 read, 276 written, 20519.77kB/sec 2564.97 iops
8.17%, 20270 read, 219 written, 16215.94kB/sec 2026.99 iops
9.66%, 14937 read, 131 written, 11945.84kB/sec 1493.23 iops
12.91%, 32494 read, 327 written, 25995.08kB/sec 3249.38 iops
14.06%, 11508 read, 118 written, 9206.33kB/sec 1150.79 iops
16.09%, 20292 read, 187 written, 16233.55kB/sec 2029.19 iops
17.57%, 14817 read, 141 written, 11853.49kB/sec 1481.69 iops
19.62%, 20515 read, 201 written, 16411.94kB/sec 2051.49 iops
21.90%, 22794 read, 214 written, 18222.39kB/sec 2277.80 iops
23.92%, 20207 read, 197 written, 16160.23kB/sec 2020.03 iops
26.11%, 21812 read, 213 written, 17427.32kB/sec 2178.42 iops
28.29%, 21852 read, 213 written, 17475.40kB/sec 2184.43 iops
30.73%, 24416 read, 234 written, 19507.42kB/sec 2438.43 iops
32.46%, 17298 read, 183 written, 13833.15kB/sec 1729.14 iops
33.25%, 7863 read, 87 written, 6290.35kB/sec 786.29 iops
35.67%, 24229 read, 213 written, 19383.12kB/sec 2422.89 iops
37.71%, 20397 read, 208 written, 16317.50kB/sec 2039.69 iops
39.61%, 19022 read, 200 written, 15217.51kB/sec 1902.19 iops
41.63%, 20190 read, 202 written, 16151.85kB/sec 2018.98 iops
44.00%, 23651 read, 266 written, 18913.60kB/sec 2364.20 iops
45.30%, 13066 read, 112 written, 10452.69kB/sec 1306.59 iops
47.37%, 20697 read, 218 written, 16557.55kB/sec 2069.69 iops
49.75%, 23726 read, 217 written, 18980.50kB/sec 2372.56 iops
51.55%, 18087 read, 170 written, 14469.56kB/sec 1808.69 iops
53.47%, 19194 read, 193 written, 15355.08kB/sec 1919.39 iops
55.30%, 18250 read, 205 written, 14599.93kB/sec 1824.99 iops
57.00%, 16999 read, 160 written, 13599.09kB/sec 1699.89 iops
58.79%, 17912 read, 180 written, 14329.56kB/sec 1791.19 iops
61.76%, 29694 read, 318 written, 23753.91kB/sec 2969.24 iops
62.96%, 12039 read, 113 written, 9631.16kB/sec 1203.90 iops
65.67%, 27048 read, 273 written, 21609.48kB/sec 2701.18 iops
67.00%, 13305 read, 130 written, 10639.63kB/sec 1329.95 iops
69.22%, 22229 read, 227 written, 17783.07kB/sec 2222.88 iops
71.13%, 19062 read, 170 written, 15249.52kB/sec 1906.19 iops
72.06%, 9299 read, 97 written, 7437.79kB/sec 929.72 iops
74.31%, 22492 read, 202 written, 17986.09kB/sec 2248.26 iops
76.66%, 23493 read, 219 written, 18768.77kB/sec 2346.10 iops
78.75%, 20979 read, 209 written, 16775.76kB/sec 2096.97 iops
80.68%, 19305 read, 194 written, 15428.97kB/sec 1928.62 iops
83.05%, 23670 read, 222 written, 18927.19kB/sec 2365.90 iops
84.59%, 15391 read, 169 written, 12299.46kB/sec 1537.43 iops
86.32%, 17246 read, 166 written, 13796.73kB/sec 1724.59 iops
88.33%, 20133 read, 201 written, 16106.22kB/sec 2013.28 iops
89.98%, 16561 read, 172 written, 13248.30kB/sec 1656.04 iops
92.81%, 28298 read, 252 written, 22627.87kB/sec 2828.48 iops
94.85%, 20388 read, 198 written, 16308.57kB/sec 2038.57 iops
96.75%, 18974 read, 178 written, 15179.09kB/sec 1897.39 iops
98.45%, 16956 read, 190 written, 13564.73kB/sec 1695.59 iops

-------------

/home/pgiosim-0.5/pgiosim -w10 -a1 -v -b 1000000 /home/ssd/big1
Write Mode: 10%
Stallcheck at 1.000000
Verbose
Unknown units of blocks
Arg: 1
Read 1000000 blocks
Added /home/ssd/big1
2.01%, 20122 read, 1978 written, 16097.57kB/sec 2012.20 iops
2.01%, 3 read, 0 written, 2.40kB/sec 0.30 iops
2.01%, 3 read, 0 written, 2.40kB/sec 0.30 iops
2.01%, 3 read, 0 written, 2.40kB/sec 0.30 iops
3.82%, 18036 read, 1779 written, 14428.73kB/sec 1803.59 iops
4.03%, 2175 read, 209 written, 1739.98kB/sec 217.50 iops
4.03%, 3 read, 0 written, 2.40kB/sec 0.30 iops
4.03%, 2 read, 0 written, 1.60kB/sec 0.20 iops
4.04%, 4 read, 0 written, 3.20kB/sec 0.40 iops
4.04%, 4 read, 0 written, 3.20kB/sec 0.40 iops
5.62%, 15804 read, 1614 written, 12643.13kB/sec 1580.39 iops
5.62%, 3 read, 2 written, 2.40kB/sec 0.30 iops
5.62%, 4 read, 0 written, 3.20kB/sec 0.40 iops
5.62%, 3 read, 0 written, 2.40kB/sec 0.30 iops
5.62%, 3 read, 0 written, 2.40kB/sec 0.30 iops
6.86%, 12414 read, 1264 written, 9931.17kB/sec 1241.40 iops
6.86%, 3 read, 0 written, 2.40kB/sec 0.30 iops
6.86%, 2 read, 0 written, 1.60kB/sec 0.20 iops
7.18%, 3213 read, 343 written, 2570.39kB/sec 321.30 iops
8.34%, 11563 read, 1215 written, 9250.36kB/sec 1156.30 iops
8.34%, 3 read, 0 written, 2.40kB/sec 0.30 iops
8.34%, 4 read, 0 written, 3.20kB/sec 0.40 iops
8.34%, 3 read, 1 written, 2.40kB/sec 0.30 iops
8.64%, 3055 read, 276 written, 2443.98kB/sec 305.50 iops
10.57%, 19227 read, 1947 written, 15381.53kB/sec 1922.69 iops
10.57%, 3 read, 0 written, 2.40kB/sec 0.30 iops
10.57%, 4 read, 0 written, 3.20kB/sec 0.40 iops
10.57%, 3 read, 0 written, 2.40kB/sec 0.30 iops
10.57%, 2 read, 1 written, 1.60kB/sec 0.20 iops
10.57%, 7 read, 1 written, 5.60kB/sec 0.70 iops
11.32%, 7488 read, 752 written, 5990.38kB/sec 748.80 iops
11.32%, 3 read, 0 written, 2.40kB/sec 0.30 iops
13.32%, 20043 read, 1968 written, 16034.36kB/sec 2004.29 iops
13.32%, 3 read, 0 written, 2.40kB/sec 0.30 iops
13.32%, 4 read, 0 written, 3.20kB/sec 0.40 iops
13.32%, 3 read, 0 written, 2.40kB/sec 0.30 iops
13.32%, 4 read, 1 written, 3.20kB/sec 0.40 iops
13.32%, 5 read, 0 written, 4.00kB/sec 0.50 iops
15.12%, 17970 read, 1878 written, 14375.96kB/sec 1796.99 iops
15.12%, 4 read, 3 written, 3.20kB/sec 0.40 iops
15.12%, 5 read, 1 written, 4.00kB/sec 0.50 iops
^CCTRL-C Interrupt - stopping
!%*(at)#

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