| From: | "ktm(at)rice(dot)edu" <ktm(at)rice(dot)edu> |
|---|---|
| To: | "Campbell, Lance" <lance(at)illinois(dot)edu> |
| Cc: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Tablespaces on a raid configuration |
| Date: | 2012-03-30 14:53:48 |
| Message-ID: | 20120330145348.GS2533@aart.rice.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Fri, Mar 30, 2012 at 02:45:36PM +0000, 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?
>
>
> Thanks,
>
> Lance Campbell
> Software Architect
> Web Services at Public Affairs
> 217-333-0382
>
I have seen previous discussions about using different filesystems versus
a single filesystem and one advantage that multiple tablespaces have is
that an fsync on one table/tablespace would not block or be blocked by
an fsync on a different table/tablespace at the OS level.
Regards,
Ken
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Spiegelberg | 2012-03-30 15:02:21 | Re: Tablespaces on a raid configuration |
| Previous Message | Campbell, Lance | 2012-03-30 14:45:36 | Tablespaces on a raid configuration |