pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedopinion 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