Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id D419B2E0077 for ; Wed, 26 Dec 2007 11:14:46 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 05571-05 for ; Wed, 26 Dec 2007 11:14:31 -0400 (AST) Received: from pyxis.powervt.com.ar (host3.powervt.com.ar [200.43.63.66]) by postgresql.org (Postfix) with ESMTP id C78482E00E6 for ; Wed, 26 Dec 2007 11:14:39 -0400 (AST) Received: from pcfhevia ([201.216.249.98]) by pyxis.powervt.com.ar (IPGroup Mail Server) with ESMTP id 1OT48953 for ; Wed, 26 Dec 2007 12:14:37 -0300 From: "Fernando Hevia" To: "'pgsql-performance'" Subject: With 4 disks should I go for RAID 5 or RAID 10 Date: Wed, 26 Dec 2007 12:15:03 -0300 Organization: IP-TEL Message-ID: <0ea101c847d2$16f94bc0$8f01010a@iptel.com.ar> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0EA2_01C847B8.F1AC13C0" X-Mailer: Microsoft Office Outlook 11 Thread-Index: AchH0hW3pWqaNxHJRb2fxqprlGJkJg== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/357 X-Sequence-Number: 28173 This is a multi-part message in MIME format. ------=_NextPart_000_0EA2_01C847B8.F1AC13C0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi list, I am building kind of a poor man's database server: Pentium D 945 (2 x 3 Ghz cores) 4 GB RAM 4 x 160 GB SATA II 7200 rpm (Intel server motherboard has only 4 SATA ports) Database will be about 30 GB in size initially and growing 10 GB per year. Data is inserted overnight in two big tables and during the day mostly read-only queries are run. Parallelism is rare. I have read about different raid levels with Postgres but the advice found seems to apply on 8+ disks systems. With only four disks and performance in mind should I build a RAID 10 or RAID 5 array? Raid 0 is overruled since redundancy is needed. I am going to use software Raid with Linux (Ubuntu Server 6.06). Thanks for any hindsight. Regards, Fernando. ------=_NextPart_000_0EA2_01C847B8.F1AC13C0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable With 4 disks should I go for RAID 5 or RAID 10

Hi list,

I am = building kind of a poor man’s database server:

Pentium = D 945 (2 x 3 Ghz cores)

4 GB = RAM

4 x 160 = GB SATA II 7200 rpm (Intel server motherboard has only 4 SATA ports)

Database will be about 30 GB in size = initially = and growing 10 GB per = year. Data is inserted = overnight = in two big tables = and = during the day = mostly = read-only queries are = run. Parallelism is = rare.

I have read about different raid levels with = Postgres but the advice found seems to apply on 8+ disks = systems. = With = only four disks and = performance in mind should I = build a RAID = 10 or RAID 5 array? Raid 0 is overruled since redundancy is = needed.

I am going to use software Raid with Linux (Ubuntu Server = 6.06).

Thanks for any hindsight.

Regards,

Fernando.

------=_NextPart_000_0EA2_01C847B8.F1AC13C0--