Tablespaces on a raid configuration

From: "Campbell, Lance" <lance(at)illinois(dot)edu>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Tablespaces on a raid configuration
Date: 2012-03-30 14:45:36
Message-ID: B75CD08C73BD3543B97E4EF3964B7D701E442099@CITESMBX5.ad.uillinois.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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?

Thanks,

Lance Campbell
Software Architect
Web Services at Public Affairs
217-333-0382

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message ktm@rice.edu 2012-03-30 14:53:48 Re: Tablespaces on a raid configuration
Previous Message Scott Marlowe 2012-03-29 21:36:46 Re: database slowdown while a lot of inserts occur