Re: PG 8.3 and server load
| От | Phoenix Kiula |
|---|---|
| Тема | Re: PG 8.3 and server load |
| Дата | |
| Msg-id | e373d31e0908190829y381846c1md778090b31bf0890@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: PG 8.3 and server load (Andy Colson <andy@squeakycode.net>) |
| Ответы |
Re: PG 8.3 and server load
|
| Список | pgsql-performance |
On Wed, Aug 19, 2009 at 11:25 PM, Andy Colson<andy@squeakycode.net> wrote: ....<snip>..... > > the first line of vmstat is an average since bootup. Kinda useless. run it > as: 'vmstat 4' > > it will print a line every 4 seconds, which will be a summary of everything > that happened in the last 4 seconds. > > since boot, you've written out an average of 153 blocks (the bo column). > Thats very small, so your not io bound. > > but... you have average 74% idle cpu. So your not cpu bound either? > > Ahh? I'm not sure what that means. Maybe I'm reading something wrong? > > -Andy > ~ > vmstat 4 procs -----------memory---------- ---swap-- -----io---- --system-- ----cpu---- r b swpd free buff cache si so bi bo in cs us sy id wa 0 2 16128 35056 62800 7697428 0 0 74 153 0 3 10 5 74 12 0 0 16128 38256 62836 7698172 0 0 166 219 1386 1440 7 4 85 4 0 1 16128 34704 62872 7698916 0 0 119 314 1441 1589 7 4 85 5 0 0 16128 29544 62912 7699396 0 0 142 144 1443 1418 6 3 88 2 7 1 16128 26784 62832 7692196 0 0 343 241 1492 1671 8 5 83 4 0 0 16128 32840 62880 7693188 0 0 253 215 1459 1511 7 4 85 4 0 0 16128 30112 62940 7693908 0 0 187 216 1395 1282 6 3 87 4
В списке pgsql-performance по дате отправления: