Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id DFFF41337C74 for ; Mon, 11 Apr 2011 18:15:10 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 01370-05-5 for ; Mon, 11 Apr 2011 21:15:03 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from nm7.bullet.mail.ukl.yahoo.com (nm7.bullet.mail.ukl.yahoo.com [217.146.182.248]) by mail.postgresql.org (Postfix) with SMTP id C89791337D50 for ; Mon, 11 Apr 2011 18:08:10 -0300 (ADT) Received: from [217.146.183.209] by nm7.bullet.mail.ukl.yahoo.com with NNFMP; 11 Apr 2011 21:08:10 -0000 Received: from [217.146.183.74] by tm2.bullet.mail.ukl.yahoo.com with NNFMP; 11 Apr 2011 21:08:10 -0000 Received: from [127.0.0.1] by omp1035.mail.ukl.yahoo.com with NNFMP; 11 Apr 2011 21:08:10 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 228689.70011.bm@omp1035.mail.ukl.yahoo.com Received: (qmail 63670 invoked by uid 60001); 11 Apr 2011 21:08:10 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.uk; s=s1024; t=1302556090; bh=xZr0HCuxp5GuH7D2ArcZ9tIb/kvIdlMICexcg1LKE9I=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=1Wx65fF+fzjntb3cEYf+ZNp/F3BwsRSzQq0rCziBuyAhqd50yrIFcFK+aKEUAIubBHdbEVyV0As4epeIbXW2/PlpDqbg+lWDc2500PXGCuXwknaYy8u5yckAgoArzEVvJb8K/m08e5RS3rp1k69y29RbUD+agjY/frrw93VIwBk= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.uk; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=tcv/UN4sxKKtTS3BJfC/W+fH2LU0JJ/iBOsKsYF/fy+ibP6z2Trd7VxdDT4rZRu4xbDSwBysK2xPu0APZ7FvrQrTDRVackO5QDDf6eF+BA2lbYd2YQN0yrwyV+xucgw34FmDTFMXUtYkS9ONCilikg50S+EJKqvFbkmjf7W7VD0=; Message-ID: <110350.63036.qm@web26004.mail.ukl.yahoo.com> X-YMail-OSG: YztM1uEVM1lW_QQmRXiFzcwwD1WM7W0eKD66gG28Lwfm.3A igRAtNSZVba5Vw2qtq8w7yZ5ch3MWZ2GBLHXt_DpkPA_aTQsxB24gUzSBkGE QDGUrR3TqO5ZuLJ1qTdENTKD3Rffnm0xmZWjEA9FkjqhDabqvHBV2Kslo2Xo ZzV8E0pze4Byk4CqllIV9vli.Q24nTQSiNuMirQ_..tjRAbC73fKMbBZD0Ju U8upl1ophTfDdQyJjUK.6TX41QuCOShDFpUb8g6w5pgTj_XQiu0klwW2u3Wj epvkZqYsquKOlx80M4U8pVEeo6QOphGGOzEBdqiVYN_oA.pCaW8PgxmTFQX9 YY7tdO8PUEdZsgR.AteOhyR369Q-- Received: from [81.98.134.44] by web26004.mail.ukl.yahoo.com via HTTP; Mon, 11 Apr 2011 22:08:09 BST X-Mailer: YahooMailClassic/12.0.2 YahooMailWebService/0.8.109.295617 Date: Mon, 11 Apr 2011 22:08:09 +0100 (BST) From: Glyn Astill Subject: Re: Linux: more cores = less concurrency. To: Scott Marlowe Cc: Kevin Grittner , "Joshua D. Drake" , pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.898 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RFC_ABUSE_POST=0.001 X-Spam-Level: X-Archive-Number: 201104/124 X-Sequence-Number: 43186 =0A=0A--- On Mon, 11/4/11, Scott Marlowe wrote:= =0A=0A> From: Scott Marlowe =0A> Subject: Re: [PER= FORM] Linux: more cores =3D less concurrency.=0A> To: "Glyn Astill" =0A> Cc: "Kevin Grittner" , "= Joshua D. Drake" , pgsql-performance@postgresql.org= =0A> Date: Monday, 11 April, 2011, 21:52=0A> On Mon, Apr 11, 2011 at 1:42 P= M, Glyn=0A> Astill =0A> wrote:=0A> =0A> > A wild gu= ess is something like multiple cores=0A> contending for cpu cache, cpu affi= nity, or some kind of=0A> contention in the kernel, alas a little out of my= depth.=0A> >=0A> > It's pretty sickening to think I can't get anything=0A>= else out of more than 8 cores.=0A> =0A> Have you tried running the memory = stream benchmark Greg=0A> Smith had=0A> posted here a while back?=A0 It'll = let you know if=0A> you're memory is=0A> bottlenecking.=A0 Right now my 48 = core machines are the=0A> king of that=0A> benchmark with something like 70= +Gig a second.=0A> =0A=0ANo I haven't, but I will first thing tomorow morni= ng. I did run a sysbench memory write test though, if I recall correctly t= hat gave me somewhere just over 3000 Mb/s=0A=0A