X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 4B28111F6D2A
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Fri, 14 Apr 2006 17:15:37 -0300 (ADT)
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Score: 0.119
X-Spam-Level: 
X-Spam-Status: No, score=0.119 required=5 tests=[AWL=0.118,
	UNPARSEABLE_RELAY=0.001]
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id BqhXb1cJpFdY
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Fri, 14 Apr 2006 17:15:32 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from exchange.g2switchworks.com (mail.g2switchworks.com
	[63.87.162.25])
	by postgresql.org (Postfix) with ESMTP id 3D94F11F7330
	for <pgsql-performance@postgresql.org>;
	Fri, 14 Apr 2006 17:15:33 -0300 (ADT)
Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com
	([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ;
	Fri, 14 Apr 2006 20:15:33 +0000
Received: from state.g2switchworks.com by mail.g2switchworks.com;
	14 Apr 2006 15:15:33 -0500
Subject: Re: Inserts optimization?
From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Francisco Reyes <lists@stringsutils.com>
Cc: Michael Stone <mstone+postgres@mathom.us>,
 pgsql-performance@postgresql.org
In-Reply-To: <cone.1145045358.517551.283.5001@35st-server.simplicato.com>
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>
	<20060414114911.GG32678@mathom.us>
	<cone.1145037716.354055.283.5001@35st-server.simplicato.com>
	<20060414190620.GH32678@mathom.us>
	<cone.1145045358.517551.283.5001@35st-server.simplicato.com>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
Message-Id: <1145045732.23538.86.camel@state.g2switchworks.com>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) 
Date: Fri, 14 Apr 2006 15:15:33 -0500
X-Archive-Number: 200604/345
X-Sequence-Number: 18429

On Fri, 2006-04-14 at 15:09, Francisco Reyes wrote:
> Michael Stone writes:
> 
> > I still don't follow that. Why would the RAID level matter? IOW, are you 
> > actually wanting 2 spares, or are you just stick with that because you 
> > need a factor of two disks for your mirrors?
> 
> RAID 10 needs pairs.. so we can either have no spares or 2 spares.

Spares are placed in service one at a time.  You don't need 2 spares for
RAID 10, trust me.