Re: understanding postgres issues/bottlenecks

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

 



On Tue, Jan 6, 2009 at 12:02 PM, Stefano Nichele
<stefano.nichele@xxxxxxxxx> wrote:
> Thanks for your help. I'll give you the info you asked as soon as I'll have
> it (i have also to install iostat but I don't have enough privilege to do
> that).
>
> BTW, why did you said I/O bound ? Which are the parameters that highlight
> that ? Sorry for my ignorance....

In this output, the second to the last column is wa, which stands for
wait, the third to last is id, which is CPU idle.

r  b   swpd   free   buff  cache   si   so    bi    bo   in   cs us sy id wa st
1 24     84 124204  25136 3257100    0    0  3037  1154 3359 7253 25  7  6 62  0
2 30     84 124704  25136 3256344    0    0  3004  1269 3553 7906 33  9  7 51  0
0 25     84 125784  24956 3253344    0    0  3357   773 3163 6454 17  4 10 68  0

So here the first line reports
25% user
7% system
6% idle
62% wait

So it's mostly waiting.

-- 
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