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

Поиск
Список
Период
Сортировка
От Alan Hodgson
Тема Re: how can a couple of expensive queries drag my system down?
Дата
Msg-id 200803261319.06449@hal.medialogik.com
обсуждение исходный текст
Ответ на how can a couple of expensive queries drag my system down?  ("p prince" <pprince127@gmail.com>)
Список pgsql-performance
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 по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: vacuum in Postgresql 8.0.x slowing down the database
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: how can a couple of expensive queries drag my system down?