RE: [SQL] 2 million+ entries - Mailing list pgsql-sql

From Michael Richards
Subject RE: [SQL] 2 million+ entries
Date
Msg-id Pine.BSF.4.10.9908271711080.29442-100000@scifair.acadiau.ca
Whole thread Raw
In response to RE: [SQL] 2 million+ entries  (Greg Youngblood <YoungblG@houstoncellular.com>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] Newbie dbadmin out of his league
Next
From: Michael Richards
Date:
Subject: Re: [SQL] Don't need transaction integrity - can I turn it off