| From: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
|---|---|
| To: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
| Cc: | Francisco Reyes <lists(at)stringsutils(dot)com>, Michael Stone <mstone+postgres(at)mathom(dot)us>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Inserts optimization? |
| Date: | 2006-04-18 21:03:56 |
| Message-ID: | 20060418210356.GH49405@pervasive.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2006-04-18 21:10:05 | Re: Inserts optimization? |
| Previous Message | Gavin Hamill | 2006-04-18 20:26:28 | Re: Slow query - possible bug? |