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 5E938535B9
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  8 Apr 2005 21:35:33 +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 35636-03
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  8 Apr 2005 20:35:31 +0000 (GMT)
Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.196])
	by svr1.postgresql.org (Postfix) with ESMTP id EFE11535AF
	for <pgsql-sql@postgresql.org>; Fri,  8 Apr 2005 21:35:30 +0100 (BST)
Received: by wproxy.gmail.com with SMTP id 68so1060818wri
	for <pgsql-sql@postgresql.org>; Fri, 08 Apr 2005 13:35:32 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=o2PmRqgN2kOjfuC+yTj7mgldhZN2y416SzbU7PX2LSCNYm3zZBTNHtkZiFQi0yfJxw7mMaLdjMMshU1xMvHkRms3EmveCcSMrEo/5odY+MwpO6WXhyVtTNt8SUtk2cSipsWzSfh7eFvTregZy2BzJn839wNsaXeRGY43e+0s4uc=
Received: by 10.54.71.17 with SMTP id t17mr303632wra;
	Fri, 08 Apr 2005 13:35:32 -0700 (PDT)
Received: by 10.54.70.11 with HTTP; Fri, 8 Apr 2005 13:35:32 -0700 (PDT)
Message-ID: <762e5c05040813354436bd27@mail.gmail.com>
Date: Fri, 8 Apr 2005 15:35:32 -0500
From: Bob Henkel <luckyratfoot@gmail.com>
Reply-To: Bob Henkel <luckyratfoot@gmail.com>
To: Vivek Khera <vivek@khera.org>
Subject: Re: getting count for a specific querry
Cc: pgsql-sql@postgresql.org
In-Reply-To: <cb3b9f9319ae75a9f8eb756ff38e85e8@khera.org>
Mime-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_26188_3285544.1112992532620"
References: <003b01c53c70$6ff184b0$797ba8c0@jfradkin>
	<cb3b9f9319ae75a9f8eb756ff38e85e8@khera.org>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.383 tagged_above=0 required=5 tests=AWL,
	DNS_FROM_RFC_ABUSE, HTML_20_30, HTML_MESSAGE, RCVD_BY_IP
X-Spam-Level: 
X-Archive-Number: 200504/121
X-Sequence-Number: 21014

------=_Part_26188_3285544.1112992532620
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On Apr 8, 2005 3:23 PM, Vivek Khera <vivek@khera.org> wrote:=20
>=20
>=20
> On Apr 8, 2005, at 3:23 PM, Joel Fradkin wrote:
>=20
> > I set up the data on 4 10k scsi drives in a powervault and my wal on 2
> > 15k
> > drives. I am using links to those from the install directory. It
> > starts and
> > stops ok this way, but maybe it should be different.
> >
>=20
> Your problem might just be the choice of using a Dell RAID controller.
> I have a 1 year old box connected to a 14 disk powervault (PowerEdge
> 2650) and it is dog slow compared to a dual opteron with 8 disks that
> is replacing it. It is all I/O for me, and the dell's just are not
> known for speedy I/O.
>=20
> Vivek Khera, Ph.D.
> +1-301-869-4449 x806
>=20
>=20
> But that is relative I would think. Is the Dell RAID much faster than my=
=20
desktop SATA drive with no RAID? I'm by any means as knowledgeable about I/=
O=20
setup as many of you are but my 2 cents wonders if the Dell RAID is really=
=20
that much slower than a competitively priced/speced alternative? Would=20
Joel's problems just fade away if he wasn't using a Dell RAID?

------=_Part_26188_3285544.1112992532620
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<div><span class=3D"gmail_quote">On Apr 8, 2005 3:23 PM, <b class=3D"gmail_=
sendername">Vivek Khera</b> &lt;<a href=3D"mailto:vivek@khera.org">vivek@kh=
era.org</a>&gt; wrote:</span>
<blockquote class=3D"gmail_quote" style=3D"PADDING-LEFT: 1ex; MARGIN: 0px 0=
px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid"><br>On Apr 8, 2005, at 3:23 PM, =
Joel Fradkin wrote:<br><br>&gt; I set up the data on 4 10k scsi drives in a=
 powervault and my wal on 2<br>&gt; 15k<br>&gt; drives. I am using links to=
 those from the install directory. It<br>&gt; starts and<br>&gt; stops ok t=
his way, but maybe it should be different.<br>&gt;<br><br>Your problem migh=
t just be the choice of using a Dell RAID controller.<br>I have a 1 year ol=
d box connected to a 14 disk powervault (PowerEdge<br>2650) and it is dog s=
low compared to a dual opteron with 8 disks that<br>is replacing it.&nbsp;&=
nbsp;It is all I/O for me, and the dell's just are not<br>known for speedy =
I/O.<br><br>Vivek Khera, Ph.D.<br>+1-301-869-4449 x806<br><br><br></blockqu=
ote></div>
<div>But that is relative I would think.&nbsp; Is the Dell RAID much faster=
 than my desktop SATA drive with no RAID?&nbsp;I'm by any means as knowledg=
eable about I/O setup as many of you are but my 2 cents wonders if&nbsp;the=
 Dell RAID is really that much slower than a competitively priced/speced al=
ternative?&nbsp; Would Joel's problems just fade away if he wasn't using a =
Dell RAID?&nbsp;</div>
<div>&nbsp;</div>
<div><br>&nbsp;</div>
------=_Part_26188_3285544.1112992532620--