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

Re: understanding postgres issues/bottlenecks

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Stefano Nichele" <stefano(dot)nichele(at)gmail(dot)com>
Cc: "Merlin Moncure" <mmoncure(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: understanding postgres issues/bottlenecks
Date: 2009-01-06 20:50:09
Message-ID: dcc563d10901061250i766ecdeeu2f1b2e3e8fe32770@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Tue, Jan 6, 2009 at 12:02 PM, Stefano Nichele
<stefano(dot)nichele(at)gmail(dot)com> 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.

In response to

pgsql-performance by date

Next:From: David ReesDate: 2009-01-06 23:33:09
Subject: Re: understanding postgres issues/bottlenecks
Previous:From: Stefano NicheleDate: 2009-01-06 19:02:39
Subject: Re: understanding postgres issues/bottlenecks

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