From: Fernando Hevia <fhevia@ip-tel.com.ar>
To: 'pgsql-performance' <pgsql-performance@postgresql.org>
Subject: With 4 disks should I go for RAID 5 or RAID 10
Date: Wed, 26 Dec 2007 12:15:03 -0300
Message-ID: <0ea101c847d2$16f94bc0$8f01010a@iptel.com.ar> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: fhevia@ip-tel.com.ar
Subject: Re: With 4 disks should I go for RAID 5 or RAID 10
In-Reply-To: <0ea101c847d2$16f94bc0$8f01010a@iptel.com.ar>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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