From: Michael Stone <mstone+postgres@mathom.us>
To: pgsql-performance@postgresql.org
Subject: Re: Usage up to 50% CPU
Date: Fri, 27 Apr 2007 08:52:45 -0400
Message-ID: <20070427125242.GZ2422@mathom.us> (raw)
In-Reply-To: <4631C825.9000705@Sheeky.Biz>
References: <20070427080653.GB12895@svr2.hagander.net>
<BAY141-F1845ACAADC609F4311EA888B4F0@phx.gbl>
<20070427081350.GD12895@svr2.hagander.net>
<4631C825.9000705@Sheeky.Biz>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mstone+postgres@mathom.us
Subject: Re: Usage up to 50% CPU
In-Reply-To: <20070427125242.GZ2422@mathom.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox