pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
RAID0 vs RAID1 vs RAID?
2+ messages / 2 participants
[nested] [flat]

* RAID0 vs RAID1 vs RAID?
@ 2005-06-01 13:57 Cris Carampa <cris119@operamail.com>
  2005-06-06 15:33 ` Re: RAID0 vs RAID1 vs RAID? Rodolfo Baselli <rodolfo.baselli@deagostini.it>
  0 siblings, 1 reply; 2+ messages in thread

From: Cris Carampa @ 2005-06-01 13:57 UTC (permalink / raw)
  To: pgsql-admin

Hello all.

I have a production postgresql 7.4.5 database on a HP Proliant ML330 G3 
server, OS: SUSE SLES8, two SCSI disks in RAID1.

I just cloned the same database (same data) on another server. It's 
another HP Proliant ML330 G3 with SUSE SLES8 on but it has the latest 
7.4.x release (7.4.8) and the disks are two ATA disks in RAID0.

The same queries run 6 times faster on the second server!

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?

Thank you. Kind regards,

-- 
Cris Carampa (cris119@operamail.com)
"E` evidente che siamo di fronte allo sfruttamento opportunistico
  di quella quota di astensioni fatalmente derivanti da disinteresse
  o indifferenza." (Gustavo Zagrebelsky)





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: RAID0 vs RAID1 vs RAID?
  2005-06-01 13:57 RAID0 vs RAID1 vs RAID? Cris Carampa <cris119@operamail.com>
@ 2005-06-06 15:33 ` Rodolfo Baselli <rodolfo.baselli@deagostini.it>
  0 siblings, 0 replies; 2+ messages in thread

From: Rodolfo Baselli @ 2005-06-06 15:33 UTC (permalink / raw)
  To: pgsql-admin; +Cc: Cris Carampa <cris119@operamail.com>

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-06-06 15:33 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-06-01 13:57 RAID0 vs RAID1 vs RAID? Cris Carampa <cris119@operamail.com>
2005-06-06 15:33 ` Rodolfo Baselli <rodolfo.baselli@deagostini.it>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox