Re: Usage up to 50% CPU

From: Magnus Hagander
Subject: Re: Usage up to 50% CPU
Date: ,
Msg-id: 20070427080653.GB12895@svr2.hagander.net
(view: Whole thread, Raw)
In response to: Usage up to 50% CPU  ("Andres Retzlaff")
Responses: Re: Usage up to 50% CPU  ("Andres Retzlaff")
List: pgsql-performance

Tree view

Usage up to 50% CPU  ("Andres Retzlaff", )
 Re: Usage up to 50% CPU  (Magnus Hagander, )
  Re: Usage up to 50% CPU  ("Andres Retzlaff", )
   Re: Usage up to 50% CPU  (Magnus Hagander, )
    Re: Usage up to 50% CPU  (Shane Ambler, )
     Re: Usage up to 50% CPU  (Michael Stone, )
      Re: Usage up to 50% CPU  ("Andres Retzlaff", )

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:

From: Carlos Moreno
Date:
Subject: Re: Feature Request --- was: PostgreSQL Performance Tuning
From: Jim Nasby
Date:
Subject: Re: What`s wrong with JFS configuration?