Received: from othello.cnmnetwork.com (othello.cnmnetwork.com [209.79.28.30]) by hub.org (8.9.3/8.9.3) with SMTP id EAA17037 for ; Tue, 24 Aug 1999 04:22:57 -0400 (EDT) (envelope-from rgireyev@cnmnetwork.com) Message-Id: <199908240822.EAA17037@hub.org> Received: (qmail 10217 invoked from network); 24 Aug 1999 01:22:50 -0700 Received: from 209-79-252-178.max-tnt-04.wla.ca.us.cnmnetwork.com (HELO via) (209.79.252.178) by othello.cnmnetwork.com with SMTP; 24 Aug 1999 01:22:50 -0700 From: "Rudy Gireyev" To: Michael Richards , pgsql-sql@postgresql.org Date: Tue, 24 Aug 1999 01:24:54 -0700 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Subject: Re: [SQL] 2 million+ entries Reply-to: rgireyev@cnmnetwork.com Priority: normal References: <99082017435704.17950@kashmir> In-reply-to: X-mailer: Pegasus Mail for Win32 (v3.01d) While we are on the hardware subject, why not replace the PIII with Xeons? Either PII or PIII. Rudy On 24 Aug 99, at 3:30, Michael Richards wrote: > On Fri, 20 Aug 1999, Matthew Hixson wrote: > > > I'm going to be working on a project soon that involves an SQL > > database. If > > I have my way it will be using PostgreSQL 6.5 on a dual PII-350 with 256 > > MB of RAM and two 18GB UW2 SCSI drives (Seagate Barracudas). However > > there is a possibility that it could be running on an NT server with > > even beefier hardware. > If you're planning on doing some heavy database processing and have the > funds, I'd suggest using smaller drives with a RAID controller. Large > drives such as the 18Gb store to much data per platter and as a result end > up a little IO bound when you're doing heavy processing. > > I'd suggest using a *BSD, ie FreeBSD, as it's filsystem performance is > much better than something like ext2. As for the large table size, I ran a > postgres database with 15,000,000 tuples once. It was 6.3, and the vacuum > process was particularily nasty, but I don't think you will have any > problems with 6.5. > > 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... > > If you want to look at another aspect, even if Postgres didn't perform > quite as well as SQL server, consider about $1k for an NT server license > and $2k for a 10 client SQL server license.... put that moolah into > hardware and you're ahead again... > > -Michael > > > ************ > >