On Fri, Mar 30, 2012 at 9:32 PM, Tomas Vondra wrote:
> And it's not just about fsync operations - WAL is written in sequential
> manner. By placing it on the same device as data files you're
> effectively forcing it to be written randomly, because the the database
> has to write a WAL record, see
On 30.3.2012 16:53, k...@rice.edu wrote:
> On Fri, Mar 30, 2012 at 02:45:36PM +, 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 thos
On Fri, Mar 30, 2012 at 7:53 AM, k...@rice.edu wrote:
> On Fri, Mar 30, 2012 at 02:45:36PM +, 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
>> table
On Fri, Mar 30, 2012 at 10:02 AM, Andrew Dunstan wrote:
> 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.
Yeah, for SSD the equations may change. Parity based RAID has two
problems: perform
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 th
On Fri, Mar 30, 2012 at 8: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?
On Fri, Mar 30, 2012 at 02:45:36PM +, 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 arra
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 differ
