Re: Inserts optimization? - Mailing list pgsql-performance

From Jim C. Nasby
Subject Re: Inserts optimization?
Date
Msg-id 20060418210356.GH49405@pervasive.com
Whole thread Raw
In response to Re: Inserts optimization?  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-performance
On Fri, Apr 14, 2006 at 03:15:33PM -0500, Scott Marlowe wrote:
> 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.

Sadly, 3ware doesn't produce any controllers with the ability to do an
odd number of channels, so you end up burning through 2 slots to get a
hot spare (unless you spend substantially more money and go with the
next model up).
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-performance by date:

Previous
From: Gavin Hamill
Date:
Subject: Re: Slow query - possible bug?
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Inserts optimization?