DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject
	:references:in-reply-to:content-type:content-transfer-encoding;
	b=iUHbRK2Nz+0upV4yhW9L33Dbaa9CxFiGMvS4z/m5nTylMnrKLDTSP9G+LIwHNtsdBb
	Y4bDnt6uvCYxhHX+T7Uqr60VpErSNfF04sb1kFlaVuub/Szehm0i6JIwX7SRaf6h2BJL
	rpY0e0mpI+5ajLNQ5uaDe/PdcZmhdXvVxS8wo=
Message-ID: <4CC7D6BF.7020105@gmail.com>
Date: Wed, 27 Oct 2010 09:37:35 +0200
From: Yeb Havinga <yebhavinga@gmail.com>
User-Agent: Thunderbird 2.0.0.24 (Windows/20100228)
MIME-Version: 1.0
To: Scott Marlowe <scott.marlowe@gmail.com>
CC: Ivan Voras <ivoras@freebsd.org>, pgsql-performance@postgresql.org
Subject: Re: CPUs for new databases
References: <4CC6CFAA.10107@one.com>
	<AANLkTi=ScGQiHB2ch+C_+K14TgjaO_3+x0+28QOFYeUU@mail.gmail.com>
	<4CC73FEF.9020805@agliodbs.com>	<m3ocagplgf.fsf@jhcloos.com>
	<ia7r55$5ih$1@dough.gmane.org>
	<AANLkTikvfjd_sHaaQSj-PvezhJEb0USZAyAAkY_XqHFu@mail.gmail.com>
In-Reply-To: <AANLkTikvfjd_sHaaQSj-PvezhJEb0USZAyAAkY_XqHFu@mail.gmail.com>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit

Scott Marlowe wrote:
> There was an earlier thread with
> Greg and I in it where we posted the memory bandwidth numbers for that
> machine and it was insane how much data all 48 cores could pump into /
> out of memory at the same time.
>   
Yeah, it was insane. Building a economical 'that generation opteron' 
database server has been on my wishlist since that thread, my current 
favorite is the 8-core 6128 opteron, for $275,- at newegg 
http://www.newegg.com/Product/Product.aspx?Item=N82E16819105266

Ah might as well drop the whole config on my wishlist as well:

2 times that 8 core processor
Supermicro H8DGU-F motherboard - 16 dimm slots, dual socket, dual Intel 
ethernet and additional ethernet for IPMI.
2 times KVR1333D3D4R9SK8/32G memory - 4GB dimms seem to be at the GB/$ 
sweet spot at the moment for DDR3
1 time OCZ Vertex 2 Pro 100GB (there was a thread about this sandforce 
disk as well: a SSD with supercap that acts as battery backup)
maybe another one or two spindled 2.5" drives for archive/backup.
Supermicro 113TQ-563UB chassis

At the time I looked this up, I could buy it for just over €3000,-

regards
Yeb Havinga

PS: I'm in no way involved with either of the manufacturers, nor one of 
their fanboys. I'm just interested, like the OP, what is good 
hardware/config for a PG related server.