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