Received: from zeus.houstoncellular.com (zeus.houstoncellular.com [206.109.152.194]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA22909 for ; Thu, 26 Aug 1999 14:06:11 -0400 (EDT) (envelope-from YoungblG@houstoncellular.com) Received: by SCORPGWY1.houstoncell.com with Internet Mail Service (5.5.2232.9) id ; Thu, 26 Aug 1999 13:00:25 -0500 Message-ID: <2B9713A99045D211BB4E0008C7566869DC9D93@SCORPEXC1.houstoncell.com> From: Greg Youngblood To: "'Michael Richards'" , "G. Anthony Reina" Cc: pgsql-sql@postgreSQL.org Subject: RE: [SQL] 2 million+ entries Date: Thu, 26 Aug 1999 13:05:03 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2232.9) Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id OAA22923 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 > > > ************ >