Skip site navigation (1) Skip section navigation (2)

Re: CPU load

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Scott Marlowe *EXTERN*" <scott(dot)marlowe(at)gmail(dot)com>,<kiki(at)fesb(dot)hr>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: CPU load
Date: 2008-09-26 06:43:25
Message-ID: D960CB61B694CF459DCFB4B0128514C2028AA976@exadv11.host.magwien.gv.at (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-performance by date

Next:From: kikiDate: 2008-09-26 11:28:07
Subject: Re: CPU load
Previous:From: Greg SmithDate: 2008-09-25 21:57:35
Subject: Re: Slow updates, poor IO

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group