So by that token (more drives the better), I should have raid 5 (or whichever will work) with all 6 drives in it ?
I was thinking about splitting it up like this. I have 6 drives (and one spare). Combine them into 3 separate logical drives in mirrored configuration (for some hardware redundancy).
And use one for base system, and some less frequently read tables, second one for WAL, third one for whatever tables/indexes happen to need separate space (subject to characterisation outcome).
I was basically under impression that separating WAL is a big plus. On top of that, having separate partition to hold some other data - will do too.
But it sounds - from what you said - like having all in single logical drive will work, because raid card will spread the load amongst number of drives.
