Postgres Pro
Downloads
Home   >   mailing lists

Re: how can a couple of expensive queries drag my system down? - Mailing list pgsql-performance

From Alan Hodgson
Subject Re: how can a couple of expensive queries drag my system down?
Date
Msg-id 200803261319.06449@hal.medialogik.com
Whole thread Raw
In response to how can a couple of expensive queries drag my system down?  ("p prince" <pprince127@gmail.com>)
List pgsql-performance
Tree view 
On Wednesday 26 March 2008, "p prince" <pprince127@gmail.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

pgsql-performance by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: vacuum in Postgresql 8.0.x slowing down the database
Next
From: "Scott Marlowe"
Date:
Subject: Re: how can a couple of expensive queries drag my system down?