Re: Usage up to 50% CPU

Список
Период
Сортировка
От Michael Stone
Тема Re: Usage up to 50% CPU
Дата
Msg-id 20070427125242.GZ2422@mathom.us
обсуждение исходный текст
Ответ на Re: Usage up to 50% CPU  (Shane Ambler)
Ответы Re: Usage up to 50% CPU  ("Andres Retzlaff")
Список pgsql-performance
Дерево обсуждения
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 07:23:41PM +0930, Shane Ambler wrote:
>I would think that as you are sitting and watching the cpu usage, your
>query would seem to taking a while to run, leading me to wonder if you
>are getting a full table scan that is causing pg to wait for disk response?

If so, you probably wouldn't be seeing that much cpu usage... (if the
cpu is waiting for disk it's idling)

Mike Stone

В списке pgsql-performance по дате отправления:

Предыдущее
От: Ray Stell
Дата:
Сообщение: Re: Feature Request --- was: PostgreSQL Performance Tuning
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Feature Request --- was: PostgreSQL Performance Tuning