From: Yeb Havinga <yebhavinga@gmail.com>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Ivan Voras <ivoras@freebsd.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: CPUs for new databases
Date: Wed, 27 Oct 2010 09:37:35 +0200
Message-ID: <4CC7D6BF.7020105@gmail.com> (raw)
In-Reply-To: <AANLkTikvfjd_sHaaQSj-PvezhJEb0USZAyAAkY_XqHFu@mail.gmail.com>
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>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: yebhavinga@gmail.com, scott.marlowe@gmail.com, ivoras@freebsd.org
Subject: Re: CPUs for new databases
In-Reply-To: <4CC7D6BF.7020105@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox