From: Dimitri <dimitrik.fr@gmail.com>
To: pgsql-performance@postgresql.org
Cc: Matt Smiley <mss@rentrak.com>
Subject: Re: Sunfire X4500 recommendations
Date: Fri, 23 Mar 2007 10:28:59 +0100
Message-ID: <200703231028.59923.dimitrik.fr@gmail.com> (raw)
In-Reply-To: <4602D6F1020000280001F213@rtk_gwim1.rentrak.com>
References: <4602D6F1020000280001F213@rtk_gwim1.rentrak.com>
On Friday 23 March 2007 03:20, Matt Smiley wrote:
> My company is purchasing a Sunfire x4500 to run our most I/O-bound
> databases, and I'd like to get some advice on configuration and tuning.
> We're currently looking at: - Solaris 10 + zfs + RAID Z
> - CentOS 4 + xfs + RAID 10
> - CentOS 4 + ext3 + RAID 10
> but we're open to other suggestions.
>
Matt,
for Solaris + ZFS you may find answers to all your questions here:
http://blogs.sun.com/roch/category/ZFShttp://blogs.sun.com/realneel/entry/zfs_and_databases
Think to measure log (WAL) activity and use separated pool for logs if needed.
Also, RAID-Z is more security-oriented rather performance, RAID-10 should be
a better choice...
Rgds,
-Dimitri
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: dimitrik.fr@gmail.com, mss@rentrak.com
Subject: Re: Sunfire X4500 recommendations
In-Reply-To: <200703231028.59923.dimitrik.fr@gmail.com>
* 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