Re: autovacuum - Mailing list pgsql-general

From Gregory Stark
Subject Re: autovacuum
Date
Msg-id 87vea59ehw.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: autovacuum  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-general
"Scott Marlowe" <scott.marlowe@gmail.com> writes:

> RAID5 optimizes for space, not performance or reliability.  It gets
> faster but less reliable as it gets bigger.  If you can afford the
> space RAID-10 is generally preferred.

RAID5 can be faster for DSS style work loads. If you're writing data to the
raid in large contiguous chunks then it you get higher bandwidth than RAID1+0.

The problem with RAID5 is that if you're writing random access chunks then
it's even slower than not having a raid at all.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Adding domain type with CHECK constraints slow on large table
Next
From: "Merlin Moncure"
Date:
Subject: Re: Migration from PervasiveSQL