Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1THLoY-0006dd-K9 for pgsql-performance@postgresql.org; Thu, 27 Sep 2012 21:40:10 +0000 Received: from mail-bk0-f46.google.com ([209.85.214.46]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1THLoW-0005EI-6l for pgsql-performance@postgresql.org; Thu, 27 Sep 2012 21:40:10 +0000 Received: by bkcjk13 with SMTP id jk13so2580245bkc.19 for ; Thu, 27 Sep 2012 14:40:07 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=content-type:mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to:x-mailer; bh=5voPPzCc6Ma2abJ9z8fvE9Kl3rjbZoP8kzKvxj7vB+U=; b=o4UM9XdKnjVZZl6Y2baxwZY8VIQqlDlY+6H4jbYYxo7TeK5xJPt4mS9yIv/sAjaW30 32IhNB0B8X2cNTZCFm4nvhgGIFGxC35V7wFVsKyHWPE0dwyPRrJ5at467BCFXo2+flj2 2GtfFOCTZrS3OwAuCqrq/RLHTguxpWKSFUiBOndoEDpQNUevQccY7Uya59nf3M9GSn3w vUmxI/EGzljJvjl486pArRuEGG/pKd0tZ5S3eZ+tlPGoG/hIJqNRGvEnnkirfutZlw76 sVtM6Y0o1eArp1crgBIfAxxg4FT6rDHK3zSZyBl4sPwUKAkU/c7D7dyMfx6vUAmQ+zII Qt0g== Received: by 10.112.17.40 with SMTP id l8mr1642688lbd.58.1348782007663; Thu, 27 Sep 2012 14:40:07 -0700 (PDT) Received: from [192.168.20.5] (37-144-24-89.broadband.corbina.ru. [37.144.24.89]) by mx.google.com with ESMTPS id c6sm2042315lbn.1.2012.09.27.14.40.06 (version=TLSv1/SSLv3 cipher=OTHER); Thu, 27 Sep 2012 14:40:07 -0700 (PDT) Content-Type: text/plain; charset=iso-8859-1 Mime-Version: 1.0 (Mac OS X Mail 6.1 \(1498\)) Subject: Re: hardware advice From: Evgeny Shishkin In-Reply-To: Date: Fri, 28 Sep 2012 01:40:06 +0400 Cc: Claudio Freire , David Boreham , pgsql-performance@postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: <836EC2BA-9963-4AC3-B9BB-4E4F2EDEF15E@gmail.com> References: <5064A4DC.5090304@turnkey.bz> <5064ABA1.7030507@boreham.org> <5064BB66.2080202@optionshouse.com> <5064C033.90506@boreham.org> To: Scott Marlowe X-Mailer: Apple Mail (2.1498) X-Pg-Spam-Score: -2.7 (--) X-Archive-Number: 201209/183 X-Sequence-Number: 47929 On Sep 28, 2012, at 1:36 AM, Scott Marlowe = wrote: > On Thu, Sep 27, 2012 at 3:16 PM, Claudio Freire = wrote: >> On Thu, Sep 27, 2012 at 6:08 PM, David Boreham = wrote: >>>>=20 >>>> We went from Dunnington to Nehalem, and it was stunning how much = better >>>> the X5675 was compared to the E7450. Sandy Bridge isn't quite that = much of a >>>> jump though, so if you don't need that kind of bleeding-edge, you = might be >>>> able to save some cash. This is especially true since the E5-2600 = series has >>>> the same TDP profile and both use 32nm lithography. >>>=20 >>> We use Opteron on a price/performance basis. Intel always seems to = come up >>> with some way to make their low-cost processors useless (such as = limiting >>> the amount of memory they can address). >>=20 >> Careful with AMD, since many (I'm not sure about the latest ones) >> cannot saturate the memory bus when running single-threaded. So, = great >> if you have a high concurrent workload, quite bad if you don't. >=20 > Conversely, we often got MUCH better parallel performance from our > quad 12 core opteron servers than I could get on a dual 8 core xeon at > the time. The newest quad 10 core Intels are about as fast as the > quad 12 core opteron from 3 years ago. So for parallel operation, do > remember to look at the opteron. It was much cheaper to get highly > parallel operation on the opterons than the xeons at the time we got > the quad 12 core machine at my last job. >=20 But what about latency, not throughput?=