Thread: 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@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
> 
> 
> ************
> 

On Thu, 26 Aug 1999, Greg Youngblood wrote:

> Which DPT controller do you have, how many SCSI buses, and how much cache?
That machine has the 2144UW on it. I put the max for that card (64mb EDO)
cache on it. 

> 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. 
I'd do some solid performance testing on that card before upgrading to 256
megs of cache. (I didn't even know that model would take that amount) It
certainly sounds like overkill to me. I went with the 64 megs only because
I had a cheap source for the RAM. It is certainly more than we needed at
the time...

> 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.

Because of the filesystem performance problems with linux's ext2
filesystem we opted to go FreeBSD instead.

-Michael