Re: High CPU Utilization

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: High CPU Utilization
Date: 2009-03-16 19:52:22
Message-ID: 200903161252.22202@hal.medialogik.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Monday 16 March 2009, Joe Uhl <joeuhl(at)gmail(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Joe Uhl 2009-03-16 20:10:01 Re: High CPU Utilization
Previous Message Jignesh K. Shah 2009-03-16 19:39:20 Re: Proposal of tunable fix for scalability of 8.4