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

From G. Anthony Reina
Subject Re: [SQL] 2 million+ entries
Date
Msg-id 37C420F2.95BB72E6@nsi.edu
Whole thread Raw
Responses Re: [SQL] 2 million+ entries  (Bruce Momjian <maillist@candle.pha.pa.us>)
Re: [SQL] 2 million+ entries  (Michael Richards <miker@scifair.acadiau.ca>)
Re: [SQL] 2 million+ entries  (Michael Richards <miker@scifair.acadiau.ca>)
List pgsql-sql
Michael Richards 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?

-Tony




pgsql-sql by date:

Previous
From: Heiko Wilms
Date:
Subject: harddisk crash
Next
From: Bruce Momjian
Date:
Subject: Re: [SQL] 2 million+ entries