Re: OpenBSD 4.0 as a PostgreSQL Database Server
On Wed, Oct 11, 2006 at 03:08:36PM -0500, Sam Fourman Jr. wrote: For those of you that are knowledgeable, and have the time to respond does anyone see any troubles with this hardware selection? I am mostly concerned with the raid Controller selection I am expecting it to have raid 5 across 16 drives with 1 spare the intent is to run a PostgreSQL 8.2 Server with OpenBSD 4.0 when they are both released MotherBoard GIGABYTE GA-4MXSV Socket T (LGA 775) Intel E7230 ATX Server CPUIntel Pentium D 940 Presler 3.2GHz 2 x 2MB L2 Cache LGA 775 Dual Core 16 Raid Drives Western Digital 200GB WD2000JS SATA II 7200RPM 8MB - OEM Raid Card Areca ARC-1260 16-Port PCI Express x8 SATA 3Gb/s RAID Controller - Retail Thank you for any Help Sam Fourman Jr. I know you have your reasons for wanting RAID-5, but check this out: http://www.baarf.com/ -Damian
OpenBSD 4.0 as a PostgreSQL Database Server
For those of you that are knowledgeable, and have the time to respond does anyone see any troubles with this hardware selection? I am mostly concerned with the raid Controller selection I am expecting it to have raid 5 across 16 drives with 1 spare the intent is to run a PostgreSQL 8.2 Server with OpenBSD 4.0 when they are both released MotherBoard GIGABYTE GA-4MXSV Socket T (LGA 775) Intel E7230 ATX Server CPU Intel Pentium D 940 Presler 3.2GHz 2 x 2MB L2 Cache LGA 775 Dual Core 16 Raid Drives Western Digital 200GB WD2000JS SATA II 7200RPM 8MB - OEM Raid Card Areca ARC-1260 16-Port PCI Express x8 SATA 3Gb/s RAID Controller - Retail Thank you for any Help Sam Fourman Jr.
Re: OpenBSD 4.0 as a PostgreSQL Database Server
On 10/11/06, Sam Fourman Jr. [EMAIL PROTECTED] wrote: For those of you that are knowledgeable, and have the time to respond does anyone see any troubles with this hardware selection? I am mostly concerned with the raid Controller selection I am expecting it to have raid 5 across 16 drives with 1 spare You might want to evaluate a multilayer RAID setup with that many drives. I've found 0+1 (striped mirrors) and 0+5 to perform as well as plain RAID 5 but suffer a non-noticable degredation when a drive fails. In an odd note, my 0+1 array on an LSI card actually got faster everytime I pulled out a drive. 16 Raid Drives Western Digital 200GB WD2000JS SATA II 7200RPM 8MB - OEM Get the Raid Edition drives from WD. 1.2million hours MTBF at either 80% or 100% duty cycle. Their consumer-grade drives are only spec'd for 20% duty cycle, and are also less tolerant to temperature (thermal gradient and max operating temp). Raid Card Areca ARC-1260 16-Port PCI Express x8 SATA 3Gb/s RAID Controller - Retail Heard nothing but good stuff about the Areca cards. -- Jon
Re: OpenBSD 4.0 as a PostgreSQL Database Server
Sam Fourman Jr. [EMAIL PROTECTED] wrote: For those of you that are knowledgeable, and have the time to respond does anyone see any troubles with this hardware selection? I am mostly concerned with the raid Controller selection I am expecting it to have raid 5 across 16 drives with 1 spare I would suggest RAID 10 instead of 5 if you don't need 3TB of storage. It tolerates multiple drive failures (usually), and doesn't suffer the performance penalty while degraded that RAID 5 does. And if performance matters, I'd suggest 15k SCSI drives instead of the 7200 RPM SATA drives. Adam