Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 8F6F31337BD9 for ; Mon, 4 Apr 2011 09:28:23 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 28436-06 for ; Mon, 4 Apr 2011 12:28:15 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from elizabeth.gransy.com (elizabeth.gransy.com [89.187.132.199]) by mail.postgresql.org (Postfix) with ESMTP id A5D2D1337B67 for ; Mon, 4 Apr 2011 09:28:15 -0300 (ADT) Received: from sq.gransy.com (localhost [127.0.0.1]) by elizabeth.gransy.com (Postfix) with ESMTP id 8BEBB15E432B; Mon, 4 Apr 2011 14:28:14 +0200 (CEST) Received: from 85.161.195.250 (SquirrelMail authenticated user tv@fuzzy.cz) by sq.gransy.com with HTTP; Mon, 4 Apr 2011 14:28:14 +0200 Message-ID: <8eba9f6568e3f5fe52495e0bf7a2f7b6.squirrel@sq.gransy.com> In-Reply-To: <4D99B0B1.4020702@orkash.com> References: <4D999211.9080507@orkash.com> <4D99ACC0.5090009@orkash.com> <4D99B0B1.4020702@orkash.com> Date: Mon, 4 Apr 2011 14:28:14 +0200 Subject: Re: Postgres Performance Tuning From: tv@fuzzy.cz To: "Adarsh Sharma" Cc: "Scott Marlowe" , pgsql-performance@postgresql.org User-Agent: SquirrelMail/1.4.21 MIME-Version: 1.0 Content-Type: text/plain;charset=utf-8 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201104/19 X-Sequence-Number: 43081 > > > Thanks Scott : > > My iostat package is not installed but have a look on below output: > > [root@s8-mysd-2 8.4SS]# vmstat 10 > procs -----------memory---------- ---swap-- -----io---- --system-- > -----cpu------ > r b swpd free buff cache si so bi bo in cs us sy > id wa st > 1 0 147664 93920 72332 15580748 0 1 113 170 47 177 6 > 1 92 1 0 > 0 0 147664 94020 72348 15580748 0 0 0 4 993 565 0 > 0 100 0 0 > 0 0 147664 93896 72364 15580748 0 0 0 5 993 571 0 > 0 100 0 0 > 0 0 147664 93524 72416 15580860 0 0 0 160 1015 591 0 > 0 100 0 0 > 0 0 147664 93524 72448 15580860 0 0 0 8 1019 553 0 > 0 100 0 0 > 0 0 147664 93648 72448 15580860 0 0 0 0 1019 555 0 > 0 100 0 0 > 0 0 147664 93648 72448 15580860 0 0 0 3 1023 560 0 > 0 100 0 0 Is this from a busy or idle period? I guess it's from an idle one, because the CPU is 100% idle and there's very little I/O activity. That's useless - we need to see vmstat output from period when there's something wrong. > [root@s8-mysd-2 8.4SS]# iostat > -bash: iostat: command not found > [root@s8-mysd-2 8.4SS]# Then install it. Not sure what distro you use, but it's usually packed in sysstat package. Tomas