Skip site navigation (1) Skip section navigation (2)

Re: query using cpu nearly 100%, why?

From: Richard Huxton <dev(at)archonet(dot)com>
To: LIANHE SHAO <lshao2(at)jhmi(dot)edu>,pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: query using cpu nearly 100%, why?
Date: 2003-12-06 17:46:32
Message-ID: 200312061746.33037.dev@archonet.com (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-performance by date

Next:From: Neil ConwayDate: 2003-12-06 19:41:36
Subject: Re: query using cpu nearly 100%, why?
Previous:From: Rob SellDate: 2003-12-06 17:09:05
Subject: Pgbench results

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group