-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Fri, 29 Feb 2008 12:17:29 -0500
"Jignesh K. Shah" <J.K.Shah@sun.com> 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-----