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