Re: random slow query

Поиск
Список
Период
Сортировка
От Alan Hodgson
Тема Re: random slow query
Дата
Msg-id 200906301147.20384@hal.medialogik.com
обсуждение исходный текст
Ответ на Re: random slow query  (Mike Ivanov <mikei@activestate.com>)
Ответы Re: random slow query  (Jean-David Beyer <jeandavid8@verizon.net>)
Список pgsql-performance
On Tuesday 30 June 2009, Mike Ivanov <mikei@activestate.com> wrote:
> Hi Scott,
>
> > Well, we can't be sure OP's only got one core.
>
> In fact, we can, Sean posted what top -b -n 1 says. There was only one
> CPU line.
>

Recent versions of top on Linux (on RedHat 5 anyway) may show only one
combined CPU line unless you break them out with an option.

> > the number of cores, it's the IO subsystem is too slow for the load.
> > More cores wouldn't fix that.
>
> While I agree on the IO, more cores would definitely help to improve
> ~6.5 load average.

No, I agree with the previous poster. His load is entirely due to IO wait.
Only one of those processes was trying to do anything. IO wait shows up as
high load averages.

В списке pgsql-performance по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: random slow query
Следующее
От: Mike Ivanov
Дата:
Сообщение: Re: random slow query