Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id C19281337B3E for ; Tue, 12 Apr 2011 13:01:58 -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 86199-05 for ; Tue, 12 Apr 2011 16:01:51 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from nm15-vm0.bullet.mail.ukl.yahoo.com (nm15-vm0.bullet.mail.ukl.yahoo.com [217.146.183.252]) by mail.postgresql.org (Postfix) with SMTP id 69ADE1337A5D for ; Tue, 12 Apr 2011 13:01:50 -0300 (ADT) Received: from [217.146.183.214] by nm15.bullet.mail.ukl.yahoo.com with NNFMP; 12 Apr 2011 16:01:49 -0000 Received: from [217.146.183.174] by tm7.bullet.mail.ukl.yahoo.com with NNFMP; 12 Apr 2011 16:01:49 -0000 Received: from [127.0.0.1] by omp1015.mail.ukl.yahoo.com with NNFMP; 12 Apr 2011 16:01:49 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 389484.19844.bm@omp1015.mail.ukl.yahoo.com Received: (qmail 97217 invoked by uid 60001); 12 Apr 2011 16:01:49 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.uk; s=s1024; t=1302624109; bh=b9dmw2k0baDVyaJCfgK7/K1MFlgNh+MYkgaTtFs+xRg=; 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=tOKZ2IF5ub9SWEiMqrTp/vPtpz9S0wTPhk1oq+MI9DROcdNK6oql+EVbE/d7p8C5otVPMzOds6BmEOg2tLfw9OTxcnnUBWcm3xNaf5WI+mHYrnfbT9xIPDBr+ckeVfrjXMOXYVl7tUrxKX2Jp7Nv6ho2yKrP2LcQjvA/68GFflo= 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=QPUdwzY7OaruV5zHofWf9fASCBCYjZYBwau+SRbuzV9Dmw+QaRZAsoy5l6CG3dEzxzoBOr7JrQwlv04JA2hoxVVcjL9ATA35s65VvUd61SqPnW0qgohX3FL8UOmYs4taiAPuTzt6O2GidQjvM4A8jk8tF2UXLkmm4c7lDPWgt9s=; Message-ID: <281886.96944.qm@web26007.mail.ukl.yahoo.com> X-YMail-OSG: EtbCPmAVM1ldNWwQqVvp1ylAa1omBhajdxs8Gx8ZBLEJNZM 13ROrysaYhPgij1JSZfoNv8YP4XZpoIp99gttpNZ84lrnJdZvGowlH75ZCS2 nyhUozJYdlxwEW5Kml00s7T9lgCcTN0MtnVwzqrV6eGWuapRvcooQrQktaWC 96NR5oS3z1LS4nz6BYaTr0RQLmX3sCz4GyN4Pp3ODiSQfoT8AStGam46ti5Q h4jYnhstegsLe6TDBF3X1yQIDhs77wvMC5ljPPuPt31XS0L.buzCn_HeppBR zftMv25EgPEwm3efEXO.B8jH3M3EaqrjZnsJkqhgi.5MtVlu88gxKPDqcvqd hzYKZzM4tMQc.4mEhAJRdV8E_bA-- Received: from [83.100.146.195] by web26007.mail.ukl.yahoo.com via HTTP; Tue, 12 Apr 2011 17:01:49 BST X-Mailer: YahooMailClassic/12.0.2 YahooMailWebService/0.8.109.295617 Date: Tue, 12 Apr 2011 17:01:49 +0100 (BST) From: Glyn Astill Subject: Re: Linux: more cores = less concurrency. To: Merlin Moncure Cc: Kevin Grittner , david@lang.hm, Steve Clark , "Joshua D. Drake" , Scott Marlowe , pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 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/160 X-Sequence-Number: 43222 --- On Tue, 12/4/11, Merlin Moncure wrote:=0A=0A> >>> = Can we see some iobound and cpubound pgbench=0A> runs on both=0A> >>> serve= rs?=0A> >>>=0A> >>=0A> >> Of course, I'll post when I've gotten to that.=0A= > >=0A> > Ok, there's no writing going on -- so the i/o tets=0A> aren't nec= essary.=0A> > Context switches are also not too high -- the problem=0A> is = likely in=0A> > postgres or on your end.=0A> >=0A> > However, I Would still= like to see:=0A> > pgbench select only tests:=0A> > pgbench -i -s 1=0A> > = pgbench -S -c 8 -t 500=0A> > pgbench -S -c 32 -t 500=0A> > pgbench -S -c 80= -t 500=0A> >=0A> > pgbench -i -s 500=0A> > pgbench -S -c 8 -t 500=0A> > pg= bench -S -c 32 -t 500=0A> > pgbench -S -c 80 -t 500=0A> >=0A> > write out b= ench.sql with:=0A> > begin;=0A> > select * from heavy_seat_function();=0A> = > select * from heavy_seat_function();=0A> > commit;=0A> >=0A> > pgbench -n= bench.sql -c 8 -t 500=0A> > pgbench -n bench.sql -c 8 -t 500=0A> > pgbench= -n bench.sql -c 8 -t 500=0A> =0A> whoops:=0A> pgbench -n bench.sql -c 8 -t= 500=0A> pgbench -n bench.sql -c 32 -t 500=0A> pgbench -n bench.sql -c 80 -= t 500=0A> =0A> merlin=0A> =0A=0ARight, here they are:=0A=0Ahttp://www.priva= tepaste.com/3dd777f4db=0A=0A