X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id F0E865321A
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  8 Apr 2005 21:43:02 +0100 (BST)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 37296-10
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  8 Apr 2005 20:42:57 +0000 (GMT)
Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com
	[63.87.162.25])
	by svr1.postgresql.org (Postfix) with ESMTP id A518D53622
	for <pgsql-sql@postgresql.org>; Fri,  8 Apr 2005 21:42:55 +0100 (BST)
Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP
	with MS-WebStorage 6.5.6944
Received: from state.g2switchworks.com by mail.g2switchworks.com;
	08 Apr 2005 15:42:57 -0500
Subject: Re: getting count for a specific querry
From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Vivek Khera <vivek@khera.org>
Cc: pgsql-sql@postgresql.org
In-Reply-To: <7501ca328bf49eaf7990583fa6f598bf@khera.org>
References: <003b01c53c70$6ff184b0$797ba8c0@jfradkin>
	<cb3b9f9319ae75a9f8eb756ff38e85e8@khera.org>
	<1112992262.20921.81.camel@state.g2switchworks.com>
	<7501ca328bf49eaf7990583fa6f598bf@khera.org>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
Message-Id: <1112992977.20921.86.camel@state.g2switchworks.com>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) 
Date: Fri, 08 Apr 2005 15:42:57 -0500
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.003 tagged_above=0 required=5 tests=AWL
X-Spam-Level: 
X-Archive-Number: 200504/125
X-Sequence-Number: 21018

On Fri, 2005-04-08 at 15:36, Vivek Khera wrote:
> On Apr 8, 2005, at 4:31 PM, Scott Marlowe wrote:
> 
> > Note that there are several different RAID controllers you can get with
> > a DELL.  I had good luck with the PERC 4C (AMI MegaRAID based) at my
> >
> 
> I've had bad luck regarding speed with *all* of them, AMI MegaRAID and 
> Adaptec based ones, under high load.  Under moderate to low load 
> they're acceptable.

Were you using battery backed cache with write-back enabled on the 4C? 
The 3C is also megaraid based, but it a pretty old design and not very
fast.