Re: RAID0 vs RAID1 vs RAID?

From: Rodolfo Baselli <rodolfo(dot)baselli(at)deagostini(dot)it>
To: pgsql-admin(at)postgresql(dot)org
Cc: Cris Carampa <cris119(at)operamail(dot)com>
Subject: Re: RAID0 vs RAID1 vs RAID?
Date: 2005-06-06 15:33:04
Message-ID: 42A46CB0.7000903@deagostini.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Cris Carampa wrote:
> Is it possible that RAID0 is 6 times faster than RAID1? Since RAID0 has
> no fault tolerance, what is the RAID configuration that gives maximum
> performance and reliability? RAID10?

Short (same old) answer: it depends.
It's no surprise that RAID0 outperforms RAID1 expecially in the write
performance.
Fault tolerance is has its own overhead. A smart RAID controller takes
advantage in read operations in both cases, but it's definitely
different in write operations.
You have to check whether your db configuration or application dml
statements affect the performance tests (eg. they are the most frequent
operations).

Bye

--
Rodolfo Baselli
Wolters Kluver Italia Professionale
"I'm no supervising technician, I'm a technical supervisor." - Homer Simpson

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bruno Wolff III 2005-06-06 16:58:41 Re: Can you help me
Previous Message hubert depesz lubaczewski 2005-06-06 11:04:05 Re: checking if user is connected as a superuser?