Postgres Pro
Downloads
Home   >   mailing lists

Re: Usage up to 50% CPU - Mailing list pgsql-performance

From Magnus Hagander
Subject Re: Usage up to 50% CPU
Date
Msg-id 20070427080653.GB12895@svr2.hagander.net
Whole thread Raw
In response to Usage up to 50% CPU  ("Andres Retzlaff" <andres_retzlaff@hotmail.com>)
Responses Re: Usage up to 50% CPU  ("Andres Retzlaff" <andres_retzlaff@hotmail.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Florian Weimer
Date:
Subject: Re: Filesystem fragmentation (Re: Fragmentation of WAL files)
Next
From: "Andres Retzlaff"
Date:
Subject: Re: Usage up to 50% CPU