Re: How to make a REALLY FAST db server? - Mailing list pgsql-general

From Ian Linwood
Subject Re: How to make a REALLY FAST db server?
Date
Msg-id 9urrptosorr0vsf9d9bdnbjdbl4p6vumva@4ax.com
Whole thread Raw
In response to Re: How to make a REALLY FAST db server?  (teg@redhat.com (Trond Eivind Glomsrød))
Responses Re: How to make a REALLY FAST db server?
Re: How to make a REALLY FAST db server?
List pgsql-general
On Mon, 10 Sep 2001 21:14:33 +0000 (UTC), teg@redhat.com (Trond Eivind
Glomsrød) wrote:

>> - Hardware:  dual / quad Intel class
>
>Athlon gives more bang for the buck - the dual Athlons are _really_
>nice, and have proven stable as well.
>
Agreed, single Athlons are much better than single Intels, but I still
think Intel win in the SMP game. As for stability, I think it's a tad
too early to make such a statement.


>> - Disk:  SCSI Raid 1+0
>
>I'd probably go for a 3ware RAID instead... IDE disks are so much
>cheaper nowadays than SCSI, and the premium isn't really justifiable
>anymore.
>
Aargh, No! SCSI is MUCH better under load and more reliable. I've yet
to see an enterprise server utilise IDE raid.

>> - OS:  Prolly FreeBSD (FFS is your friend (what with syncs and all) and it
>> can do multi proc support
>
>I'd recommend Linux, which has more mature MP support and scales
>better, but I'm obviously biased :). It's of course very important to
>keep what you are familiar with - a good sysadmin makes a world of
>difference no matter what you're using.

I'd recommend Solaris, which has MUCH more mature MP support!
Linux still has a way to go (although it's getting there very
quickly).

If you do decide to use Linux, check out ReiserFS file system.



pgsql-general by date:

Previous
From: xavier.goddeeris@dds.delphiauto.com (Xavier Goddeeris)
Date:
Subject: What is a stuck spinlock ?
Next
From: "Lynn Holt"
Date:
Subject: pg_dump problem