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 439BCD7BAF for ; Thu, 10 Nov 2005 12:34:06 -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 67703-07 for ; Thu, 10 Nov 2005 16:34:04 +0000 (GMT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.202]) by svr1.postgresql.org (Postfix) with ESMTP id 822DDD7B75 for ; Thu, 10 Nov 2005 12:34:04 -0400 (AST) Received: by wproxy.gmail.com with SMTP id 57so383386wri for ; Thu, 10 Nov 2005 08:34:04 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=sVJL0tFT0QGeEnp3PIycXcDOWh7oy/KLYS/ffmFWRMqpDZ+64tNpGk1aroSNyqzFm9W/ZhYH+Y3ngx4aQm9VRYyK0tUsGAslS1By0fDnTUNRP5MbhIWFX4kTZVuxaIy4/bK/aCqYBVWoHdHtYlOPy2J/V0TZOGehmj9amE+gAbE= Received: by 10.54.142.2 with SMTP id p2mr813453wrd; Thu, 10 Nov 2005 08:34:03 -0800 (PST) Received: by 10.54.83.19 with HTTP; Thu, 10 Nov 2005 08:34:03 -0800 (PST) Message-ID: <33c6269f0511100834q718e5274mf7230fe95ab8323e@mail.gmail.com> Date: Thu, 10 Nov 2005 11:34:03 -0500 From: Alex Turner To: Ron Peacetree Subject: Re: Sort performance on large tables Cc: Kurt De Grave , pgsql-performance@postgresql.org In-Reply-To: <16531385.1131639803429.JavaMail.root@elwamui-hound.atl.sa.earthlink.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <16531385.1131639803429.JavaMail.root@elwamui-hound.atl.sa.earthlink.net> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.092 required=5 tests=[AWL=0.092] X-Spam-Score: 0.092 X-Spam-Level: X-Archive-Number: 200511/184 X-Sequence-Number: 15441 We use this memory in all our servers (well - the 512 sticks). 0 problems to date: http://www.newegg.com/Product/Product.asp?Item=3DN82E16820145513 $163 for 1GB. This stuff is probably better than the Samsung RAM dell is selling you for 3 times the price. Alex On 11/10/05, Ron Peacetree wrote: > My original post did not take into account VAT, I apologize for that over= sight. > > However, unless you are naive, or made of gold, or have some sort of "spe= cial" relationship that requires you to, _NE VER_ buy RAM from your compute= r HW OEM. For at least two decades it's been a provable fact that OEMs lik= e DEC, Sun, HP, Compaq, Dell, etc, etc charge far more per GB for the RAM t= hey sell. Same goes for HDs. Buy your memory and HDs direct from reputabl= e manufacturers, you'll get at least the same quality and pay considerably = less. > > Your Dell example is evidence that supports my point. As of this writing= , decent RAM should cost $75-$150 pr GB (not including VAT ;-) ). Don't l= et yourself be conned into paying more. > > I'm talking about decent RAM from reputable direct suppliers like Corsair= and Kingston (_not_ their Value RAM, the actual Kingston branded stuff), O= CZ, etc. Such companies sell via multiple channels, including repuatble we= bsites like dealtime.com, pricewatch.com, newegg.com, etc, etc. > > You are quite correct that there's poor quality junk out there. I was no= t talking about it, only reasonable quality components. > > Ron > > > -----Original Message----- > From: Kurt De Grave > Sent: Nov 10, 2005 5:40 AM > To: Ron Peacetree > Cc: Charlie Savage , pgsql-performance@postgresql.org > Subject: Re: [PERFORM] Sort performance on large tables > > > > On Wed, 9 Nov 2005, Ron Peacetree wrote: > > > At this writing, 4 1GB DIMMs (4GB) should set you back ~$300 or less. > > 4 2GB DIMMs (8GB) should cost ~$600. As of now, very few mainboards > > support 4GB DIMMs and I doubt the D3000 has such a mainboard. If you > > can use them, 4 4GB DIMMs (16GB) will currently set you back > > ~$1600-$2400. > > Sorry, but every time again I see unrealistic memory prices quoted when > the buy-more-memory argument passes by. > What kind of memory are you buying for your servers? Non-ECC no-name > memory that doesn't even pass a one-hour memtest86 for 20% of the items > you buy? > > Just checked at Dell's web page: adding 4 1GB DIMMs to a PowerEdge 2850 > sets you back _1280 EURO_ excluding VAT. And that's after they already > charged you 140 euro for replacing the obsolete standard 4 512MB DIMMs > with the same capacity in 1GB DIMMs. So the 4GB upgrade actually costs > 1420 euro plus VAT, which is quite a bit more than $300. > > Okay, few people will happily buy at those prices. You can get the > exact same goods much cheaper elsewhere, but it'll still cost you way > more than the number you gave, plus you'll have to drive to the server's > location, open up the box yourself, and risk incompatibilities and > support problems if there's ever something wrong with that memory. > > Disclaimers: > I know that you're talking about a desktop in this particular case. > I wouldn't see a need for ECC in a development box either. > I know a Dell hasn't been the smartest choice for a database box lately > (but politics...). > > kurt. > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq >