Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1THLdm-0008R7-AL for pgsql-performance@postgresql.org; Thu, 27 Sep 2012 21:29:02 +0000 Received: from server13-scl.nuevasync.com ([64.13.138.208] helo=mail.nuevasync.com) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1THLdk-00050z-J5 for pgsql-performance@postgresql.org; Thu, 27 Sep 2012 21:29:01 +0000 Received: from [192.168.1.4] (59.sub-70-196-195.myvzw.com [70.196.195.59]) by mail.nuevasync.com (Postfix) with ESMTP id 4C882458006 for ; Thu, 27 Sep 2012 15:28:59 -0600 (MDT) Message-ID: <5064C506.9090205@boreham.org> Date: Thu, 27 Sep 2012 15:28:38 -0600 From: David Boreham User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:15.0) Gecko/20120907 Thunderbird/15.0.1 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: hardware advice References: <5064A4DC.5090304@turnkey.bz> <5064ABA1.7030507@boreham.org> <5064BB66.2080202@optionshouse.com> <5064C033.90506@boreham.org> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201209/178 X-Sequence-Number: 47924 On 9/27/2012 3:16 PM, Claudio Freire wrote: > 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. > Actually we test memory bandwidth with John McCalpin's stream program. Unfortunately it is hard to find stream test results for recent machines so it can be hard to compare two boxes unless you own examples, so I didn't mention it as a useful option. But if you can find results for the machines, or ask a friend to run it for you...definitely useful information.