Re: query using cpu nearly 100%, why? - Mailing list pgsql-performance

From Richard Huxton
Subject Re: query using cpu nearly 100%, why?
Date
Msg-id 200312061746.33037.dev@archonet.com
Whole thread Raw
In response to query using cpu nearly 100%, why?  (LIANHE SHAO <lshao2@jhmi.edu>)
List pgsql-performance
On Friday 05 December 2003 21:03, LIANHE SHAO wrote:
> Hello,
> I use php as front-end to query our database. When I use System Monitor to
> check the usage of cpu and memory, I noticed that the cpu very easily gets
> up to 100%. Is that normal? if not, could someone points out possible
> reason?

The idea is that CPU should go to 100% when there's work to be done, and drop
off when the system is idle. There's nothing to be gained with having the CPU
at 50% and taking twice as long to perform a task.

--
  Richard Huxton
  Archonet Ltd

pgsql-performance by date:

Previous
From: "Rob Sell"
Date:
Subject: Pgbench results
Next
From: Neil Conway
Date:
Subject: Re: query using cpu nearly 100%, why?