Re: Disk arrangement in a cheap server - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Disk arrangement in a cheap server
Date
Msg-id dcc563d10711240712o60ce4149h96f7fb421989a2fa@mail.gmail.com
Whole thread Raw
In response to Disk arrangement in a cheap server  (Clodoaldo <clodoaldo.pinto.neto@gmail.com>)
Responses Re: Disk arrangement in a cheap server  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
On Nov 24, 2007 5:09 AM, Clodoaldo <clodoaldo.pinto.neto@gmail.com> wrote:
> I will build a cheap server and I'm in doubt about what would the the
> best for performance:
>
> 1 - everything in one lonely fast 10,000 rpm Raptor HD;
>
> 2 - two cheap 7,200 rpm 16MB cache HDs like this:
>
>     disk 1 - system and pg_xlog
>     disk 2 - pg_data without pg_xlog
>     or a better arrange suggested by you;
>
> 3 - The two cheap HDs above in Raid 0.

From a DBA perspective, none of those seem like a good choice, as
there's no redundancy.

I'd make the two 7200 RPM drives a RAID-1 and have some redundancy so
a single disk failure wouldn't lose all my data.  then I'd start
buying more drives and a good RAID controller if I needed more
performance.

pgsql-general by date:

Previous
From: "Gregory Williamson"
Date:
Subject: Re: Disk arrangement in a cheap server
Next
From: Ron Johnson
Date:
Subject: Re: Disk arrangement in a cheap server