Re: Inserts optimization?

From: Michael Stone <mstone+postgres(at)mathom(dot)us>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Inserts optimization?
Date: 2006-04-14 11:49:14
Message-ID: 20060414114911.GG32678@mathom.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Marc Cousin 2006-04-14 12:00:38 Re: Inserts optimization?
Previous Message Francisco Reyes 2006-04-14 11:30:25 Re: Inserts optimization?