Re: How to make a REALLY FAST db server?

From: Ian Linwood <ian(at)dinwoodi(dot)plus(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to make a REALLY FAST db server?
Date: 2001-09-11 11:17:59
Message-ID: hgrrptkgb8tg242qc6pmm601mkfpdeghpp@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 10 Sep 2001 20:39:18 +0000 (UTC), bpalmer(at)crimelabs(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tille, Andreas 2001-09-11 11:56:16 Re: Performance question
Previous Message J.H.M. Dassen (Ray) 2001-09-11 11:10:32 Re: a plpgsql documentation and samples