RE: [SQL] 2 million+ entries

From: Michael Richards <miker(at)scifair(dot)acadiau(dot)ca>
To: Greg Youngblood <YoungblG(at)houstoncellular(dot)com>
Cc: "G(dot) Anthony Reina" <reina(at)nsi(dot)edu>, pgsql-sql(at)postgreSQL(dot)org
Subject: RE: [SQL] 2 million+ entries
Date: 1999-08-27 21:39:44
Message-ID: Pine.BSF.4.10.9908271711080.29442-100000@scifair.acadiau.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Richards 1999-08-27 21:53:49 Re: [SQL] Don't need transaction integrity - can I turn it off
Previous Message Tom Lane 1999-08-27 21:19:18 Re: [SQL] Newbie dbadmin out of his league