Re: [PERFORM] Hardware/OS recommendations for large databases (</TIT= LE> </HEAD> <BODY> Alan,= On 11/18/05 8:13 AM, "Alan Stange" <stange@rentec.com> wrot= e: <BLOCKQUOTE>I told you in my initial post that I was observing numb= ers in excess of what you claiming, but you seemed to think I didn't know how to measure an IO rate. </BLOCKQUOTE>Prove me wrong, post your data. <BLOCKQUOTE>I should note too that our system uses about 20% of a s= ingle cpu when performing a table scan at >100MB/s of IO. I think you claimed the system would be cpu bound at this low IO rate. </BLOCKQUOTE> See above. - Luke <BLOCKQUOTE> </BLOCKQUOTE> </BODY> </HTML> --B_3215146668

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 94778DBAAD for ; Fri, 18 Nov 2005 12:18:21 -0400 (AST) 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 54874-03 for ; Fri, 18 Nov 2005 16:18:19 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.Mi8.com (d01gw01.mi8.com [63.240.6.47]) by svr1.postgresql.org (Postfix) with ESMTP id A5C1EDBAB3 for ; Fri, 18 Nov 2005 12:18:18 -0400 (AST) Received: from 172.16.1.110 by mail.Mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D1)); Fri, 18 Nov 2005 11:17:54 -0500 X-Server-Uuid: 241911D6-425B-44B9-A073-E3FE0F8FC774 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.175]) by D01SMTP01.Mi8.com with Microsoft SMTPSVC(6.0.3790.211); Fri, 18 Nov 2005 11:17:49 -0500 Received: from 69.181.100.71 ([69.181.100.71]) by MI8NYCMAIL06.Mi8.com ( [172.16.1.219]) via Exchange Front-End Server mi8owa.mi8.com ( [172.16.1.104]) with Microsoft Exchange Server HTTP-DAV ; Fri, 18 Nov 2005 11:17:48 -0500 User-Agent: Microsoft-Entourage/11.2.1.051004 Date: Fri, 18 Nov 2005 08:17:48 -0800 Subject: Re: Hardware/OS recommendations for large databases ( From: "Luke Lonergan" To: stange@rentec.com cc: "Dave Cramer" , "Greg Stark" , "Joshua Marsh" , pgsql-performance@postgresql.org Message-ID: Thread-Topic: [PERFORM] Hardware/OS recommendations for large databases ( Thread-Index: AcXsWynYmaQcVW8AQ/6P36vjrmRtnwAAHO+A In-Reply-To: <437DFDB8.1030208@rentec.com> MIME-Version: 1.0 X-OriginalArrivalTime: 18 Nov 2005 16:17:49.0336 (UTC) FILETIME=[9E627980:01C5EC5B] X-WSS-ID: 6F6321F621G13526393-04-01 Content-Type: multipart/alternative; boundary=B_3215146668_2362154 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.254 required=5 tests=[AWL=-0.000, HTML_MESSAGE=0.001, RCVD_NUMERIC_HELO=1.253] X-Spam-Score: 1.254 X-Spam-Level: * X-Archive-Number: 200511/373 X-Sequence-Number: 15630 > This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --B_3215146668_2362154 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Alan, On 11/18/05 8:13 AM, "Alan Stange" wrote: > I told you in my initial post that I was observing numbers in excess of > what you claiming, but you seemed to think I didn't know how to measure > an IO rate. > Prove me wrong, post your data. > I should note too that our system uses about 20% of a single cpu when > performing a table scan at >100MB/s of IO. I think you claimed the > system would be cpu bound at this low IO rate. See above. - Luke > --B_3215146668_2362154 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: quoted-printable Re: [PERFORM] Hardware/OS recommendations for large databases (</TIT= LE> </HEAD> <BODY> Alan,= On 11/18/05 8:13 AM, "Alan Stange" <stange@rentec.com> wrot= e: <BLOCKQUOTE>I told you in my initial post that I was observing numb= ers in excess of what you claiming, but you seemed to think I didn't know how to measure an IO rate. </BLOCKQUOTE>Prove me wrong, post your data. <BLOCKQUOTE>I should note too that our system uses about 20% of a s= ingle cpu when performing a table scan at >100MB/s of IO. I think you claimed the system would be cpu bound at this low IO rate. </BLOCKQUOTE> See above. - Luke <BLOCKQUOTE> </BLOCKQUOTE> </BODY> </HTML> --B_3215146668_2362154--