Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 02506632571 for ; Tue, 31 Aug 2010 15:52:53 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 02374-09 for ; Tue, 31 Aug 2010 18:52:45 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-ew0-f46.google.com (mail-ew0-f46.google.com [209.85.215.46]) by mail.postgresql.org (Postfix) with ESMTP id 96C55632677 for ; Tue, 31 Aug 2010 15:52:45 -0300 (ADT) Received: by ewy23 with SMTP id 23so3922587ewy.19 for ; Tue, 31 Aug 2010 11:52:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from :user-agent:mime-version:to:cc:subject:references:in-reply-to :content-type:content-transfer-encoding; bh=hULW2KHhDtMe3i5291gt3jkrIRavWvcW1klK0Y2qJng=; b=g8Gi6lGEsqDbIkjdsaWUx2jROcUHAiulJpUWWbnLTdx1/bICuRIK+LeVaeC/fRFoDi 8Bk7uAtn3IAQ+zP4YI4A1AIhnzZ2gPGKPLdyD06F9sxvLANWAUJdCg2QtCHnLYoBY9yl UCg0Z9/gYDm3C+MdQyLNSs802BhodsBbq4Vtk= 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=kZM+D646uB+u7a3wjxm4u4Z+f78XbRCWdf078GafgO2SBfZUrXbJwaSILN61FujTNt dgwphk2rmsiXC7uBPAlk0BwDkpfn9zFloT9UU3KL4lX5w2Wmye0SBScEjytfo/soBeJs vxiH9DXL18NafO3uQVGqmG/hbiCmj6afSFQHw= Received: by 10.213.21.140 with SMTP id j12mr10219783ebb.98.1283280760843; Tue, 31 Aug 2010 11:52:40 -0700 (PDT) Received: from [0.0.0.0] (5357DA75.cable.casema.nl [83.87.218.117]) by mx.google.com with ESMTPS id a48sm14516413eei.1.2010.08.31.11.52.39 (version=TLSv1/SSLv3 cipher=RC4-MD5); Tue, 31 Aug 2010 11:52:39 -0700 (PDT) Message-ID: <4C7D5021.3090803@gmail.com> Date: Tue, 31 Aug 2010 20:55:29 +0200 From: Yeb Havinga User-Agent: Thunderbird 2.0.0.24 (Windows/20100228) MIME-Version: 1.0 To: Scott Marlowe CC: Greg Smith , Jose Ildefonso Camargo Tolosa , "pgsql-performance@postgresql.org" Subject: Re: Performance on new 64bit server compared to my 32bit desktop References: <4C6CE64D.6070104@edd.fr> <4C6D76FE.9010407@2ndquadrant.com> <4C77F4F4.4020900@2ndquadrant.com> <4C7B6498.5040800@gmail.com> <4C7BCB2E.3090100@2ndquadrant.com> <4C7CF886.5040603@gmail.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201008/359 X-Sequence-Number: 40202 Scott Marlowe wrote: > On Tue, Aug 31, 2010 at 6:41 AM, Yeb Havinga wrote: > >>> export OMP_NUM_THREADS=4 >>> >> Then I get the following. The rather wierd dip at 5 threads is consistent >> over multiple tries: >> >> > > I get similar dips on my server. Especially as you make the stream > test write a large enough chunk of data to outrun its caches. > > See attached png. > Interesting graph, especially since the overall feeling is a linear like increase in memory bandwidth when more cores are active. Just curious, what is the 8-core cpu? -- Yeb