X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 37195D85A5 for ; Tue, 30 Aug 2005 13:19:32 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 99240-04 for ; Tue, 30 Aug 2005 16:19:29 +0000 (GMT) Received: from iad2.emailsrvr.com (iad2.emailsrvr.com [207.97.227.212]) by svr1.postgresql.org (Postfix) with ESMTP id 692E6D85A2 for ; Tue, 30 Aug 2005 13:19:28 -0300 (ADT) Received: from [10.10.20.22] (unknown [216.94.157.147]) (using TLSv1 with cipher RC4-SHA (128/128 bits)) (No client certificate requested) (Authenticated sender: remyb@medrium.com) by relay2.r2.iad.emailsrvr.com (SMTP Server) with ESMTP id 6348344C36C; Tue, 30 Aug 2005 12:19:28 -0400 (EDT) In-Reply-To: <22417.1125418551@sss.pgh.pa.us> References: <22417.1125418551@sss.pgh.pa.us> Mime-Version: 1.0 (Apple Message framework v622) Content-Type: text/plain; charset=ISO-8859-1; format=flowed Message-Id: <2fa5224f3e5af53598e33d115a2af980@medrium.com> Content-Transfer-Encoding: quoted-printable Cc: pgsql-performance@postgresql.org From: =?ISO-8859-1?Q?R=E9my_Beaumont?= Subject: Re: High load and iowait but no disk access Date: Tue, 30 Aug 2005 12:19:30 -0400 To: Tom Lane X-Mailer: Apple Mail (2.622) X-Virus-Scanned: OK X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200508/524 X-Sequence-Number: 14271 On 30-Aug-05, at 12:15, Tom Lane wrote: > =3D?ISO-8859-1?Q?R=3DE9my_Beaumont?=3D writes: >> The stats of the NetApp do confirm that it is sitting idle. > > Really? > >> CPU NFS CIFS HTTP Total Net kB/s Disk kB/s Tape kB/s >> Cache Cache CP CP Disk DAFS FCP iSCSI FCP kB/s >> in out read write read write >> age hit time ty util in out >> 2% 0 0 0 139 0 0 2788 0 0 0 >> 3 96% 0% - 15% 0 139 0 3 2277 >> 2% 0 0 0 144 0 0 2504 0 0 0 >> 3 96% 0% - 18% 0 144 0 3 2150 >> 2% 0 0 0 130 0 0 2212 0 0 0 >> 3 96% 0% - 13% 0 130 0 3 1879 >> 3% 0 0 0 169 0 0 2937 80 0 0 >> 3 96% 0% - 13% 0 169 0 4 2718 >> 2% 0 0 0 139 0 0 2448 0 0 0 >> 3 96% 0% - 12% 0 139 0 3 2096 > > I know zip about NetApps, but doesn't the 8th column indicate pretty > steady disk reads? Yes, but they are very low. At 15% usage, it's pretty much sitting idle if you consider that the OS=20= reports that one of the processor is spending more then 80% of it's=20 time in IOwait. R=E9my > > regards, tom lane