[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Tablespaces on a raid configuration

To: "pgsql-performance@xxxxxxxxxxxxxx" <pgsql-performance@xxxxxxxxxxxxxx>
Subject: Tablespaces on a raid configuration
From: "Campbell, Lance" <lance@xxxxxxxxxxxx>
Date: Fri, 30 Mar 2012 14:45:36 +0000
Accept-language: en-US
Thread-index: Ac0Og8xG5PA7zIpITvCoG7jNufjM/Q==
Thread-topic: Tablespaces on a raid configuration

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

Follow-Ups:
- Re: Tablespaces on a raid configuration
  - From: Andrew Dunstan
- Re: Tablespaces on a raid configuration
  - From: Greg Spiegelberg
- Re: Tablespaces on a raid configuration
  - From: ktm@xxxxxxxx

Prev by Date: Re: database slowdown while a lot of inserts occur
Next by Date: Re: Tablespaces on a raid configuration
Previous by thread: database slowdown while a lot of inserts occur
Next by thread: Re: Tablespaces on a raid configuration
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Home] [Yosemite]