Re: how can a couple of expensive queries drag my system down?

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: how can a couple of expensive queries drag my system down?
Date: 2008-03-26 20:19:06
Message-ID: 200803261319.06449@hal.medialogik.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wednesday 26 March 2008, "p prince" <pprince127(at)gmail(dot)com> wrote:
> Is this a sign of disk contention?

Yes.

> How does CPU load come into play?

Processes waiting for disk I/O generally show up as load.

--
Alan

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2008-03-26 20:31:32 Re: how can a couple of expensive queries drag my system down?
Previous Message Joshua D. Drake 2008-03-26 20:02:13 Re: vacuum in Postgresql 8.0.x slowing down the database