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

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
!%*@#

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