Re: Tablespaces on a raid configuration

On 03/30/2012 10:45 AM, Campbell, Lance wrote:
>
> PostgreSQL 9.0.x
>
> When PostgreSQL  storage is using a relatively large raid  5 or 6
> array is there any value in having your tables distributed across
> multiple tablespaces if those tablespaces will exists on the same raid
> array?  I understand the value if you were to have the tablespaces on
> different raid arrays.  But what about on the same one?
>
>

Not answering your question, but standard advice is not to use RAID 5 or
6, but RAID 10 for databases. Not sure if that still hold if you're
using SSDs.

cheers

andrew