X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 351AA9FB347 for ; Mon, 21 Aug 2006 18:52:01 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 76293-09-2 for ; Mon, 21 Aug 2006 18:51:56 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from servata.com (ip-216-152-249-241.servata.com [216.152.249.241]) by postgresql.org (Postfix) with ESMTP id 982AB9FB3FE for ; Mon, 21 Aug 2006 18:50:58 -0300 (ADT) Received: from [209.162.219.253] (helo=dogma.v10.wvs) by servata.com with esmtpa (Exim 4.50) id 1GFHfa-0002Zk-5r for pgsql-performance@postgresql.org; Mon, 21 Aug 2006 14:50:54 -0700 Subject: Storage Options From: Jeff Davis To: pgsql-performance@postgresql.org Content-Type: text/plain Date: Mon, 21 Aug 2006 14:50:51 -0700 Message-Id: <1156197051.15743.50.camel@dogma.v10.wvs> Mime-Version: 1.0 X-Mailer: Evolution 2.0.4 (2.0.4-7) Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.288 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, SPF_HELO_PASS X-Spam-Level: X-Archive-Number: 200608/323 X-Sequence-Number: 20508 I am trying to decide what kind of storage options to use for a pair of good database servers, a primary and a read-only that can be a failover. Here is what I'm thinking so far: (1) We have a nice NetApp that can do iSCSI. It has a large (multi-GB) battery-backed cache so it could potentially perform the transactions at a very high rate. However there are many other applications accessing the NetApp over NFS, so I am not sure what performance to expect. Any suggestions about using network storage like this for the database? Will the database make huge demands on the NetApp, and force my department spend huge amounts on new NetApp hardware? (2) I read with interest this thread: http://archives.postgresql.org/pgsql-performance/2006-08/msg00164.php Is there any consensus on whether to do WAL on a RAID-1 and PGDATA on a RAID-10 versus everything on a RAID-10? How does the number of disks I have affect this decision (I will probably have 4-8 disks per server). Some of the applications I initially need to support will be a high volume of simple transactions without many tablescans, if that helps. However, I expect that these servers will need to serve many needs. Any other suggestions are appreciated. Is there a common place to look for hardware suggestions (like a postgresql hardware FAQ)? Regards, Jeff Davis