Re: Optimal Postgres setup with 6 disks total (including OS)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi Josh,
How long is a piece of string?
You will probably find that Raid 1 is almost as fast as Raid 1+0
depending on your application.
In our setup we have Raid 1 for the System volumes, and 1x Raid 1 for
the Xlog, and 6x Raid 1 for the data.
We spread the data across multiple disks based on usage.
Andrew
On 06/12/2006, at 4:59 AM, Josh Bonnett wrote:
Hi, I am looking at buying a server with 6 36gb 15k rpm scsi disks
in it and I was wondering what people would recommend for a disk
setup. The six need to include the os and such. As it is right now
we are thinking 1 4 disk raid 1+0 volume for postgres and 1 raid 1
volume for os and the swap file. Getting a 7th disk is economically
impractical. What do people think? This is a fairly write heavy db
compared to some so I was thinking it would be good to avoid raid 5
or am I wrong here? What do people think?
--
To UNSUBSCRIBE, email to debian-isp-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact
listmaster@lists.debian.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (Darwin)
iD8DBQFFdlqQW126qUNSzvURAlW2AJ9qn8SLp88Ew/JdmvhvdGvRUt/+/QCeOql2
rYPaiKCvr1qZu+re+TUNCe4=
=YsGF
-----END PGP SIGNATURE-----
Reply to: