Re: High CPU Utilization - Mailing list pgsql-performance

From Alan Hodgson
Subject Re: High CPU Utilization
Date
Msg-id 200903161252.22202@hal.medialogik.com
Whole thread Raw
In response to High CPU Utilization  (Joe Uhl <joeuhl@gmail.com>)
Responses Re: High CPU Utilization
List pgsql-performance
On Monday 16 March 2009, Joe Uhl <joeuhl@gmail.com> wrote:
> Right now (not under peak load) this server is running at 68% CPU
> utilization and its SATA raid 10 is doing about 2MB/s writes and 11MB/
> s reads.  When I run dd I can hit 200+MB/s writes and 230+ MB/s reads,
> so we are barely using the available IO.  Further when I run dd the
> CPU utilization of that process only approaches 20%-30% of one core.

What does vmstat say when it's slow? The output of "vmstat 1 30" would be
informative.

note: dd is sequential I/O. Normal database usage is random I/O.

--
Even a sixth-grader can figure out that you can’t borrow money to pay off
your debt

pgsql-performance by date:

Previous
From: "Jignesh K. Shah"
Date:
Subject: Re: Proposal of tunable fix for scalability of 8.4
Next
From: Joe Uhl
Date:
Subject: Re: High CPU Utilization