Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id F3F072E0116 for ; Fri, 29 Feb 2008 10:19:43 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 86758-03 for ; Fri, 29 Feb 2008 10:19:23 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from el-out-1112.google.com (el-out-1112.google.com [209.85.162.176]) by postgresql.org (Postfix) with ESMTP id B95AD2E00E1 for ; Fri, 29 Feb 2008 10:19:31 -0400 (AST) Received: by el-out-1112.google.com with SMTP id m34so393405ele.23 for ; Fri, 29 Feb 2008 06:19:30 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=OTARP7njrfR+5tacaLlsGvzRDpdVj3+He3vNNaCnSmQ=; b=bYhXPwaGfosAJpDi8I3b/YLTONak9MDF6FV5P4y9srH2xtTlv6eq0bNPvY3ZSLXudx3jvoe2s6GJQl5rmUxG+RfhxLid0AGi/66Ihvf7Eo/dnSA/NKHqPE/EtXq9c+kIvxp9MQRJK9XTLHLCub3nOy3XvfDrAnVOxtB6VdiR5yg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=KoH4SP31xp77F3Fp44eM9BzOFz3Oz/1P1nU3O69qY5wEKMbjyhuOfxXFlBDqCFUrhlr5JtIptNFqLBWpZHI8DJ83wxxU0C8CTztZ7QBs/m5OXAoV+td50mRiA3lPEJXVZ355rq95QPBXmnqD2oIa1kcJjew7U0ChnD83W65NPxg= Received: by 10.114.169.2 with SMTP id r2mr11433245wae.76.1204294392655; Fri, 29 Feb 2008 06:13:12 -0800 (PST) Received: by 10.114.133.6 with HTTP; Fri, 29 Feb 2008 06:13:12 -0800 (PST) Message-ID: Date: Fri, 29 Feb 2008 08:13:12 -0600 From: "Scott Marlowe" To: "Franck Routier" Subject: Re: 12 disks raid setup Cc: pgsql-performance@postgresql.org In-Reply-To: <1204285894.11773.33.camel@franck-gusty> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <1204285894.11773.33.camel@franck-gusty> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/399 X-Sequence-Number: 28941 On Fri, Feb 29, 2008 at 5:51 AM, Franck Routier wrote: > Hi, > > I am in the process of setting up a postgresql server with 12 SAS disks. > > I am considering two options: > > 1) set up a 12 disks raid 10 array to get maximum raw performance from > the system and put everything on it (it the whole pg cluster, including > WAL, and every tablespcace) > > 2) set up 3 raid 10 arrays of 4 disks, and dispatch my data on these > disks via tablespaces : How you set it up depends on your RAID controller as much as anything. Good battery backed RAID controllers seem to work better with one big RAID-10 array. But as with anything, unless you benchmark it, you're really just guessing which is best.