How are you going to make use of the three faster drives under
postgresql? Were you intending to put the WAL, system/swap, and the
actual data files on separate drives/partitions? Unless you do
something like that (or s/w RAID to distribute the processing across the
disks), you really have ONE SCSI 15K Ultra320 drive against 3 slower
drives with the RAID overhead (and spreading of performance because of
the multiple heads).
I don't have specifics here, but I'd expect that the RAID5 on slower
drives would work better for apps with lots of selects or lots of
concurrent users. I suspect that the Ultra320 would be better for batch
jobs and mostly transactions with less selects.
Charlie
Rajesh Kumar Mallah. wrote:
>Hi folks,
>
>I have two options:
>3*18 GB 10,000 RPM Ultra160 Dual Channel SCSI controller + H/W Raid 5
>and
>2*36 GB 15,000 RPM Ultra320 Dual Channel SCSI and no RAID
>
>Does anyone opinions *performance wise* the pros and cons of above
>two options.
>
>please take in consideration in latter case its higher RPM and better
>SCSI interface.
>
>
>
>Regds
>Mallah.
>
>
>
>
>
>
--
Charles H. Woloszynski
ClearMetrix, Inc.
115 Research Drive
Bethlehem, PA 18015
tel: 610-419-2210 x400
fax: 240-371-3256
web: www.clearmetrix.com
