-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Fri, 29 Feb 2008 12:17:29 -0500 "Jignesh K. Shah" <J.K.Shah@xxxxxxx> wrote: > > > 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) I would do this (assuming you have other spindles for the OS): /data1 - RAID 10 journalled filesystem + 1 (so 9 disks) /xlogs - RAID 1 non journalled filesystem + 1 (so 3 disks) You can create any number of tablespaces for further growth you see fit and move them as more IO becomes available. Sincerely, Joshua D. Drake - -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL SPI Liaison | SPI Director | PostgreSQL political pundit -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHyEX6ATb/zqfZUUQRAu1XAKCpszYwF4dbI0hidg71JhmcrPqbmACcDhdc E0qVOtKrUBpEEerGUjTMF9I= =LzZS -----END PGP SIGNATURE----- ---------------------------(end of broadcast)---------------------------TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
