pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
opinion on RAID choice
10+ messages / 6 participants
[nested] [flat]

* opinion on RAID choice
@ 2003-08-28 21:16 Vivek Khera <khera@kcilink.com>
  2003-08-28 21:26 ` Re: opinion on RAID choice scott.marlowe <scott.marlowe@ihs.com>
  0 siblings, 1 reply; 10+ messages in thread

From: Vivek Khera @ 2003-08-28 21:16 UTC (permalink / raw)
  To: pgsql-performance

I just ran a handful of tests on a 14-disk array on a SCSI hardware
RAID card.



^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: opinion on RAID choice
  2003-08-28 21:16 opinion on RAID choice Vivek Khera <khera@kcilink.com>
@ 2003-08-28 21:26 ` scott.marlowe <scott.marlowe@ihs.com>
  2003-08-29 02:00   ` Re: opinion on RAID choice Vivek Khera <khera@kcilink.com>
  2003-09-02 16:14   ` Re: opinion on RAID choice Andrew Sullivan <andrew@libertyrms.info>
  0 siblings, 2 replies; 10+ messages in thread

From: scott.marlowe @ 2003-08-28 21:26 UTC (permalink / raw)
  To: Vivek Khera <khera@kcilink.com>; +Cc: pgsql-performance

On Thu, 28 Aug 2003, Vivek Khera wrote:

> I just ran a handful of tests on a 14-disk array on a SCSI hardware
> RAID card.

SNIP

> Has anyone else done similar tests of different RAID levels?  What
> were your conclusions?

Yes I have.  I had a 6 disk array plus 2 disks inside my machine (this was 
on a Sparc 20 with 4 narrow SCSI channels and the disks spread across them 
evenly, using RH6.2 and linux sw raid.

My results were about the same as yours, RAID1+0 tended to beat RAID5 at 
reads, while RAID5 tended to win at writes.

There's an old wive's tale that RAID5 has to touch every single disk in a 
stripe when writing, which simply isn't true.  I believe that many old 
controllers (decades back, 286 land kinda stuff) might have done it this 
way, and so people kept thinking this was how RAID5 worked, and avoided 
it.

My experience has been that once you get past 6 disks, RAID5 is faster 
than RAID1+0.




^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: opinion on RAID choice
  2003-08-28 21:16 opinion on RAID choice Vivek Khera <khera@kcilink.com>
  2003-08-28 21:26 ` Re: opinion on RAID choice scott.marlowe <scott.marlowe@ihs.com>
@ 2003-08-29 02:00   ` Vivek Khera <khera@kcilink.com>
  2003-08-29 04:22     ` Re: opinion on RAID choice scott.marlowe <scott.marlowe@ihs.com>
  1 sibling, 1 reply; 10+ messages in thread

From: Vivek Khera @ 2003-08-29 02:00 UTC (permalink / raw)
  To: pgsql-performance

>>>>> "sm" == scott marlowe <scott.marlowe> writes:

sm> My experience has been that once you get past 6 disks, RAID5 is faster 
sm> than RAID1+0.

Any opinion on stripe size for the RAID?



^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: opinion on RAID choice
  2003-08-28 21:16 opinion on RAID choice Vivek Khera <khera@kcilink.com>
  2003-08-28 21:26 ` Re: opinion on RAID choice scott.marlowe <scott.marlowe@ihs.com>
  2003-08-29 02:00   ` Re: opinion on RAID choice Vivek Khera <khera@kcilink.com>
@ 2003-08-29 04:22     ` scott.marlowe <scott.marlowe@ihs.com>
  0 siblings, 0 replies; 10+ messages in thread

From: scott.marlowe @ 2003-08-29 04:22 UTC (permalink / raw)
  To: Vivek Khera <khera@kcilink.com>; +Cc: pgsql-performance

On Thu, 28 Aug 2003, Vivek Khera wrote:

> >>>>> "sm" == scott marlowe <scott.marlowe> writes:
> 
> sm> My experience has been that once you get past 6 disks, RAID5 is faster 
> sm> than RAID1+0.
> 
> Any opinion on stripe size for the RAID?

That's more determined by what kind of data you're gonna be handling.  If 
you want to do lots of little financial transactions, then 32k or less is 
good.  If you're gonna store moderately large text fields and such, then 
going above 32k or 64k is usually a good idea.




^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: opinion on RAID choice
  2003-08-28 21:16 opinion on RAID choice Vivek Khera <khera@kcilink.com>
  2003-08-28 21:26 ` Re: opinion on RAID choice scott.marlowe <scott.marlowe@ihs.com>
@ 2003-09-02 16:14   ` Andrew Sullivan <andrew@libertyrms.info>
  2003-09-02 16:24     ` Re: opinion on RAID choice Larry Rosenman <ler@lerctr.org>
  2003-09-02 16:33     ` Re: opinion on RAID choice Ron Johnson <ron.l.johnson@cox.net>
  1 sibling, 2 replies; 10+ messages in thread

From: Andrew Sullivan @ 2003-09-02 16:14 UTC (permalink / raw)
  To: pgsql-performance

On Thu, Aug 28, 2003 at 03:26:14PM -0600, scott.marlowe wrote:
> 
> My experience has been that once you get past 6 disks, RAID5 is faster 
> than RAID1+0.

Also depends on your filesystem and volume manager.  As near as I can
tell, you do _not_ want to use RAID 5 with Veritas.

A

-- 
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110




^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: opinion on RAID choice
  2003-08-28 21:16 opinion on RAID choice Vivek Khera <khera@kcilink.com>
  2003-08-28 21:26 ` Re: opinion on RAID choice scott.marlowe <scott.marlowe@ihs.com>
  2003-09-02 16:14   ` Re: opinion on RAID choice Andrew Sullivan <andrew@libertyrms.info>
@ 2003-09-02 16:24     ` Larry Rosenman <ler@lerctr.org>
  2003-09-02 16:36       ` Re: opinion on RAID choice Andrew Sullivan <andrew@libertyrms.info>
  1 sibling, 1 reply; 10+ messages in thread

From: Larry Rosenman @ 2003-09-02 16:24 UTC (permalink / raw)
  To: Andrew Sullivan <andrew@libertyrms.info>; pgsql-performance



--On Tuesday, September 02, 2003 12:14:34 -0400 Andrew Sullivan 
<andrew@libertyrms.info> wrote:

> On Thu, Aug 28, 2003 at 03:26:14PM -0600, scott.marlowe wrote:
>>
>> My experience has been that once you get past 6 disks, RAID5 is faster
>> than RAID1+0.
>
> Also depends on your filesystem and volume manager.  As near as I can
> tell, you do _not_ want to use RAID 5 with Veritas.
Out of curiosity, why?

I have Veritas Doc up (since UnixWare has it) at:

http://www.lerctr.org:8458/en/Navpages/FShome.html

if anyone wants to read.

LER

>
> A



-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749




^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: opinion on RAID choice
  2003-08-28 21:16 opinion on RAID choice Vivek Khera <khera@kcilink.com>
  2003-08-28 21:26 ` Re: opinion on RAID choice scott.marlowe <scott.marlowe@ihs.com>
  2003-09-02 16:14   ` Re: opinion on RAID choice Andrew Sullivan <andrew@libertyrms.info>
  2003-09-02 16:24     ` Re: opinion on RAID choice Larry Rosenman <ler@lerctr.org>
@ 2003-09-02 16:36       ` Andrew Sullivan <andrew@libertyrms.info>
  0 siblings, 0 replies; 10+ messages in thread

From: Andrew Sullivan @ 2003-09-02 16:36 UTC (permalink / raw)
  To: pgsql-performance

On Tue, Sep 02, 2003 at 11:24:16AM -0500, Larry Rosenman wrote:
> >tell, you do _not_ want to use RAID 5 with Veritas.
> Out of curiosity, why?

What I keep hearing through various back channels is that, if you pay
folks from Veritas to look at your installation, and they see RAID 5,
they suggest you move it to 1+0.  I haven't any idea why.  It could
be just a matter of preference; it could be prejudice; it could be
baseless faith in the inefficiency of RAID5; it could be they have
stock in a drive company; or it could be they know about some strange
bug that they haven't an idea how to fix.  Nobody's ever been
able/willing to tell me.

A

----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110




^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: opinion on RAID choice
  2003-08-28 21:16 opinion on RAID choice Vivek Khera <khera@kcilink.com>
  2003-08-28 21:26 ` Re: opinion on RAID choice scott.marlowe <scott.marlowe@ihs.com>
  2003-09-02 16:14   ` Re: opinion on RAID choice Andrew Sullivan <andrew@libertyrms.info>
@ 2003-09-02 16:33     ` Ron Johnson <ron.l.johnson@cox.net>
  2003-09-02 16:47       ` Re: opinion on RAID choice Greg Spiegelberg <gspiegelberg@cranel.com>
  1 sibling, 1 reply; 10+ messages in thread

From: Ron Johnson @ 2003-09-02 16:33 UTC (permalink / raw)
  To: pgsql-performance

On Tue, 2003-09-02 at 11:14, Andrew Sullivan wrote:
> On Thu, Aug 28, 2003 at 03:26:14PM -0600, scott.marlowe wrote:
> > 
> > My experience has been that once you get past 6 disks, RAID5 is faster 
> > than RAID1+0.
> 
> Also depends on your filesystem and volume manager.  As near as I can
> tell, you do _not_ want to use RAID 5 with Veritas.

Why should Veritas care?  Or is it that Veritas has a high overhead
of small block writes?

-- 
-----------------------------------------------------------------
Ron Johnson, Jr. ron.l.johnson@cox.net
Jefferson, LA USA

"Millions of Chinese speak Chinese, and it's not hereditary..."
Dr. Dean Edell




^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: opinion on RAID choice
  2003-08-28 21:16 opinion on RAID choice Vivek Khera <khera@kcilink.com>
  2003-08-28 21:26 ` Re: opinion on RAID choice scott.marlowe <scott.marlowe@ihs.com>
  2003-09-02 16:14   ` Re: opinion on RAID choice Andrew Sullivan <andrew@libertyrms.info>
  2003-09-02 16:33     ` Re: opinion on RAID choice Ron Johnson <ron.l.johnson@cox.net>
@ 2003-09-02 16:47       ` Greg Spiegelberg <gspiegelberg@cranel.com>
  2003-09-02 17:33         ` Re: opinion on RAID choice Ron Johnson <ron.l.johnson@cox.net>
  0 siblings, 1 reply; 10+ messages in thread

From: Greg Spiegelberg @ 2003-09-02 16:47 UTC (permalink / raw)
  To: pgsql-performance

Ron Johnson wrote:
> On Tue, 2003-09-02 at 11:14, Andrew Sullivan wrote:
> 
>>On Thu, Aug 28, 2003 at 03:26:14PM -0600, scott.marlowe wrote:
>>
>>>My experience has been that once you get past 6 disks, RAID5 is faster 
>>>than RAID1+0.
>>
>>Also depends on your filesystem and volume manager.  As near as I can
>>tell, you do _not_ want to use RAID 5 with Veritas.
> 
> 
> Why should Veritas care?  Or is it that Veritas has a high overhead
> of small block writes?
> 


I agree with Scott however only when it's hardware RAID 5 and only
certain hardware implementations of it.  A Sun A1000 RAID 5 is not
equal to a Sun T3.  Putting disk technologies aside, the A1000 array
XOR function is in software whereas the T3 is implemented in hardware.
Additionally, most external hardware based RAID systems have some
form of battery backup to ensure all data is written.

Veritas Volume Manager and even Linux, HP-UX and AIX LVM works just
fine when slicing & dicing but not for stitching LUN's together.  IMHO,
if you have the $$ for VxVM buy a hardware based RAID solution as well
and let it do the work.

Greg

-- 
Greg Spiegelberg
  Sr. Product Development Engineer
  Cranel, Incorporated.
  Phone: 614.318.4314
  Fax:   614.431.8388
  Email: gspiegelberg@Cranel.com
Cranel. Technology. Integrity. Focus.





^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: opinion on RAID choice
  2003-08-28 21:16 opinion on RAID choice Vivek Khera <khera@kcilink.com>
  2003-08-28 21:26 ` Re: opinion on RAID choice scott.marlowe <scott.marlowe@ihs.com>
  2003-09-02 16:14   ` Re: opinion on RAID choice Andrew Sullivan <andrew@libertyrms.info>
  2003-09-02 16:33     ` Re: opinion on RAID choice Ron Johnson <ron.l.johnson@cox.net>
  2003-09-02 16:47       ` Re: opinion on RAID choice Greg Spiegelberg <gspiegelberg@cranel.com>
@ 2003-09-02 17:33         ` Ron Johnson <ron.l.johnson@cox.net>
  0 siblings, 0 replies; 10+ messages in thread

From: Ron Johnson @ 2003-09-02 17:33 UTC (permalink / raw)
  To: pgsql-performance

On Tue, 2003-09-02 at 11:47, Greg Spiegelberg wrote:
> Ron Johnson wrote:
> > On Tue, 2003-09-02 at 11:14, Andrew Sullivan wrote:
> > 
> >>On Thu, Aug 28, 2003 at 03:26:14PM -0600, scott.marlowe wrote:
> >>
> >>>My experience has been that once you get past 6 disks, RAID5 is faster 
> >>>than RAID1+0.
> >>
> >>Also depends on your filesystem and volume manager.  As near as I can
> >>tell, you do _not_ want to use RAID 5 with Veritas.
> > 
> > 
> > Why should Veritas care?  Or is it that Veritas has a high overhead
> > of small block writes?
> > 
> 
> 
> I agree with Scott however only when it's hardware RAID 5 and only
> certain hardware implementations of it.  A Sun A1000 RAID 5 is not
> equal to a Sun T3.  Putting disk technologies aside, the A1000 array
> XOR function is in software whereas the T3 is implemented in hardware.
> Additionally, most external hardware based RAID systems have some
> form of battery backup to ensure all data is written.
> 
> Veritas Volume Manager and even Linux, HP-UX and AIX LVM works just
> fine when slicing & dicing but not for stitching LUN's together.  IMHO,
> if you have the $$ for VxVM buy a hardware based RAID solution as well
> and let it do the work.

Ah, shows how isolated, or behind the times, I am.  I thought that
Veritas just handled backups.  Never cared about looking at it to
do anything, else we always use h/w RAID storage controllers.

-- 
-----------------------------------------------------------------
Ron Johnson, Jr. ron.l.johnson@cox.net
Jefferson, LA USA

After listening to many White House, Pentagon & CENTCOM 
briefings in both Gulf Wars, it is my firm belief that most 
"senior correspondents" either have serious agendas that don't 
get shaken by facts, or are dumb as dog feces.




^ permalink  raw  reply  [nested|flat] 10+ messages in thread


end of thread, other threads:[~2003-09-02 17:33 UTC | newest]

Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-08-28 21:16 opinion on RAID choice Vivek Khera <khera@kcilink.com>
2003-08-28 21:26 ` scott.marlowe <scott.marlowe@ihs.com>
2003-08-29 02:00   ` Vivek Khera <khera@kcilink.com>
2003-08-29 04:22     ` scott.marlowe <scott.marlowe@ihs.com>
2003-09-02 16:14   ` Andrew Sullivan <andrew@libertyrms.info>
2003-09-02 16:24     ` Larry Rosenman <ler@lerctr.org>
2003-09-02 16:36       ` Andrew Sullivan <andrew@libertyrms.info>
2003-09-02 16:33     ` Ron Johnson <ron.l.johnson@cox.net>
2003-09-02 16:47       ` Greg Spiegelberg <gspiegelberg@cranel.com>
2003-09-02 17:33         ` Ron Johnson <ron.l.johnson@cox.net>

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