pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Michael Stone <mstone+postgres@mathom.us>
To: pgsql-performance@postgresql.org
Subject: Re: Inserts optimization?
Date: Fri, 14 Apr 2006 07:49:14 -0400
Message-ID: <20060414114911.GG32678@mathom.us> (raw)
In-Reply-To: <cone.1145014225.784898.23930.1000@zoraida.natserv.net>
References: <cone.1144888738.434948.92126.5001@35st-server.simplicato.com>
	<443DA715.4060606@gmail.com>
	<9549.1144903344@sss.pgh.pa.us>
	<cone.1144954763.735087.95544.5001@35st-server.simplicato.com>
	<20060414055923.GX49405@pervasive.com>
	<cone.1145014225.784898.23930.1000@zoraida.natserv.net>

>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



view thread (39+ messages)  latest in thread

Message-ID: <20060414114911.GG32678@mathom.us>
Permalink:  ../20060414114911.GG32678@mathom.us/
Also on:    postgresql.org/message-id/20060414114911.GG32678@mathom.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: mstone+postgres@mathom.us
  Subject: Re: Inserts optimization?
  In-Reply-To: <20060414114911.GG32678@mathom.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox