Re: MVCC for massively parallel inserts - Mailing list pgsql-general

From Greg Stark
Subject Re: MVCC for massively parallel inserts
Date
Msg-id 87k7451u1y.fsf@stark.dyndns.tv
Whole thread Raw
In response to Re: MVCC for massively parallel inserts  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
"Joshua D. Drake" <jd@commandprompt.com> writes:

> Something I have been toying with is getting two of the 12 drive 3Ware cards
> and running RAID 0+1 across them (with LVM). At just under 300 for the cards
> and only 80 bucks a drive (80 Gig)... that is alot of space, and a lot of
> speed for not a lot of money.

Unless I have things backwards, raid 0+1 means if any drive fails the whole
side of the mirror fails. if two drives fail you have a 50/50 chance of the
them being on opposite sides of the mirror and losing the whole thing.

Even if you don't have a double failure, resyncing seems like it would be a
pain in this situation. LVM wouldn't know about the stripe set so it would
mean resyncing the entire 12-disk array on the failed side of the mirror.

I thought it was generally preferable to do Raid 1+0 (aka "raid 10") where any
two drives can fail and as long as they aren't precisely opposite each other
you're still ok. And resyncing just means resyncing the one replacement drive,
not the whole array.

--
greg

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: release notes/Appendix E in documentation
Next
From: Jan Poslusny
Date:
Subject: pg_dump and client_encoding