Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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.


In response to

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group