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 B3014DBAB3 for ; Fri, 18 Nov 2005 12:20:35 -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 54529-06 for ; Fri, 18 Nov 2005 16:20:33 +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 8A08AD82C0 for ; Fri, 18 Nov 2005 12:20:32 -0400 (AST) Received: from 172.16.1.112 by mail.Mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D1)); Fri, 18 Nov 2005 11:20:12 -0500 X-Server-Uuid: 241911D6-425B-44B9-A073-E3FE0F8FC774 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.175]) by D01SMTP02.Mi8.com with Microsoft SMTPSVC(6.0.3790.211); Fri, 18 Nov 2005 11:20:11 -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:20:11 -0500 User-Agent: Microsoft-Entourage/11.2.1.051004 Date: Fri, 18 Nov 2005 08:20:11 -0800 Subject: Re: Hardware/OS recommendations for large databases ( From: "Luke Lonergan" To: "Vivek Khera" , "Postgresql Performance" Message-ID: Thread-Topic: [PERFORM] Hardware/OS recommendations for large databases ( Thread-Index: AcXsWzbRV+j6Vby9QAyiN/Gwt8OJ2wAALwAZ In-Reply-To: <7F33229E-AE95-436B-AB2F-01AC023DD7EE@khera.org> MIME-Version: 1.0 X-OriginalArrivalTime: 18 Nov 2005 16:20:11.0938 (UTC) FILETIME=[F361D020:01C5EC5B] X-WSS-ID: 6F6320B121G13528235-01-01 Content-Type: multipart/alternative; boundary=B_3215146811_2392297 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/372 X-Sequence-Number: 15629 > 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_3215146811_2392297 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Vivek,=20 On 11/18/05 8:05 AM, "Vivek Khera" wrote: > I can tell you from direct personal experience that you're just plain > wrong. >=20 > up with my load on a 60+ GB database. The Dual opteron system has I=B9m always surprised by what passes for a large database. The poster is talking about 5,000GB, or almost 100 times the data you have. Post your I/O numbers on sequential scan. Sequential scan is critical for Decision Support / Data Warehousing. - Luke --B_3215146811_2392297 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Re: [PERFORM] Hardware/OS recommendations for large databases (</TIT= LE> </HEAD> <BODY> <FONT FACE=3D"Verdana, Helvetica, Arial"><SPAN STYLE=3D'font-size:14.0px'>Vivek= , <BR> <BR> On 11/18/05 8:05 AM, "Vivek Khera" <vivek@khera.org> wrote:= <BR> <BR> </SPAN></FONT><BLOCKQUOTE><FONT FACE=3D"Verdana, Helvetica, Arial"><SPAN STYL= E=3D'font-size:14.0px'>I can tell you from direct personal experience that you= 're just plain <BR> wrong.<BR> <BR> up with my load on a 60+ GB database.  The Dual opteron system has <BR= > </SPAN></FONT></BLOCKQUOTE><FONT FACE=3D"Verdana, Helvetica, Arial"><SPAN STY= LE=3D'font-size:14.0px'><BR> I’m always surprised by what passes for a large database.  The p= oster is talking about 5,000GB, or almost 100 times the data you have.<BR> <BR> Post your I/O numbers on sequential scan.  Sequential scan is critical= for Decision Support / Data Warehousing.<BR> <BR> - Luke </SPAN></FONT> </BODY> </HTML> --B_3215146811_2392297--