Re: Usage up to 50% CPU - Mailing list pgsql-performance

From Michael Stone
Subject Re: Usage up to 50% CPU
Date
Msg-id 20070427125242.GZ2422@mathom.us
Whole thread Raw
In response to Re: Usage up to 50% CPU  (Shane Ambler <pgsql@Sheeky.Biz>)
Responses Re: Usage up to 50% CPU  ("Andres Retzlaff" <andres_retzlaff@hotmail.com>)
List pgsql-performance
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 by date:

Previous
From: Shane Ambler
Date:
Subject: Re: Usage up to 50% CPU
Next
From: Carlos Moreno
Date:
Subject: Re: Feature Request --- was: PostgreSQL Performance Tuning