Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id BEC4E9FB564 for ; Fri, 23 Mar 2007 06:27:41 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 85239-05 for ; Fri, 23 Mar 2007 06:27:33 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.242]) by postgresql.org (Postfix) with ESMTP id D164E9FB33F for ; Fri, 23 Mar 2007 06:27:37 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id c24so1143063ana for ; Fri, 23 Mar 2007 02:27:36 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:from:to:subject:date:user-agent:cc:references:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:message-id; b=hzHLXIFlClKqEINC/Rp+qFdEyzajPBbk9NtJ7BnvLlcYsfB1qcNGquIR3oAo2dsFVRNL10qOmV7JdObJJk23aA9ZCtrQoKh0hYa7A9l7yhbyqagTx5UoB5E0G/ujCMfvrb/KWt6PxPzvy4OWg3v1xvrY+rTS4F7mQ/aW/3PNql4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:from:to:subject:date:user-agent:cc:references:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:message-id; b=Jifw7KD0hIsGWMmolS0E0WA294nRFAJYCaNw7A8F7fhlC+6YFN6yuEJTUZnvxQVJj9fzci2DHaLXOoX6/u89oUJsxm5crDad7dzMIYlhLANfS2Il5ByBQcUyvDPYdk4mg3+BUfoM8HhowkX0YK59FAVbe+WvA/WvOuITyEUGskg= Received: by 10.100.44.13 with SMTP id r13mr2445337anr.1174642056083; Fri, 23 Mar 2007 02:27:36 -0700 (PDT) Received: from ?192.168.5.1? ( [82.253.156.125]) by mx.google.com with ESMTP id c9sm5767831ana.2007.03.23.02.27.34; Fri, 23 Mar 2007 02:27:35 -0700 (PDT) From: Dimitri To: pgsql-performance@postgresql.org Subject: Re: Sunfire X4500 recommendations Date: Fri, 23 Mar 2007 10:28:59 +0100 User-Agent: KMail/1.9.3 Cc: "Matt Smiley" References: <4602D6F1020000280001F213@rtk_gwim1.rentrak.com> In-Reply-To: <4602D6F1020000280001F213@rtk_gwim1.rentrak.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200703231028.59923.dimitrik.fr@gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/361 X-Sequence-Number: 23766 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