Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id DA4521337BA5 for ; Thu, 27 Jan 2011 20:11:31 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 78994-01 for ; Fri, 28 Jan 2011 00:11:25 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from zeus.simkin.ca (zeus.simkin.ca [72.51.27.124]) by mail.postgresql.org (Postfix) with ESMTP id 7141B1337BA4 for ; Thu, 27 Jan 2011 20:11:24 -0400 (AST) Received: from charon.medialogik.com (S0106000c6eb33e73.vc.shawcable.net [96.49.227.24]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by zeus.simkin.ca (Postfix) with ESMTPSA id A58F827003B for ; Thu, 27 Jan 2011 16:11:22 -0800 (PST) From: Alan Hodgson Organization: Simkin Network Consulting To: pgsql-performance@postgresql.org Subject: Re: How to best use 32 15k.7 300GB drives? Date: Thu, 27 Jan 2011 16:11:18 -0800 User-Agent: KMail/1.13.5 (Linux/2.6.35-24-generic; KDE/4.5.1; i686; ; ) References: <4D41F92F.9030006@missouri.edu> In-Reply-To: <4D41F92F.9030006@missouri.edu> X-KMail-Markup: true MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="Boundary-01=_mmgQNYExG4ChcxN" Content-Transfer-Encoding: 7bit Message-Id: <201101271611.18465@hal.medialogik.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.909 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201101/305 X-Sequence-Number: 42092 --Boundary-01=_mmgQNYExG4ChcxN Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit On January 27, 2011, Robert Schnabel wrote: > So my questions are 1) am I'm crazy for doing this, 2) would you change > anything and 3) is it acceptable to put the xlog & wal (and perhaps tmp > filespace) on a different controller than everything else? Please keep > in mind I'm a geneticist who happens to know a little bit about > bioinformatics and not the reverse. :-) > Putting the WAL on a second controller does help, if you're write-heavy. I tried separating indexes and data once on one server and didn't really notice that it helped much. Managing the space was problematic. I would suggest putting those together on a single RAID-10 of all the 300GB drives (minus a spare). It will probably outperform separate arrays most of the time, and be much easier to manage. -- A hybrid Escalade is missing the point much in the same way that having a diet soda with your extra large pepperoni pizza is missing the point. --Boundary-01=_mmgQNYExG4ChcxN Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: 7bit

On January 27, 2011, Robert Schnabel <schnabelr@missouri.edu> wrote:

> So my questions are 1) am I'm crazy for doing this, 2) would you change

> anything and 3) is it acceptable to put the xlog & wal (and perhaps tmp

> filespace) on a different controller than everything else? Please keep

> in mind I'm a geneticist who happens to know a little bit about

> bioinformatics and not the reverse. :-)

Putting the WAL on a second controller does help, if you're write-heavy.

I tried separating indexes and data once on one server and didn't really notice that it helped much. Managing the space was problematic. I would suggest putting those together on a single RAID-10 of all the 300GB drives (minus a spare). It will probably outperform separate arrays most of the time, and be much easier to manage.

A hybrid Escalade is missing the point much in the same way that having a diet soda with your extra large pepperoni pizza is missing the point.

--Boundary-01=_mmgQNYExG4ChcxN--