X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6C58D32A0F8 for ; Thu, 7 Oct 2004 16:48:55 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 10588-02 for ; Thu, 7 Oct 2004 15:48:52 +0000 (GMT) Received: from snowwhite.lulu.com (mail.lulu.com [66.193.5.50]) by svr1.postgresql.org (Postfix) with ESMTP id 9B8B132A04B for ; Thu, 7 Oct 2004 16:48:49 +0100 (BST) Received: from [10.0.0.32] (meatwad.rdu.lulu.com [10.0.0.32]) (authenticated bits=0) by snowwhite.lulu.com (8.12.8/8.12.8) with ESMTP id i97FnVbO022152 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NO); Thu, 7 Oct 2004 11:49:32 -0400 Message-ID: <41656559.70100@lulu.com> Date: Thu, 07 Oct 2004 11:48:41 -0400 From: Bill Montgomery User-Agent: Mozilla Thunderbird 0.7.3 (X11/20040803) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Alan Stange Cc: Gaetano Mendola , pgsql-performance@postgresql.org Subject: Re: Excessive context switching on SMP Xeons References: <4162CA14.6080206@lulu.com> <200410050947.36174.josh@agliodbs.com> <41630D50.3020308@lulu.com> <200410051538.51664.josh@agliodbs.com> <41636D8E.1090403@rentec.com> <41648446.5020102@bigfoot.com> <4164B48C.9060202@rentec.com> In-Reply-To: <4164B48C.9060202@rentec.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/82 X-Sequence-Number: 8558 Alan Stange wrote: > Here's a few numbers from the Opteron 250. If I get some time I'll > post a more comprehensive comparison including some other systems. > > The system is a Sun v20z. Dual Opteron 250, 2.4Ghz, Linux 2.6, 8 GB > memory. I did a compile and install of pg 8.0 beta 3. I created a > data base on a tmpfs file system and ran pgbench. Everything was "out > of the box", meaning I did not tweak any config files. > > I used this for pgbench: > $ pgbench -i -s 32 > > and this for pgbench invocations: > $ pgbench -s 32 -c 1 -t 10000 -v > > > clients tps 1 1290 2 > 1780 4 1760 8 1680 > 16 1376 32 904 The same test on a Dell PowerEdge 1750, Dual Xeon 3.2 GHz, 512k cache, HT on, Linux 2.4.21-20.ELsmp (RHEL 3), 4GB memory, pg 7.4.5: $ pgbench -i -s 32 pgbench $ pgbench -s 32 -c 1 -t 10000 -v clients tps avg CS/sec ------- ----- ---------- 1 601 48,000 2 889 77,000 4 1006 80,000 8 985 59,000 16 966 47,000 32 913 46,000 Far less performance that the Dual Opterons with a low number of clients, but the gap narrows as the number of clients goes up. Anyone smarter than me care to explain? Anyone have a 4-way Opteron to run the same benchmark on? -Bill > How are these results useful? In some sense, this is a speed of light > number for the Opteron 250. You'll never go faster on this system > with a real storage subsystem involved instead of a tmpfs file > system. It's also a set of numbers that anyone else can reproduce as > we don't have to deal with any differences in file systems, disk > subsystems, networking, etc. Finally, it's a set of results that > anyone else can compute on Xeon's or other systems and make a simple > (and naive) comparisons. > > > Just to stay on topic: vmstat reported about 30K cs / second while > this was running the 1 and 2 client cases. > > -- Alan