Re: PG 8.3 and server load

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, Aug 19, 2009 at 11:25 PM, Andy Colson<andy@xxxxxxxxxxxxxxx> 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

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux