Re: random slow query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tuesday 30 June 2009, Mike Ivanov <mikei@xxxxxxxxxxxxxxx> 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.

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux