Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Marc CousinDate: 2006-04-14 12:00:38
Subject: Re: Inserts optimization?
Previous:From: Francisco ReyesDate: 2006-04-14 11:30:25
Subject: Re: Inserts optimization?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group