Putting the WAL on a second controller does help, if you're write-heavy.
I tried separating indexes and data once on one server and didn't
really notice that it helped much. Managing the space was problematic.
I would suggest putting those together on a single RAID-10 of all the
300GB drives (minus a spare). It will probably outperform separate
arrays most of the time, and be much easier to manage.
--
I like to use RAID 1, and let LVM do the striping. That way I can add
more drives later too.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
