> 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 of them. 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. Yours, Laurenz Albe -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
