Re: CPU load - Mailing list pgsql-performance

From Albe Laurenz
Subject Re: CPU load
Date
Msg-id D960CB61B694CF459DCFB4B0128514C2028AA976@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Re: CPU load  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Responses Re: CPU load  (kiki@fesb.hr)
List pgsql-performance
> 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

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: Slow updates, poor IO
Next
From: kiki@fesb.hr
Date:
Subject: Re: CPU load