From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Vivek Khera <vivek@khera.org>
Cc: pgsql-sql@postgresql.org
Subject: Re: getting count for a specific querry
Date: Fri, 08 Apr 2005 15:31:02 -0500
Message-ID: <1112992262.20921.81.camel@state.g2switchworks.com> (raw)
In-Reply-To: <cb3b9f9319ae75a9f8eb756ff38e85e8@khera.org>
References: <003b01c53c70$6ff184b0$797ba8c0@jfradkin>
<cb3b9f9319ae75a9f8eb756ff38e85e8@khera.org>
On Fri, 2005-04-08 at 15:23, Vivek Khera wrote:
> On Apr 8, 2005, at 3:23 PM, Joel Fradkin wrote:
>
> > 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.
> >
>
> 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.
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
last job. In a dual 2400Mz machine with 2 gigs ram, it handily outran a
4 way (about 1200 MHz CPUs) windows / MSSQL box with 4 gigs of ram at
most tasks. Especially inserts / updates. The windows machine had the
more generic PERC 3I type controller in it.
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: smarlowe@g2switchworks.com, vivek@khera.org
Subject: Re: getting count for a specific querry
In-Reply-To: <1112992262.20921.81.camel@state.g2switchworks.com>
* 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