Re: Inserts optimization?

[Michael Stone <mstone+postgres(at)mathom(dot)us>]

> On Thu, Apr 13, 2006 at 02:59:23PM -0400, Francisco Reyes wrote:
> > In RAID 10 would it matter that WALL is in the same RAID set?
> > Would it be better:
> > 4 disks in RAID10 Data
> > 2 disks RAID 1 WALL
> > 2 hot spares

I guess the first question is why 2 hot spares? You don't have many 
spindles, so you don't want to waste them. It might turn out that a 
larger array with more spindles with outperform a smaller one with 
fewer, regardless of RAID level (assuming a decent battery-backed 
cache). You might try 
5 RAID5
2 RAID1
1 spare

Mike Stone