Skip site navigation (1) Skip section navigation (2)

Re: 12 disks raid setup

From: "Jignesh K(dot) Shah" <J(dot)K(dot)Shah(at)sun(dot)com>
To: Franck Routier <franck(dot)routier(at)axege(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: 12 disks raid setup
Date: 2008-02-29 17:17:29
Message-ID: 47C83E29.8060701@sun.com (view raw or flat)
Thread:
Lists: pgsql-performance

Franck Routier wrote:
> Hi,
>
> I am in the process of setting up a postgresql server with 12 SAS disks.
>
> I am considering two options:
>
> 1) set up a 12 disks raid 10 array to get maximum raw performance from
> the system and put everything on it (it the whole pg cluster, including
> WAL, and every tablespcace)
>
> 2) set up 3 raid 10 arrays of 4 disks, and dispatch my data on these
> disks via tablespaces :
>
> data1 = pg cluster + references data (dimensions) tablespace
> data2 = fact data tablespace
> data3 = indices tablespace
>
>
>   

Option 2: Infact I would also say within one of the RAID1 use another 
softpartition and separate out pg_xlog also.

My 2 cents based on my benchmarks.

-Jignesh


In response to

Responses

pgsql-performance by date

Next:From: Joshua D. DrakeDate: 2008-02-29 17:50:50
Subject: Re: 12 disks raid setup
Previous:From: Greg SmithDate: 2008-02-29 15:41:08
Subject: Re: 12 disks raid setup

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group