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 97FCA32AE37 for ; Thu, 7 Oct 2004 05:13:56 +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 42791-09 for ; Thu, 7 Oct 2004 04:13:17 +0000 (GMT) Received: from wren.rentec.com (unknown [65.213.84.9]) by svr1.postgresql.org (Postfix) with ESMTP id 4F1B932A5C7 for ; Thu, 7 Oct 2004 05:06:52 +0100 (BST) Received: from [172.16.160.107] (stange-dhcp1.rentec.com [172.16.160.107]) by wren.rentec.com (8.12.9/8.12.1) with ESMTP id i9745LBD002387; Thu, 7 Oct 2004 00:05:21 -0400 (EDT) Message-ID: <4164B48C.9060202@rentec.com> Date: Wed, 06 Oct 2004 23:14:20 -0400 From: Alan Stange User-Agent: Mozilla Thunderbird 0.7 (X11/20040615) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Gaetano Mendola Cc: 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> In-Reply-To: <41648446.5020102@bigfoot.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/76 X-Sequence-Number: 8552 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 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