X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 69C07D1B181 for ; Sat, 10 Jul 2004 09:25:30 -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 91192-02 for ; Sat, 10 Jul 2004 12:25:38 +0000 (GMT) Received: from smtp-out4.blueyonder.co.uk (smtp-out4.blueyonder.co.uk [195.188.213.7]) by svr1.postgresql.org (Postfix) with ESMTP id 8CBC8D1B19C for ; Sat, 10 Jul 2004 09:25:27 -0300 (ADT) Received: from lappy ([82.43.186.55]) by smtp-out4.blueyonder.co.uk with Microsoft SMTPSVC(5.0.2195.5600); Sat, 10 Jul 2004 13:25:52 +0100 Message-ID: <021101c46679$01ef4330$0300a8c0@lappy> From: "Andy Ballingall" To: "J. Andrew Rogers" Cc: References: <20040708101913.GA15871@uio.no> <00ac01c46516$3ec859e0$0300a8c0@lappy> <40EDF7DE.8080900@familyhealth.com.au> <011301c46597$15d145c0$0300a8c0@lappy> <1089409248.4524.13.camel@vulture.corp.neopolitan.com> Subject: Re: Working on huge RAM based datasets Date: Sat, 10 Jul 2004 13:25:37 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 X-OriginalArrivalTime: 10 Jul 2004 12:25:52.0858 (UTC) FILETIME=[0AA073A0:01C46679] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200407/75 X-Sequence-Number: 7466 Oops - sorry - I confused my numbers. The opteron machine in mind *only* has up to 64GB of RAM (e.g. HP DL585) - here's the datapage: http://h18004.www1.hp.com/products/servers/proliantdl585/index.html Still - with *just* 64GB of RAM, that would comfortably provide for the type of scenario I envisage. Is that still enough for your app? The 256GB number came from something I read saying that the current crop of 64 bit chips will allow up to 256GB of RAM in principle, so it is just a matter of time before the memory limit shoots up on these simple products. If you are prepared to pay a bit more, already there are some big memory options on linux: E.g. you can have up to 192GB in an SGI Altix 350: http://www.sgi.com/servers/altix/downloads/altix350_at_a_glance.pdf Or up to 4 terabytes in it's bigger brother the Altix 3000 - but that's getting a bit esoteric. http://www.sgi.com/servers/altix/ (This won lots of awards recently) The nice thing about the two things above is that they run linux in a single address space NUMA setup, and in theory you can just bolt on more CPUs and more RAM as your needs grow. Thanks, Andy ----- Original Message ----- From: "J. Andrew Rogers" To: "Andy Ballingall" Sent: Friday, July 09, 2004 10:40 PM Subject: Re: [PERFORM] Working on huge RAM based datasets > On Fri, 2004-07-09 at 02:28, Andy Ballingall wrote: > > After all, we're now seeing the first wave of 'reasonably priced' 64 bit > > servers supported by a proper 64 bit OS (e.g. linux). HP are selling a 4 > > Opteron server which can take 256GB of RAM, and that starts at $10000 (ok - > > they don't give you that much RAM for that price - not yet, anyway!) > > > Which server is this?! They are selling an Opteron system that can hold > 256 GB of RAM? > > I looked on their site, and couldn't find anything like that. I run > some MASSIVE memory codes that don't need a lot of CPU, and if such a > box existed, I'd be very interested. > > cheers, > > j. andrew rogers > > > ----- Original Message ----- From: "J. Andrew Rogers" To: "Andy Ballingall" Sent: Friday, July 09, 2004 10:40 PM Subject: Re: [PERFORM] Working on huge RAM based datasets > On Fri, 2004-07-09 at 02:28, Andy Ballingall wrote: > > After all, we're now seeing the first wave of 'reasonably priced' 64 bit > > servers supported by a proper 64 bit OS (e.g. linux). HP are selling a 4 > > Opteron server which can take 256GB of RAM, and that starts at $10000 (ok - > > they don't give you that much RAM for that price - not yet, anyway!) > > > Which server is this?! They are selling an Opteron system that can hold > 256 GB of RAM? > > I looked on their site, and couldn't find anything like that. I run > some MASSIVE memory codes that don't need a lot of CPU, and if such a > box existed, I'd be very interested. > > cheers, > > j. andrew rogers > > >