Re: Low CPU Usage - Mailing list pgsql-performance

From Greg Smith
Subject Re: Low CPU Usage
Date
Msg-id Pine.GSO.4.64.0709220220490.12312@westnet.com
Whole thread Raw
In response to Re: Low CPU Usage  (brauagustin-susc@yahoo.com.ar)
List pgsql-performance
On Thu, 20 Sep 2007, brauagustin-susc@yahoo.com.ar wrote:

> Which other test can I do to find if this is a hardware, kernel o
> postgres issue?

The little test hdparm does is not exactly a robust hard drive benchmark.
If you want to rule out hard drive transfer speed issues, take at look at
the tests suggested at
http://www.westnet.com/~gsmith/content/postgresql/pg-disktesting.htm and
see how your results compare to the single SATA disk example I give there.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Query planner unaware of possibly best plan
Next
From: Denes Daniel
Date:
Subject: Re: Query planner unaware of possibly best plan