drive configuration for a new server

From: Ben <bench(at)silentmedia(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: drive configuration for a new server
Date: 2007-02-02 00:41:35
Message-ID: Pine.LNX.4.64.0702011619240.8626@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I'm looking to replace some old crusty hardware with some sparkling new
hardware. In the process, I'm looking to move away from the previous
mentality of having the Big Server for Everything to having a cluster of
servers, each of which handles some discrete subset of data. But rackspace
isn't inifinte, so I'm leaning towards cases that give me 8 drive bays.
This leaves me with an interesting problem of how to configure these
limited number of drives.

I know that ideally I would have seperate spindles for WAL, indexes, and
data. But I also know that I must be able to survive a drive failure, and
I want at least 1TB of space for my data. I suspect with so few drive
bays, I won't be living in an ideal world.

With an even mix of reads and writes (or possibly more writes than reads),
is it better to use RAID10 and have everything on the same partition, or
to have data and indexes on a 6-drive RAID5 with WAL on its own RAID1?

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Bill Howe 2007-02-02 01:44:21 index scan through a subquery
Previous Message Andrew Lazarus 2007-02-01 22:37:35 Re: Subselect query enhancement