From: Greg Youngblood <YoungblG@houstoncellular.com>
To: 'Michael Richards' <miker@scifair.acadiau.ca>
To: G. Anthony Reina <reina@nsi.edu>
Cc: pgsql-sql@postgreSQL.org
Subject: RE: [SQL] 2 million+ entries
Date: Thu, 26 Aug 1999 13:05:03 -0500
Message-ID: <2B9713A99045D211BB4E0008C7566869DC9D93@SCORPEXC1.houstoncell.com> (raw)
Which DPT controller do you have, how many SCSI buses, and how much cache?
I've got the I2O 3754U2 SmartRAID V with 64 meg on a single SCSI chain, also
connected to 4 9.1 baracuda (7200rpm) seagates. I'm about to add 2 more SCSI
chains, bump up the cache to 256 meg, and put in 4 seagate 50.1 gig drives.
If you've got the I2O model of the controller card, what OS are you running?
If it's Linux, did you have any problems getting the I2O driver to recognize
the card on bootup? I ended up having to load it as a module.
Thanks,
Greg
Gregory S. Youngblood
ext 2164
> -----Original Message-----
> From: Michael Richards [mailto:miker@scifair.acadiau.ca]
> Sent: Thursday, August 26, 1999 12:49 AM
> To: G. Anthony Reina
> Cc: pgsql-sql@postgreSQL.org
> Subject: Re: [SQL] 2 million+ entries
>
>
> On Wed, 25 Aug 1999, G. Anthony Reina wrote:
>
> > > We're currently testing a system with about 1.2 million
> records with 6.5
> > > and it outperforms SQL server 6 by quite a lot. It's
> running on a dual P3
> > > with a 4 9.1 gig Cheetah array on a DPT controller
> running RAID0. I'm
> > > pretty happy with it...
> >
> > Great balls of fire! A dual P3 with a four 9.1 Gig RAID0
> Cheetah array?
> > That's fantastic! How much did that set you back? Are there
> any special
> > quirks about using Postgres on a multiple processor, multiple disk
> > system?
> As I recall it was about $8k CAD. The system purrs. I'm
> especially happy
> with the DPT controller. This would be a truly worthy machine
> for a large
> news feed.
>
> -Michael
>
>
> ************
>
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: YoungblG@houstoncellular.com, miker@scifair.acadiau.ca, reina@nsi.edu
Subject: Re: [SQL] 2 million+ entries
In-Reply-To: <2B9713A99045D211BB4E0008C7566869DC9D93@SCORPEXC1.houstoncell.com>
References: <2B9713A99045D211BB4E0008C7566869DC9D93@SCORPEXC1.houstoncell.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