> If that's what it looks like your server is running just fine. Load
> of 1.31, 85+% idle, no wait time. Or is that top and vmstat output
> from when the server is running fine?
Don't forget that there are 8 CPUs, and the backend will only run on one
But I concur that this seems ok.
How many rows are returned? Is 0.6 seconds an unacceptable time for that?
If there is a lot of sorting going on and the pages are residing in the
buffer, I would expect high CPU load.
Normally, I am quite happy if my database is CPU bound. I start worrying
if I/O wait grows too high.
In response to
pgsql-performance by date
|Next:||From: kiki||Date: 2008-09-26 11:28:07|
|Subject: Re: CPU load|
|Previous:||From: Greg Smith||Date: 2008-09-25 21:57:35|
|Subject: Re: Slow updates, poor IO|