Re: Inserts optimization? - Mailing list pgsql-performance

From Michael Stone
Subject Re: Inserts optimization?
Date
Msg-id 20060414114911.GG32678@mathom.us
Whole thread Raw
In response to Re: Inserts optimization?  (Francisco Reyes <lists@stringsutils.com>)
List pgsql-performance
>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

pgsql-performance by date:

Previous
From: Francisco Reyes
Date:
Subject: Re: Inserts optimization?
Next
From: Marc Cousin
Date:
Subject: Re: Inserts optimization?