RE: [SQL] 2 million+ entries

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(at)scifair(dot)acadiau(dot)ca]
> Sent: Thursday, August 26, 1999 12:49 AM
> To: G. Anthony Reina
> Cc: pgsql-sql(at)postgreSQL(dot)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
>
>
> ************
>