From: Alan Hodgson <ahodgson@simkin.ca>
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
Message-ID: <201101271611.18465@hal.medialogik.com> (raw)
In-Reply-To: <4D41F92F.9030006@missouri.edu>
References: <4D41F92F.9030006@missouri.edu>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ahodgson@simkin.ca
Subject: Re: How to best use 32 15k.7 300GB drives?
In-Reply-To: <201101271611.18465@hal.medialogik.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox