Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 9959F1337990 for ; Tue, 12 Apr 2011 13:07:10 -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 02167-02 for ; Tue, 12 Apr 2011 16:07:03 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from nm16-vm0.bullet.mail.ukl.yahoo.com (nm16-vm0.bullet.mail.ukl.yahoo.com [217.146.183.254]) by mail.postgresql.org (Postfix) with SMTP id CD1A81337A5D for ; Tue, 12 Apr 2011 13:07:01 -0300 (ADT) Received: from [217.146.183.209] by nm16.bullet.mail.ukl.yahoo.com with NNFMP; 12 Apr 2011 16:07:01 -0000 Received: from [217.146.183.63] by tm2.bullet.mail.ukl.yahoo.com with NNFMP; 12 Apr 2011 16:07:01 -0000 Received: from [127.0.0.1] by omp1032.mail.ukl.yahoo.com with NNFMP; 12 Apr 2011 16:07:00 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 991655.43604.bm@omp1032.mail.ukl.yahoo.com Received: (qmail 4339 invoked by uid 60001); 12 Apr 2011 16:07:00 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.uk; s=s1024; t=1302624420; bh=ZeTmtjXNg2GVfl7oV8YbGJq6tjaqCH8JhNrp3fkmzb8=; 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=xzhmQjbN1eiOK7jEBY1pAYx4izHWS3VRSOkQql6kKBVHHuzpVzwurK4wOQqyRHBjYyXx8X0KjkvryBj5UNKWcJ9ArREM2GyM2nj+fiboJDIePTySEx+wy7f8ONDpEb02q2CZDV7VqcT2jTMDAM04duyUP7OZosoUhm/9yeX81D4= 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=c3iuYwuS5QzdlLIvZxL6DObrrspfeB314qiA2KKmTW4yDQq63qFqbyIuP0nQ+oL2OlX92ul1HWou3KMhxO+evQUloB7hOO22E35sUuqBFvhI13SuIBKWpnBBeWr0XiZS0O14Bz/HzGQn2+YbtKxoMH2GYwtJldJRzNHBMbtHaT0=; Message-ID: <812972.84286.qm@web26008.mail.ukl.yahoo.com> X-YMail-OSG: o5qJTFsVM1mCzgdPbis6ogIScCd1IiMYKR3wI3S056M_JXz vumyJVUTLIFkRpkPvNJgLX46_VVa1X7170pU6fQkVHnQjN8_33EYnOWOwEVZ SWzLNIWtFWDNq1vOxsFQsQjJTdiE5y1QGXy5k0Kg2eBoHL1.bvmlcf.MWpO5 0Nx4E1gNd_OxGMkrqPNgWciMgs28JTJLpyrRGsTeFwgn09R7mU1UWOCO5BMj XMZqNpwoKz0rw2m144Q550ydk9hI1rjjgrJqDn1y7rLCbWR40afkFn.vAPvz 8l2U4X.uZI.WXqLH7.bITHAfdtja5cP3d1qi1fClxK2z4w5.KA94b5jCHUKR JX6RNrAw1XNBI8wmnGpOOXImaTLZPkg-- Received: from [83.100.146.195] by web26008.mail.ukl.yahoo.com via HTTP; Tue, 12 Apr 2011 17:07:00 BST X-Mailer: YahooMailClassic/12.0.2 YahooMailWebService/0.8.109.295617 Date: Tue, 12 Apr 2011 17:07:00 +0100 (BST) From: Glyn Astill Subject: Re: Linux: more cores = less concurrency. To: david@lang.hm, Steve Clark , Kevin Grittner Cc: "Joshua D. Drake" , Scott Marlowe , pgsql-performance@postgresql.org In-Reply-To: <4DA41EA5020000250003C6E1@gw.wicourts.gov> 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/161 X-Sequence-Number: 43223 --- On Tue, 12/4/11, Kevin Grittner wrote:=0A= =0A> Wow, zero idle and zero wait, and single digit for=0A> system.=A0 Did = you=0A> ever run those RAM speed tests?=A0 (I don't remember=0A> seeing res= ults=0A> for that -- or failed to recognize them.)=A0 At this=0A> point, my= best=0A> guess at this point is that you don't have the bandwidth to=0A> R= AM to=0A> support the CPU power.=A0 Databases tend to push data=0A> around = in RAM a=0A> lot.=0A=0AI mentioned sysbench was giving me something like 30= 00 MB/sec on memory write tests, but nothing more.=0A=0AResults from Greg S= miths stream_scaling test are here:=0A=0Ahttp://www.privatepaste.com/4338aa= 1196=0A=0A> =0A> When I mentioned profiling, I was thinking more of oprofi= le=0A> or=0A> something like it.=A0 If it were me, I'd be going there=0A> b= y now.=0A> =0A=0AAdvice taken, it'll be my next step.=0A=0AGlyn