pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Frank Wiles <frank@wiles.org>
To: pg@fastcrypt.com
Cc: ajanian@scottrade.com
Cc: pgsql-performance@postgresql.org
Subject: Re: Query Performance and IOWait
Date: Fri, 19 Nov 2004 15:13:37 -0600
Message-ID: <20041119151337.477645de.frank@wiles.org> (raw)
In-Reply-To: <419CD858.1000201@fastcrypt.com>
References: <CE10B12929C8584090A3A10DCA0DAE71137E7BF3@exchstl1.scottrade.com>
	<419CD858.1000201@fastcrypt.com>

On Thu, 18 Nov 2004 12:14:00 -0500
Dave Cramer <pg@fastcrypt.com> wrote:

> Andrew,
> 
> Dell's aren't well known for their disk performance, apparently most
> of the perc controllers sold with dell's are actually adaptec
> controllers. Also apparently they do not come with the battery
> required to use the battery backed up write cache ( In fact according
> to some Dell won't even sell the battery to you). Also Dell's
> monitoring software is quite a memory hog.
> 
> Have you looked at top ?, and also hdparm -Tt /dev/sd?

  I haven't seen any PERC controllers that were really Adaptec ones,
  but I for one quit buying Dell RAID controllers several years ago
  because of poor Linux support and performance.  

  On one machine (not a PostgreSQL server) we saw a 20% speed
  improvement by switching to software raid.  

  If you have a test machine, I would suggest moving the data to a
  box without a RAID controller and see if you get better results. 

 ---------------------------------
   Frank Wiles <frank@wiles.org>
   http://www.wiles.org
 ---------------------------------




view thread (14+ messages)  latest in thread

Message-ID: <20041119151337.477645de.frank@wiles.org>
Permalink:  ../20041119151337.477645de.frank@wiles.org/
Also on:    postgresql.org/message-id/20041119151337.477645de.frank@wiles.org

 · 

reply

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: frank@wiles.org, pg@fastcrypt.com, ajanian@scottrade.com
  Subject: Re: Query Performance and IOWait
  In-Reply-To: <20041119151337.477645de.frank@wiles.org>

* 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