| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2008-02-29 17:50:50 | Re: 12 disks raid setup |
| Previous Message | Greg Smith | 2008-02-29 15:41:08 | Re: 12 disks raid setup |