Re: CPU load - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: CPU load
Date
Msg-id dcc563d10809251300i7e8dd8aej12d08a4082671bbf@mail.gmail.com
Whole thread Raw
In response to CPU load  (kiki@fesb.hr)
Responses Re: CPU load
List pgsql-performance
2008/9/25  <kiki@fesb.hr>:

> The result of the top command:
>
> top - 20:44:58 up  5:36,  1 user,  load average: 1.31, 1.39, 1.24
> Tasks: 277 total,   2 running, 275 sleeping,   0 stopped,   0 zombie
> Cpu(s): 11.5%us,  2.2%sy,  0.0%ni, 86.3%id,  0.0%wa,  0.0%hi,  0.0%si,
> 0.0%st
> Mem:   3370808k total,  1070324k used,  2300484k free,    49484k buffers
> Swap:  1951888k total,        0k used,  1951888k free,   485396k cached

SNIP

> The result of vmstat command:
>
> kamis03:/etc# vmstat 1
> procs -----------memory---------- ---swap-- -----io---- -system-- ----cpu----
>  r  b   swpd   free   buff  cache   si   so    bi    bo   in   cs us sy id wa
>  2  0      0 2271356  49868 505252    0    0     2    32   40   83  6  1
> 93  0
>  2  0      0 2271232  49868 505304    0    0     0  2348  459 1118 14  2
> 84  0
>  3  0      0 2271232  49868 505304    0    0     0    16  305 1197 11  2
> 87  0
>  3  0      0 2270984  49868 505432    0    0     0     8  407 1821 15  3

If that's what it looks like your server is running just fine.  Load
of 1.31, 85+% idle, no wait time.  Or is that top and vmstat output
from when the server is running fine?

pgsql-performance by date:

Previous
From: kiki@fesb.hr
Date:
Subject: CPU load
Next
From: Greg Smith
Date:
Subject: Re: Slow updates, poor IO