Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Kevin GrittnerDate: 2009-08-19 15:33:33
Subject: Re: PG 8.3 and server load
Previous:From: Andy ColsonDate: 2009-08-19 15:25:27
Subject: Re: PG 8.3 and server load

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group