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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: 12 disks raid setup


  • From: "Jignesh K. 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: Fri, 29 Feb 2008 12:17:29 -0500
  • Message-id: <47C83E29.8060701@sun.com> <text/plain>



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




Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group