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  (Matthew Wakeling <matthew@flymine.org>)
Список 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 по дате отправления:

Предыдущее
От: Andy Colson
Дата:
Сообщение: Re: PG 8.3 and server load
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: PG 8.3 and server load