From: Alan Hodgson <ahodgson@simkin.ca>
To: pgsql-performance@postgresql.org
Subject: Re: High CPU Utilization
Date: Mon, 16 Mar 2009 12:52:22 -0700
Message-ID: <200903161252.22202@hal.medialogik.com> (raw)
In-Reply-To: <8609D1C0-3ECD-4A4F-B9C6-1FC8496EDC7A@gmail.com>
References: <8609D1C0-3ECD-4A4F-B9C6-1FC8496EDC7A@gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ahodgson@simkin.ca
Subject: Re: High CPU Utilization
In-Reply-To: <200903161252.22202@hal.medialogik.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox