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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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