From: Vivek Khera <vivek@khera.org>
To: pgsql-sql@postgresql.org
Subject: Re: getting count for a specific querry
Date: Fri, 8 Apr 2005 16:41:26 -0400
Message-ID: <8ef5bfe4806dac39bab8e07837dbab38@khera.org> (raw)
In-Reply-To: <762e5c05040813354436bd27@mail.gmail.com>
References: <003b01c53c70$6ff184b0$797ba8c0@jfradkin>
<cb3b9f9319ae75a9f8eb756ff38e85e8@khera.org>
<762e5c05040813354436bd27@mail.gmail.com>
On Apr 8, 2005, at 4:35 PM, Bob Henkel wrote:
> desktop SATA drive with no RAID? I'm by any means as knowledgeable
> about I/O
> setup as many of you are but my 2 cents wonders if the Dell RAID is
> really
> that much slower than a competitively priced/speced alternative? Would
> Joel's problems just fade away if he wasn't using a Dell RAID?
>
"Dell RAID" is not one thing. They sell "altered" RAID cards from
Adaptec and LSI. Whatever alteration they do to them tends to make
them run not so fast.
I have a Dell SATA RAID (adaptec based) on the office server and it is
OK, though not something I'd buy again.
I have various PERC 3 and PERC 4 RAID controllers on my servers (SCSI
based) and they suck under heavy I/O load.
I wonder why the name-brand LSI cards work so much faster... perhaps it
is the motherboard? I don't know, and I don't care... :-) For me,
high performance DB and Dell servers are mutually exclusive.
Vivek Khera, Ph.D.
+1-301-869-4449 x806
Attachments:
smime.p7s (application/pkcs7-signature, 2.4K) download
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-sql@postgresql.org
Cc: vivek@khera.org
Subject: Re: getting count for a specific querry
In-Reply-To: <8ef5bfe4806dac39bab8e07837dbab38@khera.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