Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 435322E0231 for ; Fri, 29 Feb 2008 13:24:31 -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 18543-03 for ; Fri, 29 Feb 2008 13:24:26 -0400 (AST) X-Greylist: delayed 00:06:37.172473 by SQLgrey-1.7.5 Received: from brmea-mail-4.sun.com (brmea-mail-4.Sun.COM [192.18.98.36]) by postgresql.org (Postfix) with ESMTP id 2BCE12E01FE for ; Fri, 29 Feb 2008 13:24:27 -0400 (AST) Received: from fe-amer-09.sun.com ([192.18.109.79]) by brmea-mail-4.sun.com (8.13.6+Sun/8.12.9) with ESMTP id m1THHmbL029956 for ; Fri, 29 Feb 2008 17:17:48 GMT Received: from conversion-daemon.mail-amer.sun.com by mail-amer.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) id <0JX000201F8A4F00@mail-amer.sun.com> (original mail from J.K.Shah@Sun.COM) for pgsql-performance@postgresql.org; Fri, 29 Feb 2008 10:17:48 -0700 (MST) Received: from jignesh-shahs-computer.local ([129.150.34.249]) by mail-amer.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) with ESMTPSA id <0JX000FEOG14JA00@mail-amer.sun.com>; Fri, 29 Feb 2008 10:17:29 -0700 (MST) Date: Fri, 29 Feb 2008 12:17:29 -0500 From: "Jignesh K. Shah" Subject: Re: 12 disks raid setup In-reply-to: <1204285894.11773.33.camel@franck-gusty> To: Franck Routier Cc: pgsql-performance@postgresql.org Message-id: <47C83E29.8060701@sun.com> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7BIT References: <1204285894.11773.33.camel@franck-gusty> User-Agent: Thunderbird 2.0.0.9 (Macintosh/20071031) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/402 X-Sequence-Number: 28944 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 : > > data1 = pg cluster + references data (dimensions) tablespace > data2 = fact data tablespace > data3 = indices tablespace > > > Option 2: Infact I would also say within one of the RAID1 use another softpartition and separate out pg_xlog also. My 2 cents based on my benchmarks. -Jignesh