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 hgrrptkgb8tg242qc6pmm601mkfpdeghpp@4ax.com
Whole thread Raw
In response to Re: How to make a REALLY FAST db server?  ("B. Palmer" <bpalmer@crimelabs.net>)
List pgsql-general
On Mon, 10 Sep 2001 20:39:18 +0000 (UTC), bpalmer@crimelabs.net ("B.
Palmer") wrote:

>>Not sure about that.  Is that optimal for I/O?
>
From my experience it is.  As long as you have a raid controler that
>can do 2 level RAID abstraction.  First you need mirrored pairs and
>then you stripe over them.  It costs a lot in disk,  but is stupid fast
>with the right raid controller.  With some Suns / FC / EMC,  we were
>getting ~100M/s+ with that setup for our Oracle server.

Agreed. I've seen 2-3 times speed improvement over raid5.

pgsql-general by date:

Previous
From: peace_flower
Date:
Subject: Where do they find the time??? Great Bridge closed now!!!??
Next
From: Jeff Patterson
Date:
Subject: query help