pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Load times on RAID0 compared to RAID5
4+ messages / 4 participants
[nested] [flat]

* Load times on RAID0 compared to RAID5
@ 2003-04-07 14:23  Howard Oblowitz <HowardO@LEWIS-STORES.com>
  0 siblings, 3 replies; 4+ messages in thread

From: Howard Oblowitz @ 2003-04-07 14:23 UTC (permalink / raw)
  To: pgsql-performance

We have a perl program that loads data into Postgres version 7.3.1
using deletes and inserts.

We find that the load times are about 50% slower when we use a
RAID5 disk system as compared to when we use RAID0

Are there any postgres configuration parameters that we can set to improve
the performance on RAID5?




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

* Re: Load times on RAID0 compared to RAID5
@ 2003-04-07 14:36  Andrew Sullivan <andrew@libertyrms.info>
  parent: Howard Oblowitz <HowardO@LEWIS-STORES.com>
  2 siblings, 0 replies; 4+ messages in thread

From: Andrew Sullivan @ 2003-04-07 14:36 UTC (permalink / raw)
  To: pgsql-performance

On Mon, Apr 07, 2003 at 04:23:03PM +0200, Howard Oblowitz wrote:
> We find that the load times are about 50% slower when we use a
> RAID5 disk system as compared to when we use RAID0

Well, given that RAID 5 has to do some calculation and RAID 0
doesn't, I shouldn't think this is very surprising.

You should let us know what disk subsystem you have, &c.  It's
impossible to give any advice on the basis of the little that's here. 
RAID performance is linked to its configuration and the hardware and
software in use.

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] 4+ messages in thread

* Re: Load times on RAID0 compared to RAID5
@ 2003-04-07 15:29  scott.marlowe <scott.marlowe@ihs.com>
  parent: Howard Oblowitz <HowardO@LEWIS-STORES.com>
  2 siblings, 0 replies; 4+ messages in thread

From: scott.marlowe @ 2003-04-07 15:29 UTC (permalink / raw)
  To: Howard Oblowitz <HowardO@LEWIS-STORES.com>; +Cc: pgsql-performance

On Mon, 7 Apr 2003, Howard Oblowitz wrote:

> We have a perl program that loads data into Postgres version 7.3.1
> using deletes and inserts.
> 
> We find that the load times are about 50% slower when we use a
> RAID5 disk system as compared to when we use RAID0
> 
> Are there any postgres configuration parameters that we can set to improve
> the performance on RAID5?

Well, RAID0 SHOULD be about twice as fast as RAID5 for most applications, 
maybe even faster for others.  

Of course, RAID0 offers no redundancy, so if any single drive fails your 
data disappears in a large puff of smoke.  RAID5 can survive a single 
drive failure, and that doesn't come for free.

RAID1 may offer a better compromise of performance and reliability for 
many apps than RAID5.  Generally RAID0 is fastest, RAID1 is fast but can't 
grow to be as big as RAID5, RAID5 handles large parallel access better 
than RAID1, RAID1 handles batch processing better than RAID5.

Mixing them together sometimes helps, sometimes not.  RAID1 on top of 
RAID0 works pretty well but costs the most per meg stored than most plain 
RAID5 or RAID1 setups.




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

* Re: Load times on RAID0 compared to RAID5
@ 2003-04-07 15:31  Josh Berkus <josh@agliodbs.com>
  parent: Howard Oblowitz <HowardO@LEWIS-STORES.com>
  2 siblings, 0 replies; 4+ messages in thread

From: Josh Berkus @ 2003-04-07 15:31 UTC (permalink / raw)
  To: Howard Oblowitz <HowardO@LEWIS-STORES.com>; pgsql-performance

Howard,

> We have a perl program that loads data into Postgres version 7.3.1
> using deletes and inserts.

Might I suggest COPY instead?

-- 
Josh Berkus
Aglio Database Solutions
San Francisco




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


end of thread, other threads:[~2003-04-07 15:31 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-04-07 14:23 Load times on RAID0 compared to RAID5 Howard Oblowitz <HowardO@LEWIS-STORES.com>
2003-04-07 14:36 ` Andrew Sullivan <andrew@libertyrms.info>
2003-04-07 15:29 ` scott.marlowe <scott.marlowe@ihs.com>
2003-04-07 15:31 ` Josh Berkus <josh@agliodbs.com>

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