Re: PG 8.3 and server load

From: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
To: Andy Colson <andy(at)squeakycode(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: PG 8.3 and server load
Date: 2009-08-19 15:29:45
Message-ID: e373d31e0908190829y381846c1md778090b31bf0890@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Aug 19, 2009 at 11:25 PM, Andy Colson<andy(at)squeakycode(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Grittner 2009-08-19 15:33:33 Re: PG 8.3 and server load
Previous Message Andy Colson 2009-08-19 15:25:27 Re: PG 8.3 and server load