Re: query using cpu nearly 100%, why?

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: query using cpu nearly 100%, why?
Дата
Msg-id 200312061746.33037.dev@archonet.com
обсуждение исходный текст
Ответ на query using cpu nearly 100%, why?  (LIANHE SHAO <lshao2@jhmi.edu>)
Список 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 по дате отправления:

Предыдущее
От: "Rob Sell"
Дата:
Сообщение: Pgbench results
Следующее
От: Neil Conway
Дата:
Сообщение: Re: query using cpu nearly 100%, why?