Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 834EE2E0097 for ; Fri, 29 Feb 2008 08:26:57 -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 73730-01 for ; Fri, 29 Feb 2008 08:26:47 -0400 (AST) X-Greylist: delayed 00:35:16.735819 by SQLgrey-1.7.5 Received: from smtp21.orange.fr (smtp21.orange.fr [80.12.242.49]) by postgresql.org (Postfix) with ESMTP id 60B682E0096 for ; Fri, 29 Feb 2008 08:26:53 -0400 (AST) Received: from smtp21.orange.fr (mwinf2101 [10.232.7.23]) by mwinf2120.orange.fr (SMTP Server) with ESMTP id 5A9611C0D598 for ; Fri, 29 Feb 2008 12:51:37 +0100 (CET) Received: from me-wanadoo.net (localhost [127.0.0.1]) by mwinf2101.orange.fr (SMTP Server) with ESMTP id AEB441C000B0 for ; Fri, 29 Feb 2008 12:51:34 +0100 (CET) Received: from axege.com (LNeuilly-152-22-82-133.w193-251.abo.wanadoo.fr [193.251.23.133]) by mwinf2101.orange.fr (SMTP Server) with ESMTP id 95EC01C000AF for ; Fri, 29 Feb 2008 12:51:34 +0100 (CET) X-ME-UUID: 20080229115134614.95EC01C000AF@mwinf2101.orange.fr Received: from localhost (localhost [127.0.0.1]) by axege.com (Postfix) with ESMTP id 1ED4B4FE27 for ; Fri, 29 Feb 2008 14:02:03 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at myhostname="axege.com." Received: from axege.com ([127.0.0.1]) by localhost (axege.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 0ypZO7mo1HQF for ; Fri, 29 Feb 2008 14:02:02 +0100 (CET) Received: from [10.0.0.69] (unknown [192.168.1.1]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by axege.com (Postfix) with ESMTP id A506C4FE26 for ; Fri, 29 Feb 2008 14:02:02 +0100 (CET) Subject: 12 disks raid setup From: Franck Routier To: pgsql-performance@postgresql.org Content-Type: text/plain Organization: =?ISO-8859-1?Q?Ax=E8ge?= Sarl Date: Fri, 29 Feb 2008 12:51:34 +0100 Message-Id: <1204285894.11773.33.camel@franck-gusty> Mime-Version: 1.0 X-Mailer: Evolution 2.12.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200802/398 X-Sequence-Number: 28940 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 Typical workload is either massive insert/update via ETL or complex queries on big (10 millions tuples) tables with several joins (including Mondrian ROLAP). Does anyone have an opinion of what could give best results ? Thanks, Franck