Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id BE25B2E33B7 for ; Mon, 4 Feb 2008 20:11:15 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 10775-08 for ; Mon, 4 Feb 2008 20:11:04 -0400 (AST) Received: from oxford.xeocode.com (unknown [87.127.95.196]) by postgresql.org (Postfix) with ESMTP id 7881E2E02D7 for ; Mon, 4 Feb 2008 20:11:10 -0400 (AST) Received: from localhost ([127.0.0.1] helo=oxford.xeocode.com) by oxford.xeocode.com with esmtp (Exim 4.69) (envelope-from ) id 1JMBOq-0001ah-2Q; Tue, 05 Feb 2008 00:10:56 +0000 To: "Jignesh K. Shah" Cc: "Greg Smith" , "Simon Riggs" , Subject: Re: Benchmark Data requested In-Reply-To: <47A797E5.4000507@sun.com> (Jignesh K. Shah's message of "Mon\, 04 Feb 2008 17\:55\:33 -0500") User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.1 (gnu/linux) X-Draft-From: ("nnimap+mail01.enterprisedb.com:INBOX.performance" 4124) References: <1202150236.4252.521.camel@ebony.site> <47A797E5.4000507@sun.com> From: Gregory Stark Organization: EnterpriseDB Date: Tue, 05 Feb 2008 00:10:55 +0000 Message-ID: <873as85kkw.fsf@oxford.xeocode.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/19 X-Sequence-Number: 28561 "Jignesh K. Shah" writes: > Then for the power run that is essentially running one query at a time should > essentially be able to utilize the full system (specially multi-core systems), > unfortunately PostgreSQL can use only one core. (Plus since this is read only > and there is no separate disk reader all other processes are idle) and system > is running at 1/Nth capacity (where N is the number of cores/threads) Is the whole benchmark like this or is this just one part of it? Is the i/o system really able to saturate the cpu though? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production Tuning