Skip site navigation (1) Skip section navigation (2)

Re: Sunfire X4500 recommendations

From: Dimitri <dimitrik(dot)fr(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: "Matt Smiley" <mss(at)rentrak(dot)com>
Subject: Re: Sunfire X4500 recommendations
Date: 2007-03-23 09:28:59
Message-ID: 200703231028.59923.dimitrik.fr@gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
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/ZFS
  http://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

In response to

pgsql-performance by date

Next:From: Tino WildenhainDate: 2007-03-23 12:01:02
Subject: Re: Performance of count(*)
Previous:From: Matt SmileyDate: 2007-03-23 02:20:17
Subject: Sunfire X4500 recommendations

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group