Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 871789FC08C for ; Fri, 27 Apr 2007 05:10:55 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 92183-02 for ; Fri, 27 Apr 2007 05:10:48 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from bay0-omc3-s23.bay0.hotmail.com (bay0-omc3-s23.bay0.hotmail.com [65.54.246.223]) by postgresql.org (Postfix) with ESMTP id 285689FB9B1 for ; Fri, 27 Apr 2007 05:10:51 -0300 (ADT) Received: from hotmail.com ([65.55.152.98]) by bay0-omc3-s23.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Fri, 27 Apr 2007 01:10:50 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Fri, 27 Apr 2007 01:10:49 -0700 Message-ID: Received: from 65.55.152.123 by by141fd.bay141.hotmail.msn.com with HTTP; Fri, 27 Apr 2007 08:10:48 GMT X-Originating-IP: [202.7.166.163] X-Originating-Email: [andres_retzlaff@hotmail.com] X-Sender: andres_retzlaff@hotmail.com In-Reply-To: <20070427080653.GB12895@svr2.hagander.net> From: "Andres Retzlaff" To: magnus@hagander.net Cc: pgsql-performance@postgresql.org Subject: Re: Usage up to 50% CPU Date: Fri, 27 Apr 2007 08:10:48 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 27 Apr 2007 08:10:49.0998 (UTC) FILETIME=[912C12E0:01C788A3] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/460 X-Sequence-Number: 24337 Hi Magnus, in this case each CPU goes up to 50%, giveing me 50% total usage. I was specting as you say 1 query 100% cpu. Any ideas? Andrew On Fri, Apr 27, 2007 at 04:43:06AM +0000, Andres Retzlaff wrote: > Hi, > > I have pg 8.1.4 running in > Windows XP Pro > wirh a Pentium D > > and I notice that I can not use more than 50% of the cpus (Pentium D has 2 > cpus), how can I change the settings to use the 100% of it. A single query will only use one CPU. If you have multiple parallell clients, they will use the differnt CPUs. //Magnus _________________________________________________________________ Advertisement: Its simple! Sell your car for just $30 at carsales.com.au http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fsecure%2Dau%2Eimrworldwide%2Ecom%2Fcgi%2Dbin%2Fa%2Fci%5F450304%2Fet%5F2%2Fcg%5F801577%2Fpi%5F1005244%2Fai%5F838588&_t=754951090&_r=tig&_m=EXT