Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id D062F62E0FE for ; Tue, 6 Jan 2009 16:50:14 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 47900-06 for ; Tue, 6 Jan 2009 16:50:12 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from qb-out-0506.google.com (qb-out-0506.google.com [72.14.204.237]) by mail.postgresql.org (Postfix) with ESMTP id 9E3FF62DBEA for ; Tue, 6 Jan 2009 16:50:11 -0400 (AST) Received: by qb-out-0506.google.com with SMTP id d8so3056401qbc.23 for ; Tue, 06 Jan 2009 12:50:10 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=79jjreVlbDvBlQjjun6V01Dozd8kEnCTiSlTafHeBTM=; b=cXHKgaWrnkH7VxQVwhGypwcbcCIP3rxz9M02PK/JBJRvNDaBVghpVst/WDcWg1Jq/F nWGJw3DR7g2xYFgx0It7oE4Ud9R4O4hHxl2EoYetvXpwIPcw1W5cW8C1c6ZftKuDsW1o pVNaS+YaOFzORzdkLXbx64+mrXIUKw9PyFfqs= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=bgWIvUGXBj7VY2qjDqtrVs5MJABK/OVRomNO3h6lcj5OlZMsUP+Ro1A8gkiX+bjpxV qhVmHnq67o7M1AXbyWmGWTHu279SO+Zoq2kpzsWcQoVOhHkOfo+t1L+Bq6I3xAjym9AZ 6Dlp8tgckw+R/eJNfj31yIJTRGpGenDn48CqI= Received: by 10.114.89.1 with SMTP id m1mr14761364wab.188.1231275009821; Tue, 06 Jan 2009 12:50:09 -0800 (PST) Received: by 10.115.108.3 with HTTP; Tue, 6 Jan 2009 12:50:09 -0800 (PST) Message-ID: Date: Tue, 6 Jan 2009 13:50:09 -0700 From: "Scott Marlowe" To: "Stefano Nichele" Subject: Re: understanding postgres issues/bottlenecks Cc: "Merlin Moncure" , pgsql-performance@postgresql.org In-Reply-To: <4963AACF.2070201@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <49638BE9.2030701@gmail.com> <4963AACF.2070201@gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200901/17 X-Sequence-Number: 32296 On Tue, Jan 6, 2009 at 12:02 PM, Stefano Nichele 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.