Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 18BCB9FB541 for ; Thu, 9 Aug 2007 01:06:37 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 88728-09 for ; Thu, 9 Aug 2007 01:06:32 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.190]) by postgresql.org (Postfix) with ESMTP id AABF89FB4DF for ; Thu, 9 Aug 2007 01:06:32 -0300 (ADT) Received: by rv-out-0910.google.com with SMTP id f1so271181rvb for ; Wed, 08 Aug 2007 21:06:30 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=axP8PXKzGoMqbEBxbIaAXPFn1Hmamt3n/+ZErb18mYhwue1FBDnTmRNrof/lFG0iSZlOlyIXcZypYPCenkCt8gLgqELyzAnPnlv/Gs7/X9cn4NdshOT0lY09jJySW/TsBOFYdsrvEytOzPXXHTPu0IOlwsvBIf3qKtmVsp01HPo= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=sXQe0KZZuujXW343awz9AjXqNd6fSJG5OGfPF97zGkv/Ij486VVm7u/12Ipsrd68DhaLBB64qup3ncP2iXq9KX8iZVqNPXoWt9JY5CIClwHm4TwNPMditkk9jywGL5/7P+gSIrvWnkjXEjZzYL27UQquF5stFp9ymQTbr/1dkjs= Received: by 10.141.159.13 with SMTP id l13mr785889rvo.1186632390147; Wed, 08 Aug 2007 21:06:30 -0700 (PDT) Received: by 10.141.98.12 with HTTP; Wed, 8 Aug 2007 21:06:30 -0700 (PDT) Message-ID: Date: Wed, 8 Aug 2007 23:06:30 -0500 From: "Scott Marlowe" To: justin Subject: Re: mid 2007 "best bang for the buck" hardware opinions Cc: pgsql-performance@postgresql.org In-Reply-To: <46BA8B52.2030204@dslr.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <46BA8B52.2030204@dslr.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/78 X-Sequence-Number: 26208 On 8/8/07, justin wrote: > I saw an interesting topic in the archives on best bang for the buck for > $20k.. about a year old now. > > So whats the thoughts on a current combined rack/disks/cpu combo around > the $10k-$15k point, currently? > > I can configure up a Dell poweredge 2900 for $9k, but am wondering if > I'm missing out on something better. > ( 9k spent with mr dell that gets you 2x quad core xeon X535s, so thats > 8 cores total, with 24gb of memory > and 8x 146gb 15k serial attached scsi connected, raid10, attached to a > perc 5/i with redundant power supplies, > all in what looks like a 3u chassis). But the system is pretty maxxed > out like that, no room for future expansion. > > better options? or a better balance for a pure db box that is mostly > smaller reads and large indexes? That's not much kit for $20k. I went to www.aberdeeninc.com and speced out a box with 24 750G barracudas, battery backed cache RAID and dual Quad core 2.66GHz xeons, and 16 Gigs of ram for $15k. Another 16gigs of ram would probably put it around 18k or so, but they didn't have the config option enabled there. I consider Dells to be mediocre hardware with mediocre support. There are lots of medium sized integration shops out there that make better servers with lots more storage for a lot less.